一、备份与恢复作业
1、C:\Windows\System32>mysqldump -uroot -p123456 booksDB > book.sql
2、C:\Windows\System32>mysqldump -uroot -p123456 booksDB books> book1.sql
3、C:\Windows\System32>mysqldump -uroot -p123456 --databases booksDB test> bbt.sql
4、C:\Windows\System32>mysql -uroot -p123456 book<book.sql
5、mysql> source book1.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 8 rows affected (0.00 sec)
Records: 8 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
二、索引作业
1、mysql>alter table goods drop goods_desc;
mysql> alter table goods drop goods_id;
mysql> alter table goods add click_count int;
2、mysql> alter table goods add unique index index_name(goods_name);
3、mysql> create index index_price on goods(shop_price);
4、mysql> create index index_count on goods( click_count);
mysql> drop index index_count on goods;
mysql> alter table goods drop index index_count;