MySQL Programming Question:

Download Job Interview Questions and Answers PDF

How To Use "mysql" to Run SQL Statements?

MySQL Programming Interview Question
MySQL Programming Interview Question

Answer:

If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to run two SQL statements with "mysql":

>cd mysqlin
>mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 5.0.24

mysql> CREATE TABLE links (name VARCHAR(80));
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO links VALUES ('www.GlobalGuideLine.com');
Query OK, 1 row affected (0.02 sec)

mysql> quit;
Bye


Download MySQL Programming Interview Questions And Answers PDF

Previous QuestionNext Question
How To Shut Down the Server with "mysqladmin"?How To Show All Tables with "mysql"?