Re: Setting up and running mySQL on a unix server
On Wed, 15 Aug 2001 [EMAIL PROTECTED] wrote: How easy/hard is it install and run mySQL on a unix server? Depends on how you would answer this question: How easy/hard is it to run a Unix server? ;- If you're confortable using Unix and installing software then I think you'll find the basic install and setup of MySQL to be pretty darned easy. If on the other hand you're new to the Unix world as well as new to MySQL it will be a bit more challenging, but is still a straightforward proccess, if you RTFM and give yourself enough time to do it right I don't think the MySQL setup will cause any headaches. Read all about it: http://mysql.com/doc/I/n/Installing.html -Josh - 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
hunting down duplicate entries
We recently moved our hardware inventory database off of access (yay!) over to mysql. During it's days as an access database it aquired a numbered of duplicate entries. In every case (or at least the ones I'm working on) the serial numbers will be the same but likely all other info will be slightly different. One of the records will be basically correct and current, the other faulty. I want to be able to find every case in the database where more than one record shares the same serial number (which is not at present a key feild, but will be once the dupes are removed) so we can look at the records and determine which ones are valid and which ones need to go. Is there a way to this? thanks in advance - Josh "Listen: We are here on Earth to fart around. Don't let anybody tell you any different!" - Kurt Vonnegut Josh Burroughs [EMAIL PROTECTED] - 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
INSERT question...
Hi-o! I was wondering if it's possible when inserting a value into a table
that has an auto_increment field to have MySQL return the value of the
auto_increment field right after doing the insert, w/out having to run a
seperate query?
For example if I had a table with two collums, ID and name. Where ID is an
int field with auto_increment set, and is the primary key. and name is
just a varchar. and did this:
INSERT INTO some_table (name) VALUES("bob");
I'd like for the query to return the value for ID that was just assigned.
Is there a way to do this all in one SQL statement?
Thanks in advance!
"Listen: We are here on Earth to fart around. Don't let anybody tell you
any different!" - Kurt Vonnegut
Josh Burroughs
[EMAIL PROTECTED]
-
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
