Search results for query: *

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

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

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...

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

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...

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

Is is possible to drop table if exists and create it in the same query? Thanks, sb

I have a table called pru_1_a, and one called pru_10_b. If I say show tables like "pru_1_%" I get both listed. This is odd. What am I doing wrong? Thanks, sb

I need the names of the tables to be different, but I want to create an identically structured table in my database patterned after a table in another database. I cant really create it and populate it with select * since I dont know the fields in the other in advance. Thanks, sb

I know how to 'undump' a sql file which has tables specific to a database. Butif my sql file contains several databases (or even just one database) hwo do I stick it into mysql? I tried mysql < file.sql since for the tables counterpart it is mysql mydb < fileOfTables.sql But I couldnt get my...

Is there a way to insert into one table a particular row from another table in one statement? Both tables are identical in terms of columns. Or do I have to select * from the latter and insert into values() into the first table? Thanks, sb

I want to view the contents of a .mysql file created by using mysqldump. Short of reading it back into a database using mysql, is there a way just to view what tables are in it? Thanks sb

I tried typing in mysqldump in the client but it doesnt know what this is. Do I need to install something? I was looking for a download link on the mysql site for the mysqldump program but cant find it. I do see mysql snap at other websites but want to get it from the official site if indeed...

I need to only give a few tables from my mysql database to someone else. How do I do this so that they can load them into mysql on their machine? I dont want to give them the whole database. thanks, sb

I downloaded for windows: mysql-4.1.10-win32.zip and installed it. I dont see mysql.h anywhere. How do I get it? Thanks, sb

I googled but cant find it: I need to know how to create a column thats unique when I make my table. Thanks, sb

I go to /usr/lib/mysql to run mysql, but I dont see my database in that folder (linux). Where are these databases located? Thanks, sb