Possible to copy the key field to another on INSERT?

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

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

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 It

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

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. w...@us-webmasters.com When creating a record, the first field (KeyField)... KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT ...is it possible to copy this auto

Completely remove MySQL?

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

Re: Completely remove MySQL?

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 addresses on my local network. Unfortunately, When using phpMyAdmin to access a database, it tries to access the database

Re[4]: Delphi 7 and MySQL

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 MySQLlib? MT The Microolap

Re: Delphi 7 (6) and MySQL

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 I need

RE: Delphi 7 (6) and MySQL

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: Tuesday, June 15, 2004 2:01 PM To: [EMAIL

Re: need reference for a good book

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 List

Re: Large lists of SQL commands choking PHPmyAdmin?

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, since I can import several hundred records using PHPmyAdmin

Re: php script for new database and user

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 a

Large lists of SQL commands choking PHPmyAdmin?

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: Transfering from access to MySQL?

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!™ -

Re: What's up with this GATOR crap?

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'. Download

Re: Can MySQL handle 120 million records?

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: Can MySQL handle 120 million records?

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: email marketing software

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 anything