Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgres 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 :: upload database mysql command line 
Sql :: node and mysql like 
Sql :: how much every mysql database record takes from diskspace 
Sql :: oracle list invalid password logon denied 
Sql :: day of the week sqlite 
Sql :: oracle list tables 
Sql :: mysql delete binlog 
Sql :: check mysql timezone 
Sql :: console output pl sql 
Sql :: rails run native ssql query 
Sql :: how to copy data of a table from another database to table of anaother database 
Sql :: sql current timestamp 
Sql :: how to start mysql in terminal 
Sql :: sql change password wordpress 
Sql :: age postgres 
Sql :: oracle nls parameters 
Sql :: oracle sql truncate table 
Sql :: describe sql server 
Sql :: mssql get running queries 
Sql :: mssql cursor 
Sql :: ALL_TAB_PARTITIONS 
Sql :: mysql error codeigniter 
Sql :: mysql search like order by best match 
Sql :: mysql reset auto increment to 1 
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD 
Sql :: mariadb number format 
Sql :: postgresql array last element 
Sql :: oracle list privileges 
Sql :: sql delete multiple conditions 
Sql :: how to change column type psql 
ADD CONTENT
Topic
Content
Source link
Name
1+4 =