voodoochicken Posted March 16, 2008 Share Posted March 16, 2008 hi, i am trying to make the simplest backup with 'select into':sentence 1DELETE FROM BCKUP_VINCULADOS(seems to work, or at least does not throw error)sentence 2SELECT * INTO BCKUP_VINCULADOS FROM TABLA_VINCULADOSgives error:Undeclared variable: BCKUP_VINCULADOStable bckup_vinculados already exists (when i try to re-create it it tells me it cant because it already exists, and it does not throw error when trying to delete its content), also, it gives error about undeclared variable, not table. this is the simplest select into sentence that can be, what is wrong whit it?tnx Link to comment Share on other sites More sharing options...
voodoochicken Posted March 16, 2008 Author Share Posted March 16, 2008 replaced by:INSERT INTO BCKUP_VINCULADOS SELECT * FROM TABLA_VINCULADOSseems to work fine now. according to this, it seems that 'select into' is not a sql standard Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.