All lists off topic... Job Networking Request

2004-07-01 Thread Nathan Jones
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.

2003-11-10 Thread Nathan Jones
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.

2003-11-11 Thread Nathan Jones
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

2003-11-16 Thread Nathan Jones
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]

2004-05-08 Thread Nathan Jones
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]

2004-05-05 Thread Nathan Jones
> 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]