|
Home
Advertise
Contact
Support
About
asp.net c# tips and code example
Home
ASP.NET
C#
WPF
General
Web Design
Tutorials
Contact
Sunday, 1 July 2012
Mysql error 1093 - Can't specify target table for update in FROM clause
23:28
Unknown
UPDATE
table_name a,
(SELECT
Clonum_name
s
FROM table_name
GROUP BY Clonum_name
HAVING COUNT(DISTINCT Cable_no) > 1) b
SET Clonum_name
= CONCAT(Clonum_name
,'_',Cable_no)
WHERE a. Clonum_name
= b.s
0 comments:
Post a Comment
Newer Post
Older Post
Home
About Me
Unknown
View my complete profile
Followers
Categories
.NET Error
(9)
AJAX and Java Script
(9)
ASP.NET
(45)
aspx page to pdf
(1)
C#
(38)
C# Interview Question And Answer
(1)
C#.Oracle
(1)
Data List
(1)
Dynamic Controls
(2)
Excel
(1)
Google Map Api
(4)
Grid View
(11)
HINDI
(1)
IIS
(2)
Microsoft Certifications
(1)
MS Chart
(3)
my sql
(6)
Oracle
(3)
Send Email
(2)
Send SMS
(2)
SQL SERVER
(2)
State management
(1)
Windows
(3)
Windows Services
(2)
WPF
(1)
Blog Archive
▼
2012
(39)
►
August
(3)
▼
July
(17)
Grid layout with Background Image in WPF
Asp.net - display progress bar button click asp net
draggable div using javascript
MySQL Split String Function
how to create a simple File Watcher Windows Serv...
Excel Interop : System.Runtime.InteropServices.COM...
HTTP Error 404 - File or Directory not found with ...
How to Registrar IIS on Windows server or Windows ...
Get ASP.Net Grid View Row Value and its Row Index ...
in ASP.NET copy cell value from one gridview and p...
Sending email with attachment in ASP.NET
How to Send Email from ASP .NET
How to show gridview header when there is no data ...
How to get the selected value and Text from a drop...
Create dynamic textbox using JavaScript in ASP.Net
add dynamic controls(Text box, Checkbox,Dropdownli...
Mysql error 1093 - Can't specify target table for ...
►
June
(5)
►
May
(1)
►
April
(1)
►
March
(6)
►
February
(2)
►
January
(4)
►
2011
(30)
►
December
(7)
►
November
(3)
►
October
(1)
►
September
(1)
►
June
(4)
►
May
(1)
►
April
(2)
►
March
(3)
►
February
(7)
►
January
(1)
►
2010
(21)
►
December
(3)
►
November
(2)
►
October
(1)
►
September
(1)
►
August
(1)
►
July
(13)
Powered by
Blogger
0 comments:
Post a Comment