Re: Load Data Infile

2001-11-26 Thread Elm Gysel
http://www.mysql.com/doc/L/O/LOAD_DATA.html Elm > database,sql,query,table > > Hi guys, >Can any one told me - with my great appreciate - how to load a > data > from txt file into a specific column? > > Thanks. > > Hytham Shehab > > > > > > _

compiling mysql with msvc

2001-11-16 Thread Elm Gysel
Hello, does anyone have workspace and project files to compile MySql with Microsoft Visual Studio? I would like to compile it mysql and debug it on some weird behavour but I truely have no clue what files to compile (eg. what compiles are the core engine and which ain't) Or is this documented so

Query access violation

2001-10-30 Thread Elm Gysel
Hello (again) I have a rather weird problem. I have some service running in my application that is updating some tables every hour. Now this works after the first hour but after the second hour I suddenly get an access violation on the query object. This is the rather normal code.. con->sele

innodb file size usage

2001-10-30 Thread Elm Gysel
Hello! Is there any way to know how much space is used in the innodb data files? So if I have for example : innodb_data_file_path = ibdata1:200M;ibdata2:400M; how much of the 600MB actually is used at the moment Thx! Elm database,sql,query,table --

Table is full?

2001-10-26 Thread Elm Gysel
Hello again! I'm currently inserting all my records into the table and suddenly after 1909152 records I get the error on an INSERT query : The table is full each record is 36 bytes * 1909152 records is 68729472bytes = 68.7mb I'm using innodb tables and innodb_data_file_path is set to innodb_d

query memory problem

2001-10-24 Thread Elm Gysel
Hello, I have a memory problem when added records to a table. The situation is like this (simplyfied) : query << "select id, symbol from " << STOCKS_TABLE_NAME << std::ends; std::vector symbols; query.storein(symbols); std::vector::iterator I; for(I = symbols.begin(); I != symbols.end(); I++) {

select max(datetime) crashes mysql?

2001-10-22 Thread Elm Gysel
I performed the following query : select max(date_time) from vse_history where symbol_id = 1; and mysql crashes. I'm not very good with SQL so I wonder of I'm doing this right at all. I want the record with the highest datetime value where symbol_id = 1 I'm using 3.23.43-max-nt on Windows2000.

Problem using Specialized SQL Structures (MySql++)

2001-10-18 Thread Elm Gysel
Hello, I'm reading and doing some testing with Specialized SQL Structures. I've included both mysql++ and custom-macros.hh . I'm using MSVC as compiler. The problem I'm facing is that I can't get it compiled. I get undeclared identifiers syntax error : identifier 'sql_dummy_type' 'sql_dummy' :