/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

1 vote302 views2 answers
Mysql order by date asc null last
SQL
0 vote383 views1 answer
Reindexing all tables sql server
SQL
0 vote313 views1 answer
First Step in installing SQL workbench
SQL
2 votes354 views1 answer
Create mysql user on all hosts
SQL
0 vote333 views1 answer
Postrgres trunc
SQL
0 vote291 views1 answer
Mysql workbench search all tables
SQL
0 vote307 views4 answers
Mysql select bottom 10 rows
SQL
1 vote325 views1 answer
How to delete data from sql database in android
SQL
14 votes312 views1 answer
Excel is not a database
SQL
0 vote301 views1 answer
What is logical database schema
SQL

Share