mysql> insert into table1 select distinct field1 , MIN(field2) from table2
where field2 >="2001-12-01 00:00:00" group by field2 ;
ERROR 1114: The table 'SQLb73d_0' is full
mysql>
please help to fix this error
-
Before posti
mysql> insert into table1 select distinct field1 , MIN(field2) from table2
where field2 >="2001-12-01 00:00:00" group by field2 ;
ERROR 1114: The table 'SQLb73d_0' is full
mysql>
please help to fix this error
Name : Mohamed Abd El-Samei Mohamed
Title : System
; at line 1
mysql>
Name : Mohamed Abd El-Samei Mohamed
Title : System Administrator
Comp. : Soficom Communications S.A.E
Tele. : 737-1952/3
Fax : 7547415
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://w
1-30 00:00:0' at line 1
mysql>
- Original Message -
From: "Kevin Smith" <[EMAIL PROTECTED]>
To: "Mohamed Abd El-Samei Mohamed" <[EMAIL PROTECTED]>
Sent: Thursday, December 13, 2001 2:25 PM
Subject: Re: Not In
> Post the SQL statement so we can have a look at it
Sorry .. nut i need to select from table and the selection related to date
i want to use NOT IN or NOT EXISTS .. but i got error in syn. when i do ..
please help
-
Before posting, please check:
http://www.mysql.com/manual.
Dear all can anyone help me to use NOT IN
or NOT EXISTS command in mysql ..
Thsnks
Name : Mohamed Abd El-Samei Mohamed
Title : System Administrator
Comp. : Soficom Communications S.A.E
Tele. : 737-1952/3
Fax : 7547415
E-mail: [EMAIL PROTECTED
Thanks for help .,
I tried it but also got the same error
any other advice
"Gerald L. Clark" wrote:
>
> Run isamchk on your tables.
>
> mohamed Abd El-Samei Mohamed wrote:
> >
> > Dear all i need help
> > i have mysql-3.22.26a over unix solairs
Dear all i need help
i have mysql-3.22.26a over unix solairs 7
when i try to apply query from the console to retrieve some information
i got that error
ERROR 1030: Got error 127 from table handler
please help ..
Thanks
Sorry for bad english!
--
Name : Mohamed Abd El-Samei Mohamed
Company
