mySQL简单创建数据库、表、改变数据库路径

创建数据库：
mysql>create database test;
Query OK, 1 row affected (0.02 sec)
创建数据库表：
mysql>use test;
Database changed
创建数据库表：
myaql>create table user(SID VARCHAR(11), name VARCHAT(6) );
Query OK, 0 rows affected (0.08 sec)
插入记录：
mysql>insert int user values('20081302020', '许琴琴');
Query OK, 1 row affected (0.05 sec)
查询记录：
mysql>select * from user;
+-------------+--------+
| id               | name   |
+-------------+--------+
| 20081302020 | 许琴琴 |
+-------------+--------+
1 row in set (0.00 sec)
查看文件路径：
mysql>show variables like '%dir%';
+----------------------------+--------------------------------------------------
---------------------------------+
| Variable_name              | Value
                                 |
+----------------------------+--------------------------------------------------
---------------------------------+
| basedir                    | C:\Program Files\MySQL\MySQL Server 5.1\
                                 |
| character_sets_dir         | C:\Program Files\MySQL\MySQL Server 5.1\share\cha
rsets\                           |
| datadir               &nbs