To add data to a table, use the INSERT command. Let\u2019s see this in action by populating the table classics with the data.<\/p>\n\n\n\n
Example \ud83d\ude42 Populating the classics table
INSERT INTO classics(author, title, type, year)
VALUES(‘Markku Aro’,’30 suosikkia’,’POP’,’1998′);
INSERT INTO classics(author, title, type, year)
VALUES(‘Lenni Kalle’,’parhaat’,’klassikko’,’1811′);
INSERT INTO classics(author, title, type, year)
VALUES(‘Esa M\u00e4kel\u00e4”,’Ketsuppia saksasta’,’POP’,’1990′);
INSERT INTO classics(author, title, type, year)
VALUES(‘Matti ja Teppo”,’kautta aikain parhaat’,’iskelm\u00e4’,’1975′);
INSERT INTO classics(author, title, type, year)
VALUES(‘Suvi Ter\u00e4sniska’,’30 parhainta ‘,’POP’,’2020′);<\/p>\n\n\n\n
After every second line, you should see a Query OK message. Once all lines have been entered, type the following command, which will display the table\u2019s contents.<\/p>\n\n\n\n
Use next command to read content:
SELECT * FROM classics;<\/p>\n","protected":false},"excerpt":{"rendered":"
To add data to a table, use the INSERT command. Let\u2019s see this in action by populating the table classics with the data. Example \ud83d\ude42 Populating the classics tableINSERT INTO classics(author, title, type, year)VALUES(‘Markku Aro’,’30 suosikkia’,’POP’,’1998′);INSERT INTO classics(author, title, type, year)VALUES(‘Lenni Kalle’,’parhaat’,’klassikko’,’1811′);INSERT INTO classics(author, title, type, year)VALUES(‘Esa M\u00e4kel\u00e4”,’Ketsuppia saksasta’,’POP’,’1990′);INSERT INTO classics(author, title, type, year)VALUES(‘Matti ja … Continue reading Adding data to a table<\/span>