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" to Run SQL Statements
How To Use "mysql" to Run SQL Statements? - MySQL FAQs - Administrator Tools for Managing MySQL Server
✍: FYIcenter.com
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
2007-05-11, 4744👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int x=5; printf("%d,%d,%d\n",x,x. ..
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...
Can you explain in GSC and VAF in function points? In GSC (General System Characteristic) there are ...
What is the difference between Class and structure’s ? Following are the key differences between the...
.NET INTERVIEW QUESTIONS - What is the difference between System exceptions and Application exceptio...