I need help creating a select that returns 4 records that have
contiguous addresses that start on a bit boundary.
If 4 do not exist, I need a return of zero records.
I would like to do this in one statement and I do not have ownership of
this mysql server, so fancy views, temporary tables,
I should have said consecutive addresses, rather than contiguous.
I care about a set of consecutive addresses, and there is no guarantee
of record order.
On 12/17/2015 07:35 AM, John Stile wrote:
> I need help creating a select that returns 4 records that have
> contiguous addresses that
LIMIT 0,1
) AND (@b+3) limit 0,4;
On 12/17/2015 08:14 AM, John Stile wrote:
> I should have said consecutive addresses, rather than contiguous.
> I care about a set of consecutive addresses, and there is no guarantee
> of record order.
>
> On 12/17/2015 07:35 AM, John Stile wro
I think I really misunderstood the directions for alter table, an I'm
not sure how to fix this. I was trying to allow certain columns to be
null in an existing table.
I used the following syntax:
ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL;
Now 'describe users;' shows extra columns
mysqladmin -u root -p shutdown
The next time I start mysqld_safe, it does not appear as a connected API.
--
._.
| \0/John Stile |
| UniX Administration |
| / \ 510-305-3800 |
| [EMAIL PROTECTED] |
.-.
signature.asc
Description
: Can't create table './database1/#sql-4627_3a.frm' (errno: 4009)
--
._.
| \0/John Stile |
| UniX Administration |
| / \ 510-305-3800 |
| [EMAIL PROTECTED] |
.-.
signature.asc
Description: This is a digitally signed message part
On Tue, 2004-10-19 at 21:42, John Stile wrote:
I have Mysql Cluster (version 4.1.16-gama) running, and now I need to
Sorry, I meant version mysql-max-4.1.6-gamma-pc-linux-i686.
signature.asc
Description: This is a digitally signed message part