The INSERT SQL statement impregnates our table with data. Here is a general form of INSERT.
INSERT into table_name (column1, column2....) values (value1, value2...);
where table_name is the name of the table into which we want to insert data; column1, column2 etc. are column names and value1, value2 etc. are values for the respective columns. This is quite simple, isn’t it?
The following statement inserts the first record in employee_data table.
INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("Manish", "Sharma", "CEO", 28, 4, 200000, 50000, "email@example.com");
As with other MySQL statements, you can enter this command on one line or span it in multiple lines.
Some important points:
Once you type the above command correctly in the mysql client, it displays a success message.
mysql> INSERT INTO employee_data -> (f_name, l_name, title, age, yos, salary, perks, email) -> values -> ("Manish", "Sharma", "CEO", 28, 4, 200000, -> 50000, "firstname.lastname@example.org"); Query OK, 1 row affected (0.00 sec)
Inserting additional records requires separate INSERT statements. In order to make life easy, I’ve packed all INSERT statements into a file. Click to download the file, employee.dat.
Once you download the file, open it in a text editor. You’ll notice that it’s a plain ASCII file with an INSERT statement on each line.
mysql employees <employee.dat
mysql employees <employee.dat -u username -p
Our table contains 21 entries (20 from employee.dat file and one from the INSERT statement we issued at the beginning). You can view the table here. (This opens another browser window).
"Domain Hack" means a clever way to use a domain name and has nothing to do with security. [more...]