$> mysql -u root -p
mysql> SOURCE C:/temp/sakila-db/sakila-schema.sql;
mysql> SOURCE C:/temp/sakila-db/sakila-data.sql;
mysql> USE sakila;Database changedmysql> SHOW FULL TABLES;+----------------------------+------------+| Tables_in_sakila | Table_type |+----------------------------+------------+| actor | BASE TABLE || actor_info | VIEW || address | BASE TABLE || category | BASE TABLE || city | BASE TABLE || country | BASE TABLE || customer | BASE TABLE || customer_list | VIEW || film | BASE TABLE || film_actor | BASE TABLE || film_category | BASE TABLE || film_list | VIEW || film_text | BASE TABLE || inventory | BASE TABLE || language | BASE TABLE || nicer_but_slower_film_list | VIEW || payment | BASE TABLE || rental | BASE TABLE || sales_by_film_category | VIEW || sales_by_store | VIEW || staff | BASE TABLE || staff_list | VIEW || store | BASE TABLE |+----------------------------+------------+23 rows in set (0.01 sec)mysql> SELECT COUNT(*) FROM film;+----------+| COUNT(*) |+----------+| 1000 |+----------+1 row in set (0.00 sec)mysql> SELECT COUNT(*) FROM film_text;+----------+| COUNT(*) |+----------+| 1000 |+----------+1 row in set (0.00 sec)
联系客服