Tools, FAQ, Tutorials:
Using MySQL Command Line Interface in PHP
How To Use MySQL Command Line Interface in PHP?
✍: FYIcenter.com
MySQL server comes with a command line interface, which will allow you to operate with the server with SQL statements and other commands. To start the command line interface, you can run the \mysql\bin\mysql program. The tutorial exercise below shows you how to use the command line interface to create a table and insert a row to table:
>\mysql\bin\mysql Welcome to the MySQL monitor. Commands end with ; or \g. mysql> use test; Database changed mysql> CREATE TABLE fyi_links (url varchar(80)); Query OK, 0 rows affected (0.58 sec) mysql> INSERT INTO fyi_links VALUES ('dev.fyicenter.com'); Query OK, 1 row affected (0.38 sec) mysql> SELECT * FROM fyi_links; +-------------------+ | url | +-------------------+ | dev.fyicenter.com | +-------------------+ 1 row in set (0.00 sec) mysql> DROP TABLE fyi_links; Query OK, 0 rows affected (0.34 sec) mysql> quit; Bye
⇒ Information Needed for MySQL Connection in PHP
⇐ Installing MySQL Server in PHP
2016-10-22, 1803🔥, 0💬
Popular Posts:
How to use "{{...}}" Liquid Codes in "set-body" Policy Statement? The "{{...}}" Liquid Codes in "set...
How to add request URL Template Parameters to my Azure API operation to make it more user friendly? ...
How to use the "forward-request" Policy Statement to call the backend service for an Azure API servi...
Can You Specify the "new line" Character in Single-Quoted Strings? You can not specify the "new line...
How to dump (or encode, serialize) a Python object into a JSON string using json.dumps()? The json.d...