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, 4529👍, 0💬
Popular Posts:
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
Write an equivalent expression for x%8? x&7
What is continuous and staged representation? CMMI contains 25 key process areas which organization ...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
How can method defined in multiple base classes with same name be invoked from derived class simulta...