Problem with libmysqlclient

2007-03-18 Thread moyi xianzi
Hello,everyone! I want to use Mysql C API to connect to Mysql server. When I use the following command : gcc test.c -o test.bin -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lz, I got the erro information: /usr/local/mysql/lib/libmysqlclient.a(ssl.o)(.gnu.linkonce.d.__vt_Q25yaSS

Re: Do sourced queries automatically commit?

2007-03-18 Thread Jo�o C�ndido de Souza Neto
Could you try to put the start transaction into your .sql file. ""Kevin Chen"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Greetings all, I am trying to track down the cause of some issues I'm > having. I am doing this from the mysql prompt: > > start transaction; > source c

Re: Is there a professional quality mySQL GUI for Linux?

2007-03-18 Thread Mailing Lists
On Mar 15, 2007, at 4:25 AM, Daevid Vincent wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can

Do sourced queries automatically commit?

2007-03-18 Thread Kevin Chen
Greetings all, I am trying to track down the cause of some issues I'm having. I am doing this from the mysql prompt: start transaction; source c:/queries.sql; rollback; When I examine the db though, it appears that the changes from the sourced queries have been committed. -- MySQL General Ma

Re: Searching for Dates

2007-03-18 Thread Jim Ginn
Dan: Thanks! Jim > In the last episode (Mar 18), Jim Ginn said: >> > In the last episode (Mar 16), Bob Cooper said: >> >> I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new >> >> to both SQL and MySQL. I have been able to query out most of the >> >> data I need from my tables wi

Re: Searching for Dates

2007-03-18 Thread Dan Nelson
In the last episode (Mar 18), Jim Ginn said: > > In the last episode (Mar 16), Bob Cooper said: > >> I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new > >> to both SQL and MySQL. I have been able to query out most of the > >> data I need from my tables without any issues but his on

Re: Searching for Dates

2007-03-18 Thread Jim Ginn
Dan: I've used the TO_DAYS on a SELECT statement ie: SELECT * FROM properties WHERE (TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC however it didn't seem to take advantage or use the index on that field (ie. CreationDate) ... Jim > In the last episode (Mar 16), Bob Cooper said: