why i select * from a table,mysql should select 2000000 records out,but

2003-12-23 Thread xian ting
actually ,mysql only return 17000 records if that means mysql select has max record limit? _ MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

help me!!!how to write such sql in mysql?

2003-12-18 Thread xian ting
in sql: insert into table select from ... can select from a remote data base server such as sqlserver using odbc as 'SELECT * into test01 FROM Fund IN [ODBC] [ODBC;Driver=SQL Server;UID=admin;PWD=;Server=(lacal);DataBase=CMBXMDM;]'in access. thanks!

Have you use emmbedded mysql in C++Builder?i met a problem,i hope you can help m

2003-12-16 Thread xian ting
Hi! I am trying to get access to the MySQL embedded server using the library libmysql.dll through c++builder. The loading of the library goes well, but when calls are made to start the server, the application crashes.when i run the program ,the program crashed in mysql_server_end my program as

help me!!!when i compile libmysqd of mysql src ,i always met a problem !

2003-12-16 Thread xian ting
Creating library ../lib_debug/libmysqld.lib and object ../lib_debug/libmysqld.exp set_var.obj : error LNK2001: unresolved external symbol _resize_thr_alarm ../lib_debug/libmysqld.dll : fatal error LNK1120: 1 unresolved externals Error executing link.exe. but i have link mysys.lib ,how to solve

help me!!!when i compile libmysqd of mysql src ,i always met a problem

2003-12-16 Thread xian ting
Creating library ../lib_debug/libmysqld.lib and object ../lib_debug/libmysqld.exp set_var.obj : error LNK2001: unresolved external symbol _resize_thr_alarm ../lib_debug/libmysqld.dll : fatal error LNK1120: 1 unresolved externals Error executing link.exe. but i have link mysys.lib ,how to solve