!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT ;
!40101
SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS ;
!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION ;
!40101 SET NAMES utf8 ;
–
–
数据库 `test`
–
– ——————————————————–
–
–
表的结构 `user`
–
CREATE TABLE IF NOT EXISTS `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user` varchar(6) NOT NULL,
`pwd` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
–
–
转存表中的数据 `user`
–
INSERT INTO `user` (`id`, `user`, `pwd`) VALUES
(11, ‘测试 2 , ‘
′ 测试 2 ),
′
(12, ‘测试 1 , ‘
′ 测试 1 ),
′
(13, ‘测试 3 , ‘
′ 测试 3 ),
′
(15, ‘测试 4 , ‘
′ 测试 4 ),
′
(16, ‘测试 5 , ‘
′ 测试 5 ),
′
(17, ’222 , ’111 ),
′
′
(18, ’222a’, ’111a’);
——————————————————–