/SQL/How to delete row in sql

How to delete row in sql

Sql delete where in

-- Deletes all records where `columnName` matches the values in brackets.
DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');

4

How to delete row in sql

DELETE FROM my_table;		-- all rows
DELETE FROM my_table WHERE my_id = 12345;
DELETE FROM my_table WHERE my_id IN (SELECT id2 FROM my_table2);

0

Similar codes

0 vote161 views1 answer
Casterar postgres
SQL
0 vote173 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
-1 vote127 views1 answer
Mysql if example
SQL
2 votes168 views2 answers
Create temporary table in mysql
SQL
4 votes265 views1 answer
What are the data types
SQL
0 vote144 views1 answer
Postgres data location
SQL
4 votes163 views2 answers
Bulk kill mysql processlist
SQL
2 votes155 views1 answer
Q operator in oracle
SQL
0 vote176 views1 answer
Arithmetic expression in sql
SQL
0 vote144 views1 answer
Object Information
SQL

Share