Re: Perl API

--- Darren Young [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Where are places to obtain information about the Perl API for MySQL? Is there possibly a list specific to that topic? == Try out search key words: DBI Perl tutorial in http://www.google.com/

Re: About installation on Linux

, there is NO mysqladmin program at the /usr/bin/ directory I try to use the shell = mysql to see whether mysql command works but unexpectly, bash: mysql: command not found message was return back. Please advice me what I need to do. I am using Red Hat Linux version 7.3 Son Nguyen

Re: About installation on Linux

, there is NO mysqladmin program at the /usr/bin/ directory I try to use the shell = mysql to see whether mysql command works but unexpectly, bash: mysql: command not found message was return back. Please advice me what I need to do. I am using Red Hat Linux version 7.3 Son Nguyen

ORDER BY date DESC

the case ... but to_date is a date type ... What should I write for that SQL statement ? Son Nguyen __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

Re: ORDER BY date DESC

Never mind ... I made a mistake in the SQL statement !!! :-) Son Nguyen --- Son Nguyen [EMAIL PROTECTED] wrote: mysql desc albums; +-+-+--+-+++ | Field | Type| Null | Key | Default| Extra

Re: UTF-8 national characters

I've been storing data in UTF8 Unicode (Vietnamese) format in mySQL database. I didn't see any problem of for doing any SELECT statement at all. Son Nguyen --- John D. Stein [EMAIL PROTECTED] wrote: All, I can't seem to find anything about character code sets supported

Get the next AUTO INCREMENT value for a column

AUTO INCREMENT value (which is 3 right now) Son Nguyen mysql, query __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before

SELECT the first letter MATCH in mySQL

unexpected records Son Nguyen __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com

Range of MEDIUMINT, and BIGINT of mySQL type ?

Do anybody knows the range of MEDIUMINT, and BIGINT type to use when I do the create table in mySQL ? Son Nguyen __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com

Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query)

Do anybody knows the range of MEDIUMINT, and BIGINT type to use when I do the create table in mySQL ? Son Nguyen sql, query __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com

Can AUTO_INCREMENT return from INSERT function into a table ?

by 1 mySQL statement? If yes, please can somebody give me a sample code? Son Nguyen __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com

Re: Can AUTO_INCREMENT return from INSERT function into a table ?

--- BD [EMAIL PROTECTED] wrote: Son, At 09:48 PM 4/7/2002, you wrote: mysql desc threads; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

Re: Segmentation Fault when connecting using DBI and option file

--- [EMAIL PROTECTED] wrote: Description: When connecting to mysql database using Perl DBI AND specifying a mysql_read_default_file, this causes a Segmentation Fault. However if a mysql_read_default_file is not used then no error occurs. Linux version is 7.2 Redhat and DBI and

Is it a bug in datetime function HOUR (now()-date_created) ?

??? Son Nguyen __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: problem with '

--- Alex Behrens [EMAIL PROTECTED] wrote: Hey, I'm trying to insert data into a table with a TEXT field but the data I am inserting into the table has a ', present in the data and it gives me an error, the text is as follows: Of all the motherboard manufacturers in the world, there

Calculate current age with given birthday

this query, but... it's not working out: SELECT YEAR(now()-birthday) from users where loginName=test; Son Nguyen __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com

Re: Perl - mysql

--- Horváth_Szabolcs [EMAIL PROTECTED] wrote: Hello everyone! I would like to use my mysql server via Perl. Does anyone send me links or documents about it? Thanks Szabolcs I am using DBI module in Perl to connect to mySQL database. More information can be found at the below link

Race condition between two update queries request at the same time on the same piece of data in mySQL

, mySQL is locked until the update query to be finished. Then mySQL take the second user's request? Anybody knows the answer to my question, please response, Son Nguyen __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http

Re: Query Synchronization

It's like multiple script try to update the same piece of data in the mySQL at the same time. Do I need to provide a method to synchronize to all my scripts. Son Nguyen --- Egor Egorov [EMAIL PROTECTED] wrote: Son, Saturday, March 02, 2002, 6:34:37 AM, you wrote: SN

Query Synchronization

Does mySQL synchronization between queries? How does mySQL handle the query synchronization. Does anyone know? __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com