Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MySQL Programming Interview Question:
How To Create a Test Table in Your MySQL Server?
Submitted by: AdministratorIf you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial:
>cd mysqlin
>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 8 to server version: 5.0.24-
mysql> use test
Database changed
mysql> CREATE TABLE test (message VARCHAR(80));
Query OK, 0 rows affected (0.13 sec)
mysql> INSERT INTO test
-> VALUES ('Welcome to GlobalGuideLine.com');
Query OK, 1 row affected (0.03 sec)
mysql> SELECT * FROM test;
<pre>+---------------------------------+
| message |
+---------------------------------+
| Welcome to GlobalGuideLine.come |
+---------------------------------+</pre>
1 row in set (0.00 sec)
mysql> DROP TABLE test;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
Submitted by: Administrator
>cd mysqlin
>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 8 to server version: 5.0.24-
mysql> use test
Database changed
mysql> CREATE TABLE test (message VARCHAR(80));
Query OK, 0 rows affected (0.13 sec)
mysql> INSERT INTO test
-> VALUES ('Welcome to GlobalGuideLine.com');
Query OK, 1 row affected (0.03 sec)
mysql> SELECT * FROM test;
<pre>+---------------------------------+
| message |
+---------------------------------+
| Welcome to GlobalGuideLine.come |
+---------------------------------+</pre>
1 row in set (0.00 sec)
mysql> DROP TABLE test;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.