Use "mysql" to Run SQL Statements in MySQL

Q

How To Use "mysql" to Run SQL Statements in MySQL?

✍: FYIcenter.com

A

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 \mysql\bin
>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 ('dba.fyicenter.com');
Query OK, 1 row affected (0.02 sec)

mysql> quit;
Bye

 

Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-17, 200👍, 0💬