RE: Pattern matching queries

2001-08-12 Thread Joe Sheble \(Wizaerd\)
Then yes, it should be returned. > -Original Message- > > On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote: > > an example would be: > > > > this is some text that would fall within the text field (somefield): > > > > "if you want to see some nice images, check out

Converting

2001-08-12 Thread Horvath Gyula
Dear Members! How can I convert a Corel-Paradox table (.db) to MySQL database ? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Pattern matching queries

2001-08-12 Thread Jeremy Zawodny
On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote: > an example would be: > > this is some text that would fall within the text field (somefield): > > "if you want to see some nice images, check out href="http://www.photoshopuser.com>this website" > > and the query would be:

RE: Pattern matching queries

2001-08-12 Thread Joe Sheble \(Wizaerd\)
an example would be: this is some text that would fall within the text field (somefield): "if you want to see some nice images, check out http://www.photoshopuser.com>this website" and the query would be: WHERE somefield like '%photoshop%' the above record should not be returned. > -Orig

Fw: 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

Re: Pattern matching queries

2001-08-12 Thread Jeremy Zawodny
On Sat, Aug 11, 2001 at 10:54:58PM -0700, Joe Sheble (Wizaerd) wrote: > > 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 ke

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

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: 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

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

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: 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 se

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 j

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 gr

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 messag

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 i

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 o

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 b

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

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 T

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 Enter

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 > /usr/ports/

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