Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread sucker
- Original Message - From: "Milan Reznicek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 1:15 PM Subject: ERROR 1036: Table 'xxx' is read-only > I have a problem with updating MySQL database on linux with mysql > 3.23.24-beta-log. I have prepared a database on

Re: sub-selects

2002-05-03 Thread sucker
"Alex" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:... > i have to use a statement like: > SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1 > AND CODICE<>ALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE > (CODICE_ARCHIVIO=342)) > > but mysql doesn't support inner select. > > What