possible to add a record number to a query?

I would like to have a column returned in a query that tells you which record I'm looking at? Sort of like an auto_increment? IOW, the query results would look like: record first last 1 johndoe 2 joe blow 3 carol fisher The table only has first and last, but

RE: SET query question (was ENUM query question)

ry question > > > At 12:42 -0500 6/12/02, Jeff Field wrote: > >I have a quick question regarding queries that involve values in ENUM > >columns. Here's the scenario: > > > >I have an ENUM column (category) that can have the values ('Gambling', > >

ENUM query question

I have a quick question regarding queries that involve values in ENUM columns. Here's the scenario: I have an ENUM column (category) that can have the values ('Gambling', 'Geographic', 'Medical', 'Sports'). Most of the records have only one of the category descriptions but some are categorized

RE: change default root user name?

reate a user and give > all the priviliges to that user in the user table of mysql database, and > then takeaway the privileges from the user root. Would that work for you? > > Gurhan > > -Original Message- > From: Jeff Field [mailto:[EMAIL PROTECTED]] > Sent: Wednesd

change default root user name?

I've had a question that I haven't really seen addressed anywhere... Is it okay to change the default "root" user name to a different name? Any issues involved by doing so? The reason I ask is that it seems to me that, because everyone knows that MySQL installs with the root user, one simple ex

replication questions

I think I understand how to set up replication but have a couple unanswered questions. I'm hoping the list can help. I have two servers with MySQL. Each server currently has completely different databases, except for the standard mysql permissions database. Server 1 is in production and server 2