Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `phones` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `phone` VARCHAR(20) NOT NULL,
- `name` VARCHAR(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `phone` (`phone`),
- KEY `id` (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
- INSERT INTO `phones` (`id`, `phone`, `name`) VALUES
- (1, '7495123456', 'Тест'),
- (2, '74951234567', 'Тест 2'),
- (3, '74991234567', 'Петя Иванов'),
- (4, '74998885566', 'Провекин Иван 1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement