Search results for query: *

Many thanks. That was exactly it. sb

have a txt file which I want to load into an empty table I do LOAD DATA INFILE 'C:/a.txt' INTO TABLE track1", The file contains entries like 1,30.087336 ,-85.916496 ,-3.139963 ,55 ,0 2,30.087330 ,-85.916496 ,-3.140155 ,55 ,0 3,30.087324 ,-85.916496 ,-3.140346 ,55 ,0 4,30.087318...

I just created my first install program in wise installation express and am getting "internal error 2705 directory" when i try to install the program. How do I fix this? thanks, sb

Never mind. It works now with the ORing. I dont know what I did wrong before. Sorry bout that and thanks for all the help, sb

Yes. These values definitely exist in the table. What I get back from the query is ALL the rows! sb

Hmmmm. I'm not sure: I should have posted exactly what I am doing: CREATE TABLE newtable SELECT * FROM sometable WHERE ID = 10 OR ID = 12 OR ID = 19 In your excerpt above what are sometable1, sometable2 etc? All I have at the moment is the master table 'sometable'. Do I need to create these...

Oh and I also tried WHERE with OR (not AND) That didnt work either

No. I'm trying to create a query like SELECT * FROM sometable WHERE ID = 10 AND... I'm writing c++ code with this. doing WHERE ID = 10 AND ID = 12 AND ID = 45 doesnt work and I can see why. So whats the right way to do this? Thanks, sb

I am trying to create a table with certain select rows from another table. One column in the original table is called ID. I want only those rows with certain ID values (say 56 , 78, 89, 90) etc to be in the new table. How do I do this? Thanks, sb

Thanks for answering. Its not fclose() but close() where it crashes (yes -- debugger). SO I went ahead and changed everything to fopen, fclose() and things are fine with this. Why close() crashed is a mystery. Sb

On linux if I successfully open a file: int fd = open("file.txt",O_RDONLY) check if successful close(fd) it crashes at the close() Why and how to get around this? Thanks, Sb The error msg says free() invalid pointer at some address.

On windows I can mysqldump easily a table named pru$1$10. But on linux I get the error: 1146: Table 'pmadb1.pru0' doesn't exist when doing LOCK TABLES where it looks like the dollar sign is causing a problem. Is this a known issue? Thanks, sb

I am doing: query.sprintf ("UPDATE %s SET %s = %d WHERE ID = %d", aTable.latin1 (), m_alg.latin1 (), tempScore.toInt (), ID); qDebug("score query %s",query.latin1()); int res = mysqlQuery (m_link, query); The query is : UPDATE alg$1649760492$1$100files SET alg_C = 909 WHERE ID = 2...

temp.sprintf ("mysqldump --user=%s --password=%s --opt %s > %s", SQL_USER, SQL_PASSWD, SQL_DB, sqlFile.latin1 ()); indx = system (temp) Basically I am issuing a mysqldump command, which gives me this error. Many thanks for helping, sb

mysqldump: Got error: 1066: Not unique table/alias: 'cad' when doing LOCK TABLES I cant find much info on this. What is wrong that makes this happen? THanks, sb

Thanks so much Laura. It worked! sb

I am "root" and have no password...

On windows I had no problem doing this: mysqldump --opt pmadb1 > testfile; but on linux I get: fromB> mysqldump --opt pmadb1 > may16 mysqldump: Got error: 1045: Access denied for user: 'bonosa@localhost' (Using password: NO) when trying to connect What do I need to do here to get it to work...

That wont work since the tables have varying number of columns. But I do appreciate your help. I guess I will go with a drop query followed by a create. Thanks, sb

What keyword should i look for to get info on how to merge two tables in the same database? Thanks, sb