Re: table join trouble

2008-01-06 Thread Shawn Green
Hi Edward, (see below) Edward Corbett wrote: Hi, I am trying to join a bunch of tables together. I want a row for each learner, and on the row, I want some user, centre, client and centreManager information if there is any. Thus, I am trying to outer join from the learner table to 4 other

Re: Embedding MySQL

2008-01-06 Thread Shawn Green
Octavian Rasnita wrote: Hi, I want to embed MySQL and install it with a freeware application I make. I hope it is legally to do this. Please tell me where can I found more information about how can I do this. The app will run under Windows. Thank you. Octavian Please refer to

Re: Inter-version client/server compatibility

2008-01-06 Thread Shawn Green
Charles Jardine wrote: To what extent can MySQL clients interact with servers of different versions? In particular, if I link an Apache PHP module with the client libraries for MySQL version 5.0.51, will I be able to use it to connect to a version 4.1.22 server? I ask this because I am running

Re: Using DROP USER in a stored procedure

2008-01-06 Thread Shawn Green
Eddie Cornejo wrote: I really hope I'm not overlooking something simple... I'm writing a cleanup script to remove database items created by my application. One of the things I would like to remove are all user accounts created through my application... This is proving to be harder than it

Re: Fast relevance sorting of full text search results

2008-01-06 Thread Shawn Green
Urms wrote: I'm using pretty standard approach to sorting search results by relevancy: SELECT DISTINCT product_name, MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS rate FROM _TT WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE ) 0

Re: Search for column value in a string variable?

2008-01-06 Thread Barry Newton
OK, never mind. I finally found the 'locate' function. I knew it had to be there somewhere! -- Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using DROP USER in a stored procedure

2008-01-06 Thread Eddie Cornejo
On Jan 7, 2008 2:34 AM, Shawn Green [EMAIL PROTECTED] wrote: Eddie Cornejo wrote: I'm writing a cleanup script to remove database items created by my application. One of the things I would like to remove are all user accounts created through my application... This is proving to be harder

why in procedure truncate table do not reset auto_increment?

2008-01-06 Thread 过客
*hi everyone: * I've some puzzle with the following test: CREATE TABLE `demo` ( `id` int(11) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; INSERT INTO demo VALUES(100); delimiter // create procedure test() DETERMINISTIC begin