· 8 years ago · Apr 17, 2018, 09:06 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2CREATE TABLE IF NOT EXISTS `tmp` (
3 `id` int(11) NOT NULL,
4 `text` varchar(255) NOT NULL,
5 `pwd` char(50) NOT NULL,
6 `balance` int(11) NOT NULL DEFAULT '0'
7) ENGINE=MyISAM DEFAULT CHARSET=latin1;
8INSERT INTO `tmp` (`id`, `text`, `pwd`, `balance`) VALUES
9(1, 'lol', '827ccb0eea8a706c4c34a16891f84e7b', 0),
10(2, 'rolf', '63a9f0ea7bb98050796b649e85481845', 500);