Horje
Reorder Table Primary Key Index After Deleting Some Rows Code Example
Reorder Table Primary Key Index After Deleting Some Rows 
UPDATE tbl SET catid = (SELECT COUNT(*) FROM tbl t WHERE t.catid <= tbl.catid);
Source: stackoverflow.com



Sql

Related
group by join columns per table Code Example group by join columns per table Code Example
oracle sql timestamp Code Example oracle sql timestamp Code Example
write sql query to show the details start from digit Code Example write sql query to show the details start from digit Code Example
sql substring before last occurrence of character Code Example sql substring before last occurrence of character Code Example
get first match in each group mysql query Code Example get first match in each group mysql query Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje