Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql delete last row

DELETE FROM my_table WHERE my_col_id = (SELECT MAX(my_col_id) FROM my_table);
Comment

PREVIOUS NEXT
Code Example
Sql :: t-sql disable system versioning 
Sql :: mysql dump mysql db cli 
Sql :: what is meant by trigger in dbms 
Sql :: having count greater than 1 mysql 
Sql :: sql getdate minus 1 day without time 
Sql :: oracle user tables 
Sql :: t-sql find object by name 
Sql :: postgresql pg_dump 
Sql :: sql throw error 
Sql :: delete triger pl pg sql 
Sql :: oracle current timestamp 
Sql :: postgres get timestamp 
Sql :: create user mysql 
Sql :: mysql date format unix timestamp 
Sql :: mysql between start date and end date 
Sql :: how to check nls timestamp format in oracle 
Sql :: delete all rows from table sql 
Sql :: mysql select from outside 
Sql :: sql count columns 
Sql :: drop table if exists oracle 
Sql :: how to see all table partition in oracle 
Sql :: conda install pymysql "windows" 
Sql :: plsql code for deleting a row from nested table in oracle 
Sql :: asp.net core with postgresql deploy on ubuntu 
Sql :: sql server 2008 first and last day of month 
Sql :: mysql number format 
Sql :: how to check current user in mysql 
Sql :: how to add foreign key constraint in sql 
Sql :: postgresql change value in column 
Sql :: use of now() in mysql 
ADD CONTENT
Topic
Content
Source link
Name
4+9 =