Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query help...
rudy why not share it? I just want to try this if it is really that slow I won't use it but we are running mysql on very fast machines and it would be helpfull if I could compare the alternatives to the raw SQL solution that you could suggest. The only solution I can think of right now is using... -
Query help...
I am using MySQL 4.1.9 which doesn't support stored procedures :( I could possibly do it using a stored procedure, but I need a stable database and not a beta version of 5.x. Actually I think it's not possible using pure SQL without the stored procedure... But bastien if you have an example ;) ... -
Query help...
I would never design a database which contains more values in one field. But unfortunatly I do have no control on the source data I get. Thnx for your reply I will try to solve this in another way, but if anybody has an idea.... Cheerz, CHris -
Query help...
Plz help, I have the following problem. I have a field memory_type which contains the following value 10,20,30. item memory_type ------------ 1 10,20,30 These values refer to another table which contains the normal values like id value ------------- 10 | compact flash 20 | USB 30... -
MySQL service crash
I found out what's wrong. the d.megapixels field is a double and the value field is a varchar, MYSQL doesn't like this and crashes. -
MySQL service crash
Plz help, I have the following query which runs fine without the insert statment. INSERT INTO `db_x`.`attributes` (id, typeid, value, start_time, end_time) SELECT distinct i.id, at.id AS typeid, d.megapixels AS value, NULL AS start_time, NULL AS end_time FROM...
