Jens Porup wrote:
G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 > rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
table 'Attachments' at
just as:
$myquery = "select * from sometable";
$myresult = mysql_query($myquery, $mysql_link);
$rows = $mysql_fetch_array($myresult)
$count = 1;
while ($rows)
{
print(" $count$rows[0]$rows[1]...
$count++;
}
I would do the same thing in perl, C++, or Java.
Curtis
On Sun, 16 Feb 2003, Micha
Luc Foisy wrote:
I didn't say it had nothing to do with the data, I said it had nothing to do with the data in the database.
I'm making the assumption as a DBA that _all_ the data relevant is in
the database; so the comment I made was equivalent to the above.
As I said, sure I could make ext
On Fri, Feb 14, 2003 at 01:04:00PM -0500, Luc Foisy wrote:
> I didn't say it had nothing to do with the data, I said it had
> nothing to do with the data in the database. The data in the
> recordset returned from the database referenced by row is important.
[...]
> 1. There are a lot of function
>
> On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> > >That means no field exists or should exist in the
> database. I only want to
> > >generate at query time.
> > >I can't use an autoincrement field since that wont work
> very well with
> > >results that are returned out of
On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> >That means no field exists or should exist in the database. I only want to
> >generate at query time.
> >I can't use an autoincrement field since that wont work very well with
> >results that are returned out of order and maybe not
At 12:31 PM 2/13/03 , Luc Foisy wrote:
> > I still don't understand do you mean the "actual" row
> number or just a
> > display number.
> > > There is no relevant data or use to this number.
> > > It is the row number of the returned result set, purely
> > > for display.
That means no field exis
I thought of a new feature... XSLT's "position()"-like functionality
in the new releases of MySQL.
position(), in XSLT, returns position of the node in the document tree.
In MySQL it would return position of the record in the returned result set
(from SELECT query):
Example:
SELECT POSIT
On 13 Feb 2003, at 15:31, Luc Foisy wrote:
> Using variables is the best response to my question. I just dislike
> using them cause they are ugly to work with because of the session
> persistance and because I have to issue multiple queries to do the
> job.
Using variables seems to be the way to
> > I still don't understand do you mean the "actual" row
> number or just a
> > display number.
> > > There is no relevant data or use to this number.
> > > It is the row number of the returned result set, purely
> > > for display.
That means no field exists or should exist in the database. I
Auto-inc column would be the obvious answer, but that's and intrusive
answer.
Jerry
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: "Luc Foisy" <[EMAIL PROTECTED]>
Cc: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursda
or
regardless of the order the resultset appears.
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 1:48 PM
To: Luc Foisy
Subject: Re: Row numbers
Have to have one in the row and select that along with the
query, if your
going to use it f
; Von: Luc Foisy [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 13. Februar 2003 20:00
> An: MYSQL-List (E-mail)
> Betreff: RE: Row numbers
>
>
> There is no relevant data or use to this number.
> It is the row number of the returned result set, purely for display.
>
>
I still don't understand do you mean the "actual" row number or just a
display number.
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 6:59 PM
Subject
.
> -Original Message-
> From: Jerry [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 1:48 PM
> To: Luc Foisy
> Subject: Re: Row numbers
>
>
> Have to have one in the row and select that along with the
> query, if your
> going to use it for some
: Is there a way to get a row number returned with any select query?
Row number is not available for some queries (ex.DELETE FROM table_name)
for efficiency. You can disable it with a dummy WHERE clause:
DELETE FROM table_name WHERE 1 > 0;
It will be slower, but you'll get the desire
16 matches
Mail list logo