12345678910 |
- CREATE TABLE IF NOT EXISTS users (
- user_id int(10) unsigned NOT NULL AUTO_INCREMENT,
- name varchar(100) NOT NULL,
- email varchar(100) NOT NULL,
- PRIMARY KEY (user_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- insert into users(name,email) values ('user1', 'user1@example.com');
- insert into users(name,email) values ('user2', 'user2@example.com');
- insert into users(name,email) values ('user3', 'user3@example.com');
|