<b>(a)</b> mysql -u <user with create table privileges> <database> < <sql file> e.g. mysql -u root test < example.sql <b>(b)</b> create table address( name varchar(50) not null, address varchar(100), city varchar(50), state varchar(50), postcode int, phone varchar(20), fax varchar(20), email varchar(20), primary key(name) );
Example 1: (a) Creating a table; (b) contents of example.sql.