(a)
mysql -u <user with create table privileges> <database> < <sql file>
e.g. mysql -u root test < example.sql

(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.

Back to Article