Skip to content

Instantly share code, notes, and snippets.

View prashantkumarabhishek's full-sized avatar
🏠
Working from home

Prashant kr Abhishek prashantkumarabhishek

🏠
Working from home
View GitHub Profile
@prashantkumarabhishek
prashantkumarabhishek / users.sql
Created March 14, 2019 14:52
Insert Data in Users Table
INSERT INTO `Users` (`uid`, `Name`, `City`, `State`, `Country`) VALUES
(1, 'Prashant', 'Jaipur', 'Rajasthan', 'India'),
(2, 'Abhishek', 'Delhi', 'Delhi', 'India'),
(3, 'Ashwani Bhatt', 'Jaipur', 'Rajasthan', 'India'),
(4, 'Harsh Gupta', 'Howrah', 'West Bengal', 'India'),
(5, 'Vivek', 'Jaipur', 'Rajasthan', 'India'),
(6, 'Nidz', 'Gurgaon', 'Haryana', 'India');
 CREATE TABLE `users` (
  `uid` int(11) NOT NULL,
  `Name` text NOT NULL,
  `City` text NOT NULL,
  `State` text NOT NULL,
  `Country` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  ALTER TABLE `Users`
  ADD PRIMARY KEY (`uid`);