-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Friday, May 11, 2007 9:25 AM
To: Mogens Melander
Cc: mysql@lists.mysql.com
Subject: Re: finding next and prev record in mysql
Mogens Melander wrote:
On Fri, May 11, 2007 07:15, Richard Kurth wrote:
How would I
limit 2,1 will give you the second record. It's the same query every
time, you're just incrementing the first number of the limit clause.
- Original Message -
From: Richard Kurth [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, May 11, 2007 1:15 AM
Subject: finding next and prev record
How would I find the next id and the prev id in sql statement like the one
below. The id number is not going to be in order so I can't do a or
limit 1 on the search
SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND
members_id= '8' ORDER BY lastname
I have two tables I just what the data from the 1 table that is not in the
2 table So in this example I what row formelements_id 22 and 23. I have
tried different sql statements one is below
SELECT customformelements.formelements_id
I am looking for instructions on how to configure mysql on a Linux server
with an already running version. I would need it run on a different
port and all the files to be installed in one location. I don't what
it to interfere with the standard install of mysql. Also I would like
it to install
I am trying to reinstall mysql on a cobalt server I removed the
first version but when I go to install the new version I get this
message below saying it conflicts with another version could you tell
me how I can correct this. I have looked through the entire directory
structure and can not
I keep getting this message in the mysql .err file I have no id as to
what to do or even look at.
010519 11:57:54 mysqld started
/usr/sbin/mysqld: ready for connections
010520 4:02:33 /usr/sbin/mysqld: Binlog closed, cannot RESET MASTER
Status information:
Current locks:
key_cache status:
I am looking for different views about this
I have a few question about Granting privileges to a user
1. Do you have to give them GRANT SELECT,INSERT,UPDATE,
DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER for them to use
their database?
2. Is it best to give them the least amount of privileges?
and
go into mysql it shows
that all of the tables and data are their including the mysql data.
This seems realy strange to me. Could you tell me what I need to do
to correct this problem or at lest looking in the right direction.
Thank you
Richard Kurth
Hello B.,
Thursday, May 03, 2001, 11:42:39 AM, you wrote:
I set up a couple of databases last night in mysql and every thing is
working just fine. Today when I try to access the data it is not there
Using phpMyAdmin when I look at the databases that are completely empty
of tables and data that
mysql running on cobalt raq4
have look through the archives and looked at the manual
I can not access the databases from the web browser I get empty
databases
When in at telnet erased all the databases including mysql
ran mysql_install_db
logged back in with the web browser and the tables were
I have a major problem could somebody take a seeress look at this
mysql running on cobalt raq4
I have looked through the archives and looked at the manual
can not find anything to explain this
nothing in the mysql log file
I can not access the databases from the web browser I get empty
and go
into mysql it shows
that all of the tables and data are their including the mysql data.
This seems realy strange to me. Could you tell me what I need to do
to correct this problem or at lest looking in the right direction.
Thank you
Richard Kurth
13 matches
Mail list logo