Reader small image

You're reading from  Learn SQL using MySQL in One Day and Learn It Well

Product typeBook
Published inApr 2024
PublisherPackt
ISBN-139781836205678
Edition1st Edition
Right arrow
Author (1)
Jamie Chan
Jamie Chan
author image
Jamie Chan

Jamie Chan is a tutor and freelance programmer with years of experience and a dedicated passion for sharing the joy of programming with as many people as possible. With seven bestselling programming books on Amazon, Jamie's publications stand out for their ability to break down complex concepts into simple terms. Additionally, each book includes complete projects at the end, enabling hands-on learning and a deep understanding of the concepts presented.
Read more about Jamie Chan

Right arrow

Inserting Data

 

To insert data into MySQL, we use the following syntax:

 

INSERT INTO table_name (column1, column2, column3, …)

VALUES (value1, value2, value3, …);

 

Image

 

Suppose we want to insert the information above into the employees table, we write

 

INSERT INTO employees (em_name, gender, contact_number, salary, years_in_company) VALUES

('James Lee', 'M', '516-514-6568', 3500, 11),

('Peter Pasternak', 'M', '845-644-7919', 6010, 10),

('Clara Couto', 'F', '845-641-5236', 3900, 8),

('Walker Welch', 'M', NULL, 2500, 4),

('Li Xiao Ting', 'F', '646-218-7733', 5600, 4),

('Joyce Jones', 'F', '523-172-2191', 8000, 3),

('Jason Cerrone', 'M', '725-441-7172', 7980, 2),

('Prudence Phelps', 'F', '546-312-5112&apos...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Learn SQL using MySQL in One Day and Learn It Well
Published in: Apr 2024Publisher: PacktISBN-13: 9781836205678

Author (1)

author image
Jamie Chan

Jamie Chan is a tutor and freelance programmer with years of experience and a dedicated passion for sharing the joy of programming with as many people as possible. With seven bestselling programming books on Amazon, Jamie's publications stand out for their ability to break down complex concepts into simple terms. Additionally, each book includes complete projects at the end, enabling hands-on learning and a deep understanding of the concepts presented.
Read more about Jamie Chan