/SQL/Delete record by id sql

Delete record by id sql

Delete record by id sql

CREATE TABLE my_table (
	my_id INT NOT NULL,  
  	name VARCHAR(100)
);

DELETE FROM my_table WHERE my_id = 100;
COMMIT;				-- if autocommit is off

0

Similar codes

5 votes142 views4 answers
Upload database mysql command line
SQL
0 vote129 views1 answer
Wp_query raw sql
SQL
6 votes137 views2 answers
Postgresql restore from dump
SQL
0 vote140 views1 answer
Nosql vs sql
SQL
0 vote134 views2 answers
How to know the character set of an oracle databes
SQL
29 votes126 views5 answers
Mysql show table structure
SQL
7 votes160 views3 answers
Restore postgres database from sql file
SQL
0 vote181 views1 answer
Osm2pgsql mac
SQL
0 vote151 views1 answer
Sql insert from excel
SQL
25 votes123 views1 answer
Mysql grant all privileges to a user
SQL

Share