MySQL
keyboard_arrow_down 295 guides
chevron_leftRow Cookbooks
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Inserting rows into a table in MySQL
schedule Aug 11, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
Given an empty table called info generated with the below code:
CREATE TABLE info (name VARCHAR(20), age INT, hobby VARCHAR(20));
Inserting rows
To add a row for 'alex':
INSERT INTO info (name, age, hobby) VALUES ('alex', 30, 'Programming');
Query OK, 1 row affected (0.01 sec)
To add two more rows for 'bob' and 'cathy':
INSERT INTO info (name, age, hobby) VALUES ('bob', 15, 'Programming');
Query OK, 1 row affected (0.00 sec)
INSERT INTO info (name, age, hobby) VALUES ('cathy', 20, 'Swimming');
Query OK, 1 row affected (0.01 sec)
Checking the inserted rows
To check that three rows have been added to table info:
SELECT * FROM info;
+-------+------+-------------+| name | age | hobby |+-------+------+-------------+| alex | 30 | Programming || bob | 15 | Programming || cathy | 20 | Swimming |+-------+------+-------------+
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
