{"id":1592,"date":"2024-09-04T06:58:08","date_gmt":"2024-09-04T06:58:08","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=1592"},"modified":"2025-06-09T06:59:21","modified_gmt":"2025-06-09T06:59:21","slug":"values","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/values\/","title":{"rendered":"VALUES"},"content":{"rendered":"\n

SQL VALUES Keyword<\/h2>\n\n\n\n

The VALUES keyword is used with the INSERT INTO command to specify the values to be inserted<\/strong> into a new row of a table. You can insert values for all columns<\/strong> or for specific columns<\/strong>. Make sure that required (NOT NULL) and PRIMARY KEY columns are properly filled.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL VALUES Syntax<\/h2>\n\n\n\n
INSERT INTO table_name (column1, column2, ...)\nVALUES (value1, value2, ...);<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL VALUES Insert All Columns into Doctors Table Example<\/h2>\n\n\n\n
This query inserts a new row into the Doctors<\/code> table. Since existing doctor_id<\/code> values are 1\u201310, we will use doctor_id = 11<\/code>.<\/p>\n\n\n\n
INSERT INTO Doctors (doctor_id, first_name, last_name, specialty)\nVALUES (11, 'Anna', 'Santos', 'Cardiology');<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL VALUES Insert Required Columns into Patients Table Example <\/h2>\n\n\n\n
This query inserts a new patient record into the Patients table with the specified patient_id, first name, last name, date of birth, and gender.<\/p>\n\n\n\n
INSERT INTO Patients (patient_id, first_name, last_name, dob, gender)\nVALUES (11, 'Carlos', 'Reyes', '2000-01-01', 'M');<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL VALUES Labs<\/h2>\n\n\n\n