Re: Possible to copy the key field to another on INSERT?

2012-10-17 Thread W. D.
be able to search on the `AssociatedWith` field to find all records that rely on that first record's `KeyField`. > >PS: I am curious to know why you would do that anyway > >2012/10/17 W. D. > >> When creating a record, the first field (KeyField)... >> >>

Re: Possible to copy the key field to another on INSERT?

2012-10-17 Thread W. D.
At 02:44 10/17/2012, Claudio Nanni, wrote: >Take a look at TRIGGERS > >C. > >PS: I am curious to know why you would do that anyway Will want this 'AssociatedWith' field to be associated with an older records' KeyField so I can search for a group of records by this field. Start Here to Find

Possible to copy the key field to another on INSERT?

2012-10-16 Thread W. D.
When creating a record, the first field (KeyField)... KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT ...is it possible to copy this auto-generated value into another field when using the same INSERT that creates the record? Or would I have to use an UPDATE query using LAST_INSERT_ID()

Re: Completely remove MySQL?

2004-11-07 Thread W. D.
orrect settings, so you may as >well just edit the one you already have. > >Michael > >W. D. wrote: > >> Hi Folks, >> >> How does one completely remove MySQL from FreeBSD 4.9? >> >> My router died, and upon replacement I switched to >> static IP

Completely remove MySQL?

2004-11-07 Thread W. D.
Hi Folks, How does one completely remove MySQL from FreeBSD 4.9? My router died, and upon replacement I switched to static IP addresses on my local network. Unfortunately, When using phpMyAdmin to access a database, it tries to access the database at the old IP. I can easily recreate the databa

Re[4]: Delphi 7 and MySQL

2004-06-17 Thread W. D.
At 03:08 6/17/2004, vanquish, wrote: >Bonjour Martijn, > >>> >> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 >>> >> anyone have an answer for my PLEASE >>> >>> I'am using Zeoslib (www.ZeosLib.net). It's fast, free, open source and >>> powerfull. > >MT> Does it require MySQ

RE: Delphi 7 (&6) and MySQL

2004-06-15 Thread W. D.
Thanks for the info! At 15:01 6/15/2004, Darryl Hoar wrote: >I'm using the Zeoslib control to do just that. >www.zeoslib.net. Works like a champ for me. >And its opensource. > > >> -Original Message- >> From: W. D. [mailto:[EMAIL PROTECTED] >> Sent

Re: Delphi 7 (&6) and MySQL

2004-06-15 Thread W. D.
At 09:04 6/15/2004, Martijn Tonies, wrote: >Hi, > >> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do >> anyone have an answer for my PLEASE > >We're using the Microolap.com components - they have either >direct components (TDataset compatible) or a dbExpress driver. Would

Re: need reference for a good book

2004-03-28 Thread W. D.
At 13:41 3/28/2004, A Mathias wrote: >Preferably one that is for begginers to medium and thats covers both mySQL >and PHP > >Thanks I like the Welling & Thomson book: http://tinyurl.com/3cpk5 Start Here to Find It Fast!™ -> http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing

Re: Large lists of SQL commands choking PHPmyAdmin?

2004-03-18 Thread W. D.
At 02:03 3/18/2004, olinux wrote: >--- "W. D." wrote: >> I am a relative newbie to MySQL and PHPmyAdmin. I >> tried adding >> data into an existing table by 'uploading' a file in >> PHPmyAdmin. >> I know the INSERT INTO commands are valid, s

Large lists of SQL commands choking PHPmyAdmin?

2004-03-17 Thread W. D.
Hi Folks, I am a relative newbie to MySQL and PHPmyAdmin. I tried adding data into an existing table by 'uploading' a file in PHPmyAdmin. I know the INSERT INTO commands are valid, since I can import several hundred records using PHPmyAdmin. However, when I try to import a few thousand records,

Re: php script for new database and user

2004-03-17 Thread W. D.
At 11:45 3/17/2004, BGLefty wrote: > >Is there a simple php script out there somewhere (or an example of how to do >it) to create a new database, username and password? I would like to have a >form in a password protected folder on my web site and be able to fill in >those three variables to create

Re: Transfering from access to MySQL?

2004-02-25 Thread W. D.
At 02:32 2/25/2004, Jonas Lindén wrote: >Hello, Could someone help me with a tip on how I can convert my old Access >DBs to MySQL? > >Regards >/Jonas I've had some success with Cynergi.net's ExportSQL script http://www.Cynergi.net/exportsql/ Start Here to Find It Fast!™ -> http://www.US-Webmaste

Re: What's up with this GATOR crap?

2003-07-10 Thread W. D.
At 23:01 7/10/2003, Daniel Kasak, wrote: >C. Reeve wrote: >>I go to the MySQL manual page I >>get prompted to install Gator spyware. >Please remain calm. >You must have gotten Gator on your computer all by yourself because it >certainly doesn't come with MySQL. >Search on Google for 'AdAware'. >D

Re: Can MySQL handle 120 million records?

2002-12-18 Thread W. D.
At 13:05 12/18/2002, Csongor Fagyal, wrote: >What you need to have is a _good_ install, and then MySQL is superb. But >to have a "good install" is not as easy as it sounds. Can you list the elements of a good install? Start Here to Find It Fast!© -> http://www.US-Webmasters.com/best-start-page

Re: Can MySQL handle 120 million records?

2002-12-18 Thread W. D.
At 10:40 12/18/2002, Jocelyn Fournier wrote: >Hi, > >I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some >tables contains more than 40 millions of rows) under quite high stress >(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables) >I never experienced any losses

Re: email marketing software

2002-08-15 Thread W. D.
MailLoop works for opt-in mailings. Uses a text database however. You would have to do some sort of export. It is very configurable though. http://www.MarketingTips.com/noc.cgi/648957/mailloop.html At 22:46 8/15/2002, Mark Stringham wrote: >Hey Curtis - > >Calm down - I never said anythin