Software QA (13)
SQL Server (1)
How To Use "mysql" to Run SQL Statements
How To Use "mysql" to Run SQL Statements? - MySQL FAQs - Administrator Tools for Managing MySQL Server
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, 4639👍, 0💬
How To Compare Two Strings with strcmp()? - PHP Script Tips - PHP Built-in Functions for Strings PHP...
How can a servlet refresh automatically if some new data has entered the database? You can use a cli...
What is effort variance? Effort Variance = (Actual effort – Estimated Effort) / Estimated Effort.
What is the purpose of the wait(), notify(), and notifyAll() methods? The wait(),notify(), and notif...
What is a fish bone diagram ? Dr. Kaoru Ishikawa, invented the fishbone diagram. Therefore, it can b...