Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Use MySQL Command Line Interface
How To Use MySQL Command Line Interface? - PHP Script Tips - Working with MySQL Database
✍: 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
2007-04-18, 5061👍, 0💬
Popular Posts:
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the da...
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access ...
Where Is the Submitted Form Data Stored? - PHP Script Tips - Processing Web Forms When a user submit...
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you d...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...