· 8 years ago · Sep 01, 2018, 09:50 AM
1MySQL update problem
2CREATE TABLE IF NOT EXISTS `student` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` text NOT NULL,
5 `delete` varchar(3) NOT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
8
9INSERT INTO `student` (`name`, `delete`) VALUES('newa', 'no')
10
11#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 'set delete-'yes'' at line 1
12
13SET `delete` = .....
14
15UPDATE student SET `delete`='yes'