CREATE TABLE `yfd_interviewer` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(256) NOT NULL DEFAULT '', `age` INT(11) NOT NULL, `createdTime` BIGINT(20) NOT NULL, `updatedTime` BIGINT(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
select * from `yfd_interviewer`;
Select * From Yfd_Interviewer;
SELECT * FROM yfd_interviewer ORDER BY id WHERE name = 'lilei';
UPDATE yfd_interviewer SET age = 20 WHERE id = 1;