not the exact equivalent but if you are looking at a query like:
select * from mytable where rownum=8;
you can do :
select * from mytable limit 7,1
select query ..
[LIMIT [offset,] rows]
http://www.mysql.com/doc/S/E/SELECT.html
- Original Message -
From: "Ramaraju.R.V" <[EMAIL PROTECTE
I want to thank everyone for their contributions on this thread,and
especially Erik for posting the question.
I'm in the middle of the problem, and was about to write excessive code
using Erik's suggestion No.1.
Thank you, thank you to all.
- Original Message -
From: "Erik Price" <[EMAIL
not the exact equivalent but if you are looking at a query like:
select * from mytable where rownum=8;
you can do :
select * from mytable limit 7,1
select query ..
[LIMIT [offset,] rows]
http://www.mysql.com/doc/S/E/SELECT.html
- Original Message -
From: "Ramaraju.R.V" <[EMAIL PROTECTE
I want to thank everyone for their contributions on this thread,and
especially Erik for posting the question.
I'm in the middle of the problem, and was about to write excessive code
using Erik's suggestion No.1.
Thank you, thank you to all.
- Original Message -
From: "Erik Price" <[EMAIL
I've encountered this problem several times on complicated queries that
return no rows.
mysql_errno:1015
mysql_error:Can't lock file (errno: -30989)
After this error, I can't run queries to any associated tables, and the only
I know how to get around it is to restart mysqld.
Does anyone know why
Check out this page.
You still have to create the table in mysql first, then you can run the LOAD
DATA INFILE command .
http://www.mysql.com/doc/L/O/LOAD_DATA.html
- Original Message -
From: "Todd Williamsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2
there's a concat(string1, string2) function
and also a concat_ws(',', string1, string2) newstring
--concat with separator comma alias "newstring"
http://www.mysql.com/doc/S/t/String_functions.html
Refer to the above page for more useful string functions
- Original Message -
From: "soni
Hello,
I'm experincing a problem with my database locking up on some queries.
Any explanation or solutions anyone can provide will be much appreicated.
-
##Scenario: 3 tables: company, co_type_assoc, co_type
##with d
Anvar had some very good explanations about the time it takes to run the
queries.
##Here are some work arounds:
##If you need to have these columns (mot, date, numresponse) in the group by
clause,
##try putting an index on each of them to speed it up.
mysql>>alter table searchhardwarefr3
I'm having the same need.
It looks like the following is intended for MyISAM tables only:
http://www.mysql.com/doc/U/s/Using_mysqlcheck.html
Has anyone else had any other luck ?
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Januar
to go about it.
- Original Message -----
From: "Kalok Lo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Egor Egorov" <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 11:51 AM
Subject: Re: how to repair bdb tables?
> I'm having the same need.
> It loo
Has anyone had the following problem or anything related to this ?
I've had some problems where my data gets "deleted" after I add or drop a
column.
The scenario is as follows.
1)mysql daemon is running.
2)make a structure change to table/add or drop column
3)stop and restart mysql daemon
4)look
I've had many problems with BDB table crashes.
Up until now, I haven't really cared, running safe_mysqld, the database just
restarts, and things proceed as normal.
But recently I've had some strange behaviour, where table data is deleted
after an "alter table" statement.
Upon looking through the
you could possibly do this.
well first, is there a fix size for the extension ? i.e 3 digit or 4
digits.
if so, you could easily fill a table with a script with all the ranges of
extensions, say that table is called static_extension
then you can do the "not in" join
select * from static_extens
What kind of code ?
I typically send each of those in as separate queries.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 8:36 AM
Subject: Problem with query
> Hi,
>
> I Have a problem with transaction controls... runing the query
15 matches
Mail list logo
