Advertisement
Guest User

Create table

a guest
Aug 3rd, 2015
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.49 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `phones` (
  2.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  3.   `phone` VARCHAR(20) NOT NULL,
  4.   `name` VARCHAR(255) NOT NULL,
  5.   PRIMARY KEY (`id`),
  6.   UNIQUE KEY `phone` (`phone`),
  7.   KEY `id` (`id`)
  8. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
  9.  
  10. INSERT INTO `phones` (`id`, `phone`, `name`) VALUES
  11. (1, '7495123456', 'Тест'),
  12. (2, '74951234567', 'Тест 2'),
  13. (3, '74991234567', 'Петя Иванов'),
  14. (4, '74998885566', 'Провекин Иван 1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement