MySQL Reference Sheet: Records
Records
Create a new record
Syntax:
INSERT INTO table_name (column1, column2, column3, …)
VALUES (value1, value2, value3, …);
Example:
mysql> INSERT INTO courses_table (menu_title, course_description, course_content, position, visible) VLAUES (‘New Course’, ‘New course Description’, ‘New course content’, 1, 1);
Update an existing record
Syntax:
UPDATE table_name
SET column1 = value1, column2 = value2, …
WHERE condition;
Example:
mysql> UPDATE courses_table SET menu_title = ‘Updated Title’ WHERE id = 1;
Delete an existing record
Syntax:
DELETE FROM table_name
WHERE condition;
Example:
mysql> DELETE FROM courses_table WHERE id = 1;