network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 2 months |
| seen | Mar 29 at 7:14 | |
| stats | profile views | 2 |
|
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 |
comment |
Mysql Normalization @ypercube Pairing does not matter in above result. All i just want to pull rows from email and phonenumber table using a single query. order of the records may differe. |
|
Apr 6 |
comment |
Mysql Normalization I just wanted to fetch rows from email and phonenumber table is a single query |
|
Apr 6 |
asked | Creat Temporary Id in SQL Statement |
|
Apr 6 |
comment |
Mysql Normalization Oh i see you have removed your previous answer where you had written all queries |
|
Apr 6 |
comment |
Mysql Normalization Your anwer is again wrong. First thing is that you should have add "3" id for 'alpha3@test.com' in the above query and secondly as i said in my previous comment that if you change the id field values of Phonenumber table from 1,2,3 to something else like 7,8,9 then your query does not work. You can try it. Just change ids of Phonenumber and run your own query then you will find the result. |
|
Apr 6 |
comment |
Mysql Normalization The above query works fine if id of phonenumber table and email are same...Otherwise no result will come..I changed my id of phonenumber and run your query and didnt get any result...So you can not join B.id = C.id that is wrong |
|
Apr 6 |
comment |
Mysql Normalization Thanks for your reply but this query is giving me 9 rows where as i want to have just 3 rows. |
|
Apr 6 |
asked | Mysql Normalization |
