• +1-617-874-1011 (US)
  • +44-117-230-1145 (UK)
Live Chat
Follow Us:

Insert Data into a MySQL

The INSERT Statement

The INSERT explanation enables you to add information to your database tables. The linguistic structure goes this way:

 Supplement INTO
 table_name (col_1, col_2, col_3….)
 Qualities (value_1, value_2, value_3….);

This supplements information into one line. The request of the qualities furnished must relate with the segments that the qualities are to be embedded into.

In the event that you are embeddings information into all sections, you can overlook the segment names and simply do this:

Supplement INTO table_name VALUES (value_1, value_2, value_3);

To populate different columns, utilize a comma to isolate each line, this way:

Addition INTO table_name

Qualities

INSERT INTO `table_name`(column_1,column_2,...) VALUES (value_1,value_2,...);
 (value_1, value_2, value_3….),
 (value_1, value_2, value_3….),
 (value_1, value_2, value_3….),
 (value_1, value_2, value_3….);

The above model populates 4 pushes and accept there are 3 sections in each column.

Example

Suppose that we have the following list of new library members that need to be added into the database.

Execute the accompanying SQL content against the FruitShop database:

(1,'Piece','2015-02-15 10:30:00','2015-02-15 10:30:00'),
(2,'Kilogram','2015-02-15 10:30:00','2015-02-15 10:30:00'),
(3,'Gram','2015-02-15 10:30:00','2015-02-15 10:30:00'),
(4,'Pound','2015-02-15 10:30:00','2015-02-15 10:30:00'),
(5,'Ounce','2015-02-15 10:30:00','2015-02-15 10:30:00'),
(6,'Bunch','2015-02-15 10:30:00','2015-02-15 10:30:00'),
(7,'Container','2015-02-15 10:30:00','2015-02-15 10:30:00');

Addition INTO Fruit

Qualities

(1,'Apple',10,1,'2015-02-15 10:30:00','2015-02-15 10:30:00'),
(2,'Orange',5,2,'2015-02-15 10:30:00','2015-02-15 10:30:00'),
(3,'Banana',20,6,'2015-02-15 10:30:00','2015-02-15 10:30:00'),
(4,'Watermelon',10,1,'2015-02-15 10:30:00','2015-02-15 10:30:00'),
(5,'Grapes',15,6,'2015-02-15 10:30:00','2015-02-15 10:30:00'),
(6,'Strawberry',12,7,'2015-02-15 10:30:00','2015-02-15 10:30:00');

Check your Data

You can watch that your information was embedded by executing the accompanying SQL explanations.

Check the Fruit Table

Select all records from the Fruit table by running the accompanying explanation:

 select * from Fruit

The Result

MySQL Insert Data 1

The outcome should resemble this.

MySQL Insert Data

Check the Units Table

Select all records from the Units table by running the accompanying explanation:

 select * from Units

The Result

MySQL Insert Data

MySQL Insert Data 2

The outcome should resemble this.

We simply utilized a SELECT explanation to question the information in our database. How about we look all the more carefully at MySQL inquiries.

Keywords: MYSQL Tutorials, Data Relations homework help, SQL homework help, SQL project Help, Oracle Homework Help, XML homework help, XML and Relational Algebra assignment help, SQL Queries and Updates homework assignment help, XML Queries and Transformations tutoring help, Relational Database Design concept, Higher-Level Design help in UML and ERD, Data Warehousing and Data Mining, help with SQL 2008 database, support for Database help, Microsoft access and mysql database programmer, database development and xml database support, homework helper for asp database and uml modeling, uml sequence diagram and uml class diagram, database design development and software SQL server 2008.