Re: Diff Mysql and mysqli

2009-05-18 Thread Scott Haneda
On May 18, 2009, at 8:09 PM, bharani kumar wrote: Can u please tell me the difference between mysql and mysqli , My brief understanding of it is that MySqli is more feature rich and better able to handle changes as MySql moves forward. Some have said it is faster, though I have not perso

Diff Mysql and mysqli

2009-05-18 Thread bharani kumar
Hi All, Can u please tell me the difference between mysql and mysqli , Thanks -- உங்கள் நண்பன் பரணி குமார் Regards B.S.Bharanikumar POST YOUR OPINION http://bharanikumariyerphp.site88.net/bharanikumar/

load data into temporary table

2009-05-18 Thread Alex K
Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Native Function

2009-05-18 Thread Martin Gainty
good morning alex the libmysqld is a embedded server library http://dev.mysql.com/doc/refman/5.0/en/libmysqld.html instead of mysql calling your C/C++ function your C/C++ function is calling the mysql functions mysql_library_init() Should be called before any other MySQL function is called, pref

Re: Native Function

2009-05-18 Thread Alex Katebi
Hello Martin, This sounds great! I am not sure if plugins are supported for the embedded mysql applications. Meaning that my application is linked with the libmysqld not libmysql. Do you know the answer? Thanks, Alex On Mon, May 18, 2009 at 10:17 AM, Martin Gainty wrote: > yes if the lib

Re: xtrabackup

2009-05-18 Thread Walt Weaver
Will do. Thanks! --Walt On Sun, May 17, 2009 at 2:37 PM, Baron Schwartz wrote: > Walt, > > I mentioned your question to Vadim Tkachenko who knows the most about > it, and he suggested that it might be more appropriate to discuss on > the percona-discuss...@googlegroups.com mailing list. > > Than

Native Function

2009-05-18 Thread Alex Katebi
Hi All, I am using the mysql embedded library (libmysqld) in my application. I am using triggers and calling a C/C++ function in my application. This is how I convey configuration changes to my application. I think my only choice is to make a Native Function in the mysql source code since UDF

Re: If condition in select query / insert /update

2009-05-18 Thread bharani kumar
Can u tell me , assume if i use If in the query , then i reduce performance , Any idea On Mon, May 18, 2009 at 3:19 PM, Janek Bogucki wrote: > Hi, > > mysql> create table t(i int); > > mysql> insert into t values(1),(2),(3); > > mysql> select i, if(i <= 1, 'low', 'high') from t order by i; > +--

Re: If condition in select query / insert /update

2009-05-18 Thread Janek Bogucki
Hi, mysql> create table t(i int); mysql> insert into t values(1),(2),(3); mysql> select i, if(i <= 1, 'low', 'high') from t order by i; +--+---+ | i| if(i <= 1, 'low', 'high') | +--+---+ |1 | low | |2 | hig