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 Create a Test Table in Your MySQL Server
How To Create a Test Table in Your MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows
✍: FYIcenter.com
If you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial:
>cd \mysql\bin >mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 5.0.24- mysql> use test Database changed mysql> CREATE TABLE test (message VARCHAR(80)); Query OK, 0 rows affected (0.13 sec) mysql> INSERT INTO test -> VALUES ('Welcome to FYIcenter.com'); Query OK, 1 row affected (0.03 sec) mysql> SELECT * FROM test; +---------------------------+ | message | +---------------------------+ | Welcome to FYIcenter.come | +---------------------------+ 1 row in set (0.00 sec) mysql> DROP TABLE test; Query OK, 0 rows affected (0.01 sec) mysql> quit Bye
2007-05-10, 4441👍, 0💬
Popular Posts:
Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQ...
Can you explain Forms authentication in detail ? In old ASP if you where said to create a login page...
What will be printed as the resultof the operation below: int x; int modifyvalue() { return(x+=10); ...
How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...
How can a servlet refresh automatically if some new data has entered the database? You can use a cli...