How To Use "mysql" To Run SQL Statements

How To Use "mysql" To Run SQL Statements


  • 26 Feb, 2012

    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 in>mysql -u root testWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 4 to server version: 5.0.24mysql> 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

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.