mysql中的resultt框没有了_mysql的问题，大家看一下嘛，谢谢

[hantsy@localhost Desktop]$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.33 MySQL Community Server (GPL) by Remi

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| GUESTBOOK |

| MyBusinessRecords |

| bakesale |

| cakeblog |

| cheesecake2 |

| drupal_db |

| exam |

| gallery2 |

| gift |

| hibernatedemo |

| mysql |

| petcatalog |

| sakila |

| sample |

| test |

| travel |

| vir |

+--------------------+

18 rows in set (0.20 sec)

mysql> use test;

Database changed

mysql> show tables;

Empty set (0.00 sec)

mysql> create table t_test(id int not null auto_increment primary key,name varchar(255));

Query OK, 0 rows affected (0.05 sec)

mysql> show tables;

+----------------+

| Tables_in_test |

+----------------+

| t_test |

+----------------+

1 row in set (0.00 sec)

mysql> desc t_test;

+-------+--------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------+--------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(255) | YES | | NULL | |

+-------+--------------+------+-----+---------+----------------+

2 rows in set (0.05 sec)

mysql> insert into t_test(name) values('test');

Query OK, 1 row affected (0.03 sec)

mysql> insert into t_test(name) values('test2');

Query OK, 1 row affected (0.00 sec)

mysql> insert into t_test(name) values('test3');

Query OK, 1 row affected (0.00 sec)

mysql> select * from t_test;

+----+-------+

| id | name |

+----+-------+

| 1 | test |

| 2 | test2 |

| 3 | test3 |

+----+-------+

3 rows in set (0.00 sec)

mysql> delete from t_test where id=3;

Query OK, 1 row affected (0.00 sec)

mysql> delete from t_test where id=2;

Query OK, 1 row affected (0.00 sec)

mysql> insert into t_test(name) values('test3');

Query OK, 1 row affected (0.00 sec)

mysql> select * from t_test;

+----+-------+

| id | name |

+----+-------+

| 1 | test |

| 4 | test3 |

+----+-------+

2 rows in set (0.00 sec)

mysql> truncate t_test;

Query OK, 0 rows affected (0.00 sec)

mysql> select * from t_test;

Empty set (0.00 sec)

mysql> insert into t_test(name) values('test');

Query OK, 1 row affected (0.00 sec)

mysql> insert into t_test(name) values('test2');

Query OK, 1 row affected (0.00 sec)

mysql> select * from t_test;

+----+-------+

| id | name |

+----+-------+

| 1 | test |

| 2 | test2 |

+----+-------+

2 rows in set (0.00 sec)

mysql>

2009年4月22日 14:10

712

0

0

0