· 8 years ago · Mar 17, 2018, 07:18 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3
4CREATE DATABASE IF NOT EXISTS dbsample;
5USE dbsample;
6
7CREATE TABLE IF NOT EXISTS `tblsample` (
8 `user_id` int(11) NOT NULL AUTO_INCREMENT,
9 `fname` varchar(50) NOT NULL,
10 `lname` varchar(50) NOT NULL,
11 PRIMARY KEY (`user_id`)
12) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;