Advertisement
Shedal

SQL Problem Data

Sep 12th, 2011
416
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.72 KB | None | 0 0
  1. CREATE TABLE `players` (
  2.   `Id` INT(11) NOT NULL AUTO_INCREMENT,
  3.   `Name` VARCHAR(255) NOT NULL,
  4.   `Score` INT(11) NOT NULL,
  5.   PRIMARY KEY (`Id`)
  6. );
  7.  
  8. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('1','Ivan','8');
  9. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('2','Stepan','10');
  10. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('3','Irina','3');
  11. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('4','Vasily','7');
  12. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('5','Vladimir','9');
  13. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('6','Svetlana','10');
  14. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('7','Valentin','9');
  15. INSERT INTO `Players` (`Id`, `Name`, `Score`) VALUES('8','Bla','0');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement