Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 5293👍, 0💬
Popular Posts:
How to create a thread in a program? You have two ways to do so. First, making your class "extends" ...
Can you please post OpenLink Endur related FAQ's,tutorials,document s.Thanks
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? If a ta...
What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Name...
How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle se...