MySQL Database Forum

------=_NextPart_000_0000_01C35111.935D6050 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, Mysql Version 4.0.11a-gamma When I try and run the following query

Hello all, I wonder if is there any way to select from a table all the records which has a Date Field that is at least five minutes old? In other words, I have a table with a date field and I need to select all the records that are older than five minutes, has their date field updated before five minutes.

Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0 |

How do I fix this error? My tables have data. Regards, Jake Johnson jake@plutoid.com ______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts.

--0-474210375-1058976151=:31789 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Note: forwarded message attached. __________________________________

Hello Guys, I have Risc/AlphaServer ES40 with processor EV6 500mhz running RedHat 7.2/Mysql. Could you please send me Bench test ? I like to try tks, Julio

I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it contains confidential client information. It has to be Window because applications accessing the database are written in Windows. The problem is laptops do get stolen quite often, even when running on someone's unattended desk. Most security chains can be cut with a...

------=_NextPart_000_00FC_01C35142.4E7FDE00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there any way to create a symlink of table in two different = databases which belongs to the same user. It will be great help if I get the solution for above mention task. =20

------=_NextPart_000_00FC_01C35142.4E7FDE00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there any way to create a symlink of table in two different = databases which belongs to the same user. It will be great help if I get the solution for above mention task. =20

I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0...

I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson jake@plutoid.com ______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and...

Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb > out.sql but returns this .... -- MySQL dump 8.21 --

Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which was working fine until a while ago. I haven't watched it recently, and haven't changed anything I am aware off right now. After I realized the...

Hi, I have read that Unicode (UTF-8) was not enabled by default in the mysql-4.1.0-alpha binaries. How can I enable it? What should I change in the code to do so? Thanks Vincent

------_=_NextPart_001_01C35095.401E90C0 Content-Type: text/plain; charset="iso-8859-1" I would like to know if there is a way of building an index on all the words of a column. We want to have an alphabetical search on all the words of a description of a product.

Hi. I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... My initial thoughts on how to do this are: 1. Execute a...

Hi,=20 I have a query that runs in Microsoft Access against my mysql database = just fine. It is:=20 =20 UPDATE discussion_categories AS discussion_categories_1=20 INNER JOIN discussion_categories ON=20 discussion_categories_1.parent_1_text =3D discussion_categories.name=20 SET discussion_categories_1.parent_1 =3D =

Hi. I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... My initial thoughts on how to do this are: 1. Execute a...

http://www.etsetb.upc.es/download/sources/dump_grants/ DESCRIPTION This tool dumps the permissions granted to the users of the MySQL database. It also could print a report of dangerous grants. USAGE

As far I remember full-text doesn't work with utf-8. Anybody knows the estimated time when it will be supported ?? I next few months 4.1 version will be ready to use (I hope so...) and I wish to use utf-8 charsets, but very important issue is full-text search. I'm also curious with InnoDB support for Full-Text search. Best regards,...

Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an...

As far I remember full-text doesn't work with utf-8. Anybody knows the estimated time when it will be supported ?? I next few months 4.1 version will be ready to use (I hope so...) and I wish to use utf-8 charsets, but very important issue is full-text search. I'm also curious with InnoDB support for Full-Text search. Best regards,...

Hi all, hope I can learn a lot from this mailing list! _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Hey folks, before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables. Some pointers may be invalid and cause the...

Hi all, hope I can learn a lot from this mailing list! _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql