RE: Client does not support authentication protocol requested by server

I would have a look here: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Secondly, if I'm not mistaking, the some_host should be localhost if you want the script only to be able to connect from the local computer and % if you want the connection to be possible from any possible host. At le

convert duration(mediumint) to hours and minutes

numerical entries to hh:mm in my query? (days do not matter, I just need hours and minutes, thx) Regards and thanks, Reinhart Viane D-studio Graaf van Egmontstraat 15/3 2800 Mechelen [EMAIL PROTECTED] +32(0)15 44 89 01 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

joining tables

Table1: events Durationworkdateclientidpersonid 60 2006-01-03 1 51 48 2006-01-03 2 51 167 2006-01-03 4 51 Table2: clients Clientidname 1 client1 2

myodbc version 3.21.X

Hey list, I'm am currently looking for myODBC 3.21.X but can't seem to find a suited downloadsite. Does anyone know a link to this version? Thanks in advance, Reinhart Viane

RE: change field to auto increment

, Reinhart Viane Btw, how do you show your tables layout like you did in this mail? -Oorspronkelijk bericht- Van: Michael Stassen [mailto:[EMAIL PROTECTED] Verzonden: woensdag 1 juni 2005 16:47 Aan: [EMAIL PROTECTED] CC: mysql@lists.mysql.com Onderwerp: Re: change field to auto increment

change field to auto increment

Hey list, I need a query that checks if a certain table column has type auto-increment If not set it to auto increment, else do nothing. Let's say I have the table objects (object_id, object_name) in which object_id is the primary field. Now check to see if object_id is auto_increment a

percentage query

Hey all, I have some difficulties building a querie. Table objects type_id area Table 4dtypes type_id name what I need is a query who gives me the folowing result: name (grouped by type_id) - sum of area -- percentage of total area so I need to group the records on type_i

RE: Remove 1st 3 Chars

Look at the substring example here http://dev.mysql.com/doc/mysql/en/string-functions.html Regards, Reinhart Viane -Oorspronkelijk bericht- Van: shaun thornburgh [mailto:[EMAIL PROTECTED] Verzonden: woensdag 11 mei 2005 13:30 Aan: mysql@lists.mysql.com Onderwerp: Remove 1st 3 Chars Hi

RE: Help with LIKE

Maybe you better do something like: SELECT * FROM woorden WHERE % woord % LIKE -Oorspronkelijk bericht- Van: Mevershosting.nl [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 18 maart 2005 16:11 Aan: mysql@lists.mysql.com Onderwerp: Help with LIKE Dear list, I need some help on this, I hav

show all running queries on linux

Hey list, How can I see the running queries on a linux comp? Thx Reinhart

list

Checking if this message gets through     Reinhart Viane D-studio [EMAIL PROTECTED]   Graaf van Egmontstraat 15/3 – 2800 Mechelen Tel: +32 (0)15 448 901     STRICTLY PERSONAL AND CONFIDENTIAL This message may contain confidential and proprietary material for the sole use

Best way to order mysql results with limit

) activities of each act_type_id     Is there a way to do this cleanly or should I better do a full select and only get what I want with php?   Thx in advance.   Btw I’m using MySQL 4.0.1-alpha-nt       Reinhart Viane D-studio [EMAIL PROTECTED]   Graaf van Egmontstraat 15/3 – 2800

RE: compare dates

amr.ro - Original Message - From: Reinhart Viane To: mysql@lists.mysql.com Sent: Friday, February 18, 2005 1:10 PM Subject: compare dates Hey list I need a query like this: Select * from activities where act_date = today or any day in the future I have made it work lik

compare dates

Hey list   I need a query like this: Select * from activities where act_date = today or any day in the future   I have made it work like this: Sselect * from activities where UNIX_TIMESTAMP()< UNIX_TIMESTAMP(act_date)   Problem is with this thing I have to manually add 23:59:59 to e

RE: Cannot connect to local server problem

Did you reboor after install? -Original Message- From: Leandro Melo [mailto:[EMAIL PROTECTED] Sent: woensdag 15 december 2004 14:51 To: lista mysql Subject: Cannot connect to local server problem Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow,

query data from two tables

amount of users of that region. It should be all online chatters from that specified region. What can be the correct syntax? Thx in advance Reinhart Viane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]