zmena typu polozky
Honza Pazdziora
adelton na informatics.muni.cz
Středa Červen 30 11:01:49 CEST 2004
On Wed, Jun 30, 2004 at 09:40:21AM +0200, Ildiko Takacsova wrote:
> Chcem zmenit polozku psc z varchar(5) na varchar(6)
>
> begin;
> ALTER TABLE tabulka ADD COLUMN psc2 varchar(6);
> UPDATE tabulka SET psc2=CAST(psc AS varchar(6));
> ALTER TABLE tabulka DROM COLUMN psc;
> ALTER TABLE tabulka RENAME COLUMN psc2 TO psc;
> commit;
>
> Kde mam chybu?
Presne tam, kde Vam server rika, ze ji mate:
ERROR: syntax error at or near "DROM" at character 21
--
------------------------------------------------------------------------
Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be simple.
Další informace o konferenci Test