Advertisement
forest98

Prova MySQL

Jun 14th, 2015
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.39 KB | None | 0 0
  1. DROP DATABASE IF EXISTS miodb;
  2. CREATE DATABASE miodb;
  3.  
  4. USE miodb;
  5.  
  6. CREATE TABLE test
  7. (
  8.     ID INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  9.     USERNAME VARCHAR(15) NOT NULL,
  10.     PASSWORD VARCHAR(20) NOT NULL,
  11.     DATA_NASCITA DATE NOT NULL
  12. );
  13.  
  14. INSERT INTO test (USERNAME,PASSWORD,DATA_NASCITA) VALUES
  15. ('EMANUELE','PASSWORDTEST','1998-06-28'),
  16. ('FOREST','MIAPASSWORD','2015-03-27');
  17.  
  18. SELECT * FROM test;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement