Creating a table in database

Go to the MySQL Workbench and select the database.

We have included some user details for the USERS table. You can copy and paste the following code to create a USERS table and insert some demo data:

create table users (id int not null auto_increment, name varchar(255), email varchar(255), contact_number varchar(255)
, primary key (id)) engine=MyISAM;
INSERT INTO user (id, name, email, contact_number) values (1, 'Sunnat', '[email protected]', '1234567890');
INSERT INTO user (id, name, email, contact_number) values (2, 'Chaity', '[email protected]', '9876543210');
INSERT INTO user (id, name, email, contact_number) values (3, 'Mirza', '[email protected]', '1234567800');
INSERT INTO user (id, name, email, contact_number) values (4, 'Hasib', '[email protected]', '1234500800');
INSERT INTO user (id, name, email, contact_number) values (4, 'Jisan', '[email protected]', '1004500800');

After inserting the user details in the user table, you can see the content in your users table, as in the following screenshot:  

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.12.136.63