How to INSERT data into table in MySQL?
MySQL INSERT
MySQL INSERT statement is used to insert data in MySQL table within the database. We can insert single or multiple records using a single query in MySQL. Syntax: The SQL INSERT INTO command is used to insert data in MySQL table. Following is a generic syntax: INSERTINTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN ); Field name is optional. If you want to specify partial values, field name is mandatory.Syntax for all fields: INSERTINTO table_name VALUES ( value1, value2,...valueN ); Example 1: for all fields
If you have to store all the field values, either specify all field name or don't specify any field. Example: INSERTINTO emp
Subscribe channel on YouTube:-
/ ipctrd
Read this post on Blogger:- http://ipctrd.blogspot.in/
Like page on Facebook:- / ipctrd
Tweet about video on twitter:- / ipctrd
Let's chat on whatsapp:- https://chat.whatsapp.com/BrHbRDvbfs6...
See you at Instagram :- / ipctrd
Google+ :- https://plus.google.com/u/0/101013097...