随笔档案(496)

Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> show databases
-> ;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)
mysql> create database soft;
Query OK, 1 row affected (0.00 sec)
mysql> show databases
-> ;
+----------+
| Database |
+----------+
| mysql |
| soft |
| test |
+----------+
3 rows in set (0.00 sec)
mysql> source info_web.sql
ERROR 1046 (3D000): No database selected
mysql> use soft;
Database changed
mysql> source info_web.sql
Query OK, 0 rows affected (0.11 sec)
mysql> source 2.sql;
Query OK, 0 rows affected (0.08 sec)
mysql> source 1.sql;
Query OK, 0 rows affected (0.09 sec)
mysql> show tables
-> ;
+----------------+
| Tables_in_soft |
+----------------+
| info_web |
| mainclass |
| subclass |
+----------------+
3 rows in set (0.00 sec)
mysql> show table info_web;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'info_
web' at line 1
mysql>
mysql> describe info_web;
+------------+-------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------------------+-------+
| id | varchar(32) | | PRI | | |
| number | int(11) | YES | | NULL | |
| iswarn | int(11) | YES | | NULL | |
| title | text | YES | | NULL | |
| power | int(11) | YES | | NULL | |
| limit | int(11) | YES | | NULL | |
| content | text | YES | | NULL | |
| date | datetime | YES | | 0000-00-00 00:00:00 | |
| persion_id | varchar(32) | YES | | NULL | |
| visit_num | int(11) | YES | | NULL | |
| pic_in | int(11) | YES | | NULL | |
+------------+-------------+------+-----+---------------------+-------+
11 rows in set (0.03 sec)
mysql> describe mainclass
-> ;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| main_num | int(11) | | PRI | NULL | auto_increment |
| main_name | varchar(32) | YES | | NULL | |
| main_order | int(11) | YES | MUL | 0 | |
| href | varchar(128) | YES | | NULL | |
+------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> describe subclass;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| sub_num | int(11) | | PRI | NULL | auto_increment |
| main_num | int(11) | YES | MUL | NULL | |
| sub_name | varchar(64) | YES | | NULL | |
| href | varchar(128) | YES | | NULL | |
| isuse | int(11) | YES | | NULL | |
+----------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql>