184 reputation
16
bio website
location
age
visits member for 2 years, 1 month
seen Jan 9 at 8:37

Mar
24
awarded  Notable Question
Jul
8
asked SQL Server: Month Range Join
Mar
28
awarded  Popular Question
Jan
17
answered Mysql: privileges to get access to “mysql” database
Jul
25
comment remove duplicate rows in mysql table that does not contain primary key
Thanks for your answer. But i still don't want to use any third/temp table. I am just looking for an answer that actually help me to use the same query i have written in my question.
Jul
24
comment remove duplicate rows in mysql table that does not contain primary key
@RolandoMySQLDBA: Can you please take a look at my query written in the question and suggest?
Jul
24
awarded  Critic
Jul
24
comment remove duplicate rows in mysql table that does not contain primary key
@ypercube: I also knew this way of using temporary table to delete duplicates. But i was expecting someone to help me on the query written in my question. I don't want to use any other way because using third/temporary table is not a good practice for this.
Jul
23
comment remove duplicate rows in mysql table that does not contain primary key
This is duplicate as item name "toys" and "shirt" is being repeated in a table with Camel case (First letter capital). So i want to delete those records in Camel case.
Jul
23
asked remove duplicate rows in mysql table that does not contain primary key
Apr
9
awarded  Commentator
Apr
9
comment I couldn't compile this little query (needs 2 tables)(mysql)
What exact error you are getting?
Apr
8
awarded  Supporter
Apr
8
comment Creat Temporary Id in SQL Statement
Thanks for your answer Roland. I would like to know if that above solution can be produced without using temp table.
Apr
6
asked Creat Temporary Id in SQL Statement
Mar
14
answered MySQL table with multiple values in one field
Mar
13
awarded  Teacher
Mar
13
comment MySQL UPDATE to replace text in LONGTEXT field
Yes Phil, it can also be used without rounding with quote. I written that way because one quote was missing in the query.
Mar
13
answered MySQL UPDATE to replace text in LONGTEXT field
Mar
12
comment use of signal for insert statement in mysql stored procedure
Actually i wanted track each exception using SIGNAL and wanted to return related error message.