◇ 建立表user
mysql> use mydb; database changed mysql> drop table if exists `user`; query ok, 0 rows affected (0.00 sec) mysql> create table `user` ( -> `id` int(5) not null auto_increment, -> `name` varchar(20) not null default '', -> `password` varchar(20) not null default '', -> primary key (`id`) -> ) engine=myisam default charset=latin1; query ok, 0 rows affected (0.06 sec) |
◇ 显示user 表的结构
mysql> desc user; +----------+-------------+------+-----+---------+----------------+ | field | type | null | key | default | extra | +----------+-------------+------+-----+---------+----------------+ | id | int(5) | | pri | null | auto_increment | | name | varchar(20) | | | | | | password | varchar(20) | | | | | +----------+-------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) |
◇ 数据库的导出：用自带的mysqldump 小程序
c:\>mysqldump mydb -h localhost -u root -p>mydb.sql enter password: ****** |
