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, 4679👍, 0💬
Popular Posts:
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...
If client side validation is enabled in your Web page, does that mean server side code is not run? W...
What is difference between custom JSP tags and JavaBeans? Custom JSP tag is a tag you defined. You d...
How can you implement MVC pattern in ASP.NET? The main purpose using MVC pattern is to decouple the ...
How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By d...