Important Code Samples
Friday, December 2, 2016
Truncate issue with "foreign key constraint"
if you cannot truncate your MySQL table because of a foreign key constraint, but you should
SET FOREIGN_KEY_CHECKS = 0;
Truncate table XXX;
Truncate table YYY;
SET FOREIGN_KEY_CHECKS = 1;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Postgress - Read a XML file from a postgress table XML column
SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...
System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
if more than 65535 files in your temp folder, this error can occurs, To resolve this, remove all temporary files in C:/Windows/Temp ....
How to update first character upper case in Oracle
select upper(substr(CTY_CITY,1,1))|| substr(CTY_CITY,2,length(CTY_CITY)-1) as Ax from AGM_M_COUNTRY_CITY; update AGM_M_COUNTRY_CITY set ...
Sender Parameter/ Common functions (C#)
Common text box validation function for all the text boxes within the same form. Using Sender parameter to handle. private void tex...
No comments:
Post a Comment