All lists off topic... Job Networking Request
To any Moderators: This is the only time I will send this message. Dear List Members, I am seeking a co-op/paid internship in a Computer Science related field. If you or someone you know, directly or indirectly, works for a company that deals with Computer Science, i.e. Computer Programming, please e-mail me privately to get a copy of my resume. Thank you, Nathanial C. Jones 5th year Computer Science Undergraduate Student at Rochester Institute of Technology, Rochester, NY [EMAIL PROTECTED] OR [EMAIL PROTECTED] OR [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Retrieving the system type that MySQL is running on.
I'm relatively new to MySQL, and I'm writing a PHP script that doesn't know what kind of system the MySQL database is on. The script and database don't have to be on the same system, so I need a way to determine what kind of system (*nix, Win, etc.) MySQL is running on. Is there a "fool proof" query to determine this? If so, what is it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Retrieving the system type that MySQL is running on.
The user is to define the database and table names, but may not know the system that MySQL is on, and try to request a table or database expecting case sensitivity and wind up with case insensitivity. I want to check the existence of the database or table, before trying to create it, rather than try to create it and find out it can't be created because it already exists. An alternative (which is actually better) would be a query to determine case sensitivity, but I can't figure out how to get that info from MySQL either. At 02:43 AM 11/11/2003, Matt W wrote: Hi Nathan, I don't think there's a way if MySQL is on a separate machine, as I'm only aware of checking in PHP. Hmm, maybe you could create a dummy table and see if it's case-sensitive or not? He he. Just curious, why would you need to know what OS MySQL is on? Matt - Original Message - From: "Nathan Jones" Sent: Monday, November 10, 2003 8:02 PM Subject: Retrieving the system type that MySQL is running on. > I'm relatively new to MySQL, and I'm writing a PHP script that doesn't know > what kind of system the MySQL database is on. The script and database > don't have to be on the same system, so I need a way to determine what kind > of system (*nix, Win, etc.) MySQL is running on. Is there a "fool proof" > query to determine this? If so, what is it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Merging duplicate rows
How do you merge duplicate rows? All rows involved contain identical data in each column. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [Fwd: Re: Last inserted ID]
On Wed, 2004-05-05 at 22:49, Paul DuBois wrote: > At 22:39 -0400 5/5/04, Nathan Jones wrote: > > > Hi there, > >> > >> I seem to be having a problem retrieving the last inserted ID for a > >> table. > >> > >> The query I am using is as follows: > >> > > > >It's far easier than anyone else has mentioned, as of my writing. Just > >use the PHP function 'mysql_insert_id()' after your insert query. This > >function has been in the PHP MySQL module since at least sometime during > >the version 3 cycle. Here's the address to the online PHP documentation > >for the MySQL module: http://www.php.net/manual/en/ref.mysql.php > > This is true, but it's possible that the underlying cause of the problem > that results in the query not working on PHP may also affect whether or > not mysql_insert_id() returns the desired value. For example, if the > SELECT LAST_INSERT_ID() query is not being issued on the same connection > as the query that generates the ID, calling mysql_insert_id() might not > work, either. mysql_insert_id() takes as an optional parameter, like all MySQL functions in PHP, referencing the connection to check. To garauntee that you are using the correct connection, always pass the resource for the connection to the mysql_* functions. mysql_insert_id() must be called as the next query on the connection of the INSERT query, otherwise you get back 0. By using this function, you simply reduce the chances for error in the id retrieval. I know that by default many of us don't RTFM, but in the case of any language, I've found that reading the manuals to be very helpful. In fact, I keep copies of all the manuals locally in order to save the time required to retrieve from the web. > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Fwd: Re: Last inserted ID]
> Hi there, > > I seem to be having a problem retrieving the last inserted ID for a > table. > > The query I am using is as follows: > It's far easier than anyone else has mentioned, as of my writing. Just use the PHP function 'mysql_insert_id()' after your insert query. This function has been in the PHP MySQL module since at least sometime during the version 3 cycle. Here's the address to the online PHP documentation for the MySQL module: http://www.php.net/manual/en/ref.mysql.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]