|
Finding duplicate fields
|
| |
Due to an error in my coding :-(now fixed) I have a table with 46,000 entries some of which are doubled up. Can anyone suggest a SELECT query which would find them? There are many fields, but only two are relevant: 'reference' and 'jpeg': there should never be two entries with the same reference and jpeg.... more »
|
|
|
Transactions, Locks, Begin, InnoDB
|
| |
Hi, I'm struggling to get to grips with all the different ways in which you can work concurrently in MySQL. Different parts of the manual describe different methods, as do different tutorials. What's the difference between START TRANSACTION and BEGIN? What's the difference between TABLE LOCKs and InnoDB locks?... more »
|
|
|
mysql on intel based Mac
|
| |
I just replaced my 4 year old imac with a new intel based one. I've had the contents of the hard disc copied over [except that newer versions of the mac-provided software, including php, replaced what I was using with os X 10.3.9] mysql is not provided for the imac. Should what I already have work on... more »
|
|
|
select using if/else??
|
| |
I have two tables: itineraries and schedules. itineraries has a unique id and a text description. schedules has a unique id, an itinerary id as foreign key, and a date for departure. an itinerary may or may not have schedule information. i want to select itinerary_id, itinerary_description and, if it... more »
|
|
|
Dynamic where clause help please
|
| |
Create Procedure GetUserInfo( inGroupID Int, inExtraInfo VarChar( 32 ) ) Begin Select FName, LName, Address,... From Personel p Where ( inGroupID = 0 or p.GroupID = inGroupID ) And ( Length( inExtraInfo ) = 0 Or inExtraInfo ) Order by LName,FName; End; *** Note - How do I get the engine to use the content of inExtraInfo... more »
|
|
|
Double Join Problem
|
| |
Im rubbish at doing these joins.. this one is really fathoming me. 3 Tables (brackets are the unique keys Im trying to join). USER(id_user_pk), TODOLIST(id_user,id_patient), PATIENT(id_patient_pk) I thought this would work..Its not failing but it's not bringing anything back which is kind of sad :( SELECT *... more »
|
|
|
Sort by MAX of two dates
|
| |
We have a creation date, and a modified date. I was trying to sort by the maximum of either date. As an example, everything has a creation date, but only some have modified dates. I want to use the creation date to sort, unless it has a modified date, and then I want to use that instead. Is there anyway to do this? Thanks.... more »
|
|
|
List of Servers on Network
|
| |
Is there an easy way to list all instances of MySQL server running on a network? We need this to find a database that one of our in-house applications is connecting to(We SHOULD have this information....I agree...but we dont:))
|
|
|
Multiple WHERE select possible?
|
| |
Ok I want to select two things from a complex table query, one WHERE is exclusionary of the other but I would like the combined result set. i.e.: I want to select a list of all the records once plus any records (in the same data set) with an unpaid-date before today. so some of them may have two records but all have at least one.... more »
|
|
|
foreign key on same table
|
| |
hello, can anybody tell me why this code is not right ? I try to create a foreign key on a column thats located in the same table both coulmn have a index prod_code,prod_color_code i try to accomplish prod_code X with prod_color_code 1 prod_code X with prod_color_code 2... more »
|
|
|
