mysql uroot CREATE DATABASE web quit mysql uroot web web sql USE web S

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
mysql –uroot
CREATE DATABASE web;
quit
mysql –uroot web < с:\web.sql
USE web;
SHOW TABLES;
SELECT COUNT(*) FROM courses;
SELECT COUNT(*) FROM lessons;
SELECT COUNT(*) FROM teachers;
DESCRIBE courses;
DESCRIBE lessons;
DESCRIBE teachers;
SELECT * FROM teachers;
quit