Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP DATABASE IF EXISTS miodb;
- CREATE DATABASE miodb;
- USE miodb;
- CREATE TABLE test
- (
- ID INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- USERNAME VARCHAR(15) NOT NULL,
- PASSWORD VARCHAR(20) NOT NULL,
- DATA_NASCITA DATE NOT NULL
- );
- INSERT INTO test (USERNAME,PASSWORD,DATA_NASCITA) VALUES
- ('EMANUELE','PASSWORDTEST','1998-06-28'),
- ('FOREST','MIAPASSWORD','2015-03-27');
- SELECT * FROM test;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement