Advertisement
azharulsuvo

mysql table creation

Jan 12th, 2021
697
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1.  
  2. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  3. SET time_zone = "+00:00";
  4.  
  5.  
  6.  
  7. CREATE TABLE IF NOT EXISTS `users_id` (
  8. `Id` int(18) NOT NULL,
  9.   `first_name` varchar(55) NOT NULL,
  10.   `first_name_o` varchar(55) NOT NULL,
  11.   `first_name_1` varchar(55) NOT NULL,
  12.   `last_name` varchar(55) NOT NULL,
  13.   `last_name_m` varchar(55) NOT NULL,
  14.   `city_name` varchar(55) NOT NULL,
  15.   `email` varchar(50) NOT NULL
  16. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  17.  
  18.  
  19. ALTER TABLE `users_id`
  20.  ADD PRIMARY KEY (`Id`);
  21.  
  22.  
  23. ALTER TABLE `users_id`
  24. MODIFY `Id` int(18) NOT NULL AUTO_INCREMENT;
  25.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement