You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
11 lines
289 B
11 lines
289 B
CREATE TABLE logins (
|
|
login_id MEDIUMINT NOT NULL AUTO_INCREMENT,
|
|
login CHAR(30) NOT NULL,
|
|
passwd CHAR(30),
|
|
PRIMARY KEY (login_id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
INSERT INTO logins(login, passwd) VALUES
|
|
('brian', 'foobar'), ('caroline', 'boing');
|
|
|
|
SELECT * FROM logins;
|