PhLVu484

1CREATE DATABASE IF NOT EXISTs test;
2
3USE test;
4
5CREATE TABLE IF NOT EXISTS users(
6id INT UNSIGNED NOT NULL AUTO_INCREMENT,
7user varchar (30),
8password varchar (40),
9PRIMARY KEY (id)
10);
11
12INSERT INTO users (user, password) VALUES ("Peto", "heslo"), ("David", "heslo");
13
14SELECT * FROM users LIMIT 0, 100;