Re: Pattern matching queries

2001-08-12 Thread oltra jean-michel
(REGEXP). I have a text field that contains some plain text intermingled with html tags. In querying the database, if the keyword I'm searching for falls within the plain text, that record should be returned. However, if the keyword falls within an html tag, it should not be returned.

Re: Problems with libmysqlclient.so.10.0

2001-08-12 Thread X Lsi Maillard
# httpd /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No such file or directory but I can locate the file at these tree places at the server, so where do i have to place the file before the server can see it does exist. ? /usr/local/lib/mysql/libmysqlclient.so.10.0

Connexion to server

2001-08-12 Thread lepemp Gael
Hi, I tried to connect at the server but all time with different user and pssword the info message said: Access denied for user: [EMAIL PROTECTED] Access denied for user: [EMAIL PROTECTED] I can connect to mt database with command: [root@localhost glepemp] mysql - u root -p

ADV

2001-08-12 Thread skyward_7
Dear [EMAIL PROTECTED], Dear Friends Future Millionaire: YOU REALLY OWE IT TO YOURSELF TO LOOK AT THIS!! AS SEEN ON NATIONAL TV: ''Making over half million dollars every 4 to 5 months from your home for an investment of only $25 U.S. Dollars expense one time'' THANKS TO THE COMPUTER AGE AND

help (urgent!!!) with a query

2001-08-12 Thread hassan el forkani
hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only

RE: help (urgent!!!) with a query

2001-08-12 Thread Don Read
On 13-Aug-2001 hassan el forkani wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but

Re: help (urgent!!!) with a query

2001-08-12 Thread mickalo
On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani [EMAIL PROTECTED] wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked

Referential Integrity

2001-08-12 Thread Diego Bendlin
I read that MySQL doesn't support the referential integrity, so i wan to know if you recommend to use it in systems with complex relationated tables in a database. If yes, where can i find helpfull documentation about that. thanks PD: sorry about my grammar and stuff, see i normally communicate

Replication resynchronize fails!

2001-08-12 Thread Steve Rapaport
Has anyone successfully resynchronized two replicated Mysql's (most recent version)? I had a big glitch so I followed the directions in the manual: shut down the servers, checked the my.cfg settings, copied over the whole data directory, and restarted both servers. I keep getting an error

Re: Referential Integrity

2001-08-12 Thread John Meyer
At 11:02 PM 8/12/01 -0300, you wrote: I read that MySQL doesn't support the referential integrity, so i wan to know if you recommend to use it in systems with complex relationated tables in a database. If yes, where can i find helpfull documentation about that. thanks PD: sorry about my grammar

InnoDB and Multithread

2001-08-12 Thread
Hi, everyone. I CREATE TABLE foo VALUE(name chare(20), email char(30)) type=InnoDB and I inserted some records. And then I made simple program using just two threads except main thread. Let's call the first A thread and the second B thread. Main thread just runs these threads. Thread A inserts

Re: InnoDB and Multithread

2001-08-12 Thread Jeremy Zawodny
On Mon, Aug 13, 2001 at 01:03:38PM +0900, ½ÉÃ溸 wrote: Hi, everyone. I CREATE TABLE foo VALUE(name chare(20), email char(30)) type=InnoDB and I inserted some records. And then I made simple program using just two threads except main thread. Let's call the first A thread and the second B

RE: InnoDB and Multithread

2001-08-12 Thread CHARLEY
Yes, I am!!! -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 1:13 PM To: ¨öEA©¡¨¬¢¬ Cc: '[EMAIL PROTECTED]' Subject: Re: InnoDB and Multithread On Mon, Aug 13, 2001 at 01:03:38PM +0900, ½ÉÃ溸 wrote: Hi, everyone. I CREATE TABLE foo

Re: Optimising for 4096MB RAM

2001-08-12 Thread Corin Hartland-Swann
Hi, On Thu, 9 Aug 2001, Fournier Jocelyn [Presence-PC] wrote: set-variable = join_buffer=2048M set-variable = key_buffer=2048M set-variable = table_cache=1024 set-variable = record_buffer=2048M set-variable = sort_buffer=2048M set-variable = tmp_table_size=2048M Your record buffer

RE: Inserting rows in MySQL using PHP

2001-08-12 Thread oltra jean-michel
When i try to insert records into a mysql table through a php script, it is not inserting all the records. eg, i tried to insert 100 records, it is inserting only 94 records... plese help me in sorting out this problem bonjour, trying to insert duplicate rows in a unique field

Newbie questions

2001-08-12 Thread Michael Kimball
I know I'm getting away ahead of myself here, but is there a GUI application development tool for mySQL? Something like Paradox or Access, that lets you create complete applications with attractive screens/forms and even start-up/splash screens. This would be on an NT workstation. And is there

Re:Installation and Services Problem

2001-08-12 Thread Lim Joo Tiong
hi, FYI our company start evaluted mysql version 3.23.38. We can succesfully make installation but unfortunely we can't start services for mysql. Not have any message pop up. After i start winmysqladmin.exe in installation path, we just right click image in our right conner in windows bar