Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. mysql> ALTER TABLE `players` ADD COLUMN `num` VARCHAR(10) NOT NULL DEFAULT '0'
  2. -> ALTER TABLE `players` ADD COLUMN `contact` TEXT NULL DEFAULT NULL
  3. -> ALTER TABLE `players` ADD COLUMN `sms` INT(10) NOT NULL DEFAULT '0'
  4. -> ALTER TABLE `players` ADD COLUMN `appel` INT(10) NOT NULL DEFAULT '0'
  5. -> CREATE TABLE IF NOT EXISTS `cellphone` ( `pid` varchar(64) NOT NULL, `name` varchar(32) NOT NULL, `messages` text NOT NULL, `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  6. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `players` ADD COLUMN `contact` TEXT NULL DEFAULT NULL
  7.  
  8. ALTER TABL' at line 3
  9. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement