Znaci, imam tabele phpbb_ i hocu da ih pobrisem. Ne pitajte zasto. Imam samo mysql manual, ali tamo nema nista o tome (osim drop table koje je, koliko sam skapirao samo za jednu tabelu)?
Kako brisati vise tabela odjednom?
Zaključano
Zakačeno
Code:
DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]
DROP TABLE removes one or more tables.
You must have the DROP privilege for each table.
All table data and the table definition are removed,
so be careful with this statement!
DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]
DROP TABLE removes one or more tables.
You must have the DROP privilege for each table.
All table data and the table definition are removed,
so be careful with this statement!
U manualu lijepo pise :)
Dakle, trebas kucati:
Code:
DROP TABLE tabela1, tabela2, tabela3;
DROP TABLE tabela1, tabela2, tabela3;
Potpis
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA