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 LAST_INSERT_ID() immediately after the INSERT statement? Thanks for any ideas you have. Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 Fast! - http://www.US-Webmasters.com/best-start-page/ $8.99 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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. Thanks Claudio. I wrote a trigger that MySQL accepted. However, when I tried to insert a new record: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger I Googled the error: http://dev.mysql.com/doc/refman/5.5/en/faqs-triggers.html#qandaitem-B-5-1-9 B.5.9: Can triggers access tables? A trigger can access both old and new data in its own table. A trigger can also affect other tables, but it is not permitted to modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger. From this it seems that a trigger will not allow me to auto-populate the `AssociatedWith` field the value of the `KeyField`. It looks like I will have to populate that field immediately after creating the record with an additional statement, yes? Does anyone have any other ideas on how to populate the value of one field with the value of the `KeyField' on creation(INSERT)? I want to 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. 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-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() immediately after the INSERT statement? Thanks for any ideas you have. Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $9.99 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 database--as well easily reinstall PHP, MySQL, and phpMyAdmin--but how do I remove everything so that the old IP address is not referenced? By the way, where is this IP address being stored? Thanks mucho for any light you can shed! Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Completely remove MySQL?
At 14:40 11/7/2004, Michael Stassen wrote: That's using a shotgun to kill a gnat. That's why I have large gaping holes in my walls. The IP used by phpmyadmin is set in the config.inc.php file in the phpmyadmin directory. Just edit this file to change the old setting to the new value. Problem solved. Yes, it certainly is. Thanks a bunch! Reinstalling mysql and php, on the other hand, will have no effect. Reinstalling phpmyadmin may replace config.inc.php with default settings, but you'd still have to edit it to have the correct 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 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 database--as well easily reinstall PHP, MySQL, and phpMyAdmin--but how do I remove everything so that the old IP address is not referenced? By the way, where is this IP address being stored? Thanks mucho for any light you can shed! Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 components don't. Yes, it need it. But zeos can be use to all open source database, and there is a good community. Is there a mailing list? I looked, but couldn't find one. http://sourceforge.net/projects/zeoslib/ Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 a driver like this if running Delphi 6 on Windows that would access MySQL on a FreeBSD box over a lan? Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED] Subject: 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 a driver like this if running Delphi 6 on Windows that would access MySQL on a FreeBSD box over a lan? Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names - http://domains.us-webmasters.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. However, when I try to import a few thousand records, everything seems to go berserk. Does anyone have a simple way of adding a 5 or 10 thousand records at a time? You can read the dump file back into the server with: shell mysql db_name backup-file.sql Or: shell mysql -e source /path-to-backup/backup-file.sql db_name More info here: http://www.mysql.com/doc/en/mysqldump.html olinux Thanks, O. Is the dump file all SQL statements? The file that I am importing is all INSERT INTO statments. Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 new database on my installation of mysql on my home computer (be able to do this from my office or another computer). It seems like a simple enough thing to do but I have been unable to find any examples... Any help would be appreciated. Thanks, BGLefty Do you have PHPmyAdmin installed? You can quite a bit of work fairly easily with it. Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, everything seems to go berserk. Does anyone have a simple way of adding a 5 or 10 thousand records at a time? Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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! - http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 it. Install it. Run it. Remove Gator. Be careful what you install from now on. Besides AdAware, you may want to try SpyBot too: http://www.Google.com/search?q=SpyBot+Search+and+Destroy http://www.Google.com/search?q=AdAware Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, *even with MySQL-4.1* (yes, I'm currently using 4.1 on this production server ;)). So for me MySQL is ready for a mission critical environment :) Wow! What kind of hardware? What OS? Start Here to Find It Fast!© - http://www.US-Webmasters.com/best-start-page/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 about spamming. I'm working on a CRM project that sends target opt-in mailings. I am a regular user of this list and MySQL and was asking a LEGITIMATE question. You must be waiting to blast people when you think they're asking something other than a hard-core SQL or development issue. Go blow your steam somewhere else. Thanks to those who have responded. MS - Original Message - From: Curtis Maurand [EMAIL PROTECTED] To: Mark Stringham [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 9:35 PM Subject: Re: email marketing software I hope your kidding. You're actually asking for help to spam people? In this environment. Should I ban your domain, now and save the trouble of having to deal with the spam later? Its taken me a couple of years to finally get a handle on the spam and I still don't have it all. Since I have a rule that says any mail to lists.mysql.com goes to a folder before the filter that says anything with email marketing in the body is the only reason that this email didn't end up in the junkmail folder. Curtis - Original Message - From: Mark Stringham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 9:02 PM Subject: email marketing software My bad about the subject line . MS - Original Message - From: Mark Stringham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:57 PM Subject: Re: Transactions not supported by database - Perl Anyone know of an email marketing software suite that works well with MySQL on the backend? I've seen stuff that works with ODBC db connectivity but I'm not interested in moving to MS SQL or Access. Any feedback is appreciated Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Start Here to Find It Fast!© - http://www.US-Webmasters.com/best-start-page/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php