Ændring og slippe tabeller i Mysql

o, navn CHAR (80)); Du skulle nu have en ny tabel kaldet Indkøb. - Nu vil du slette den tabel, du lige har oprettet. Skrive følgende og udføre: DROP TABLE Indkøb; Den nye tabel køb skulle have været slettet. Lad os nu droppe forbindelsen, stopper databasen og stoppe serveren. Skriv følgende, og tryk på Enter: QUITComplete Syntaks til Alter en tabel Den komplette syntaks SQL erklæring for at ændre en tabel er angivet nedenfor; blik gennem det og læse forklaringen nedenunder: ALTER TABLE Syntaks ALTER [ONLINE | OFFLINE] [IGNORERER] TABEL tbl_name alter_specification [, alter_specification] .

.. alter_specification: table_options | ADD [KOLONNE] col_name column_definition [FIRST | EFTER col_name] | ADD [KOLONNE] (col_name column_definition, ...) | ADD {INDEX | KEY} [index_name] [index_type] (index_col_name, ...) [index_option] ... | ADD [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name, ...) [index_option] ... | ADD [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (index_col_name, ...) [index_option] ... | ADD FULLTEXT [INDEX | KEY] [index_name] (index_col_name, ...) [index_option] ... | ADD SPATIAL [INDEX | KEY] [index_name] (index_col_name, ...

) [index_option] ... | ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name, ...) reference_definition | ALTER [KOLONNE] col_name {SET DEFAULT bogstavelig | DROP DEFAULT} | CHANGE [KOLONNE] old_col_name new_col_name column_definition [FIRST | EFTER col_name] | ÆNDRE [KOLONNE] col_name column_definition [FIRST | EFTER col_name] | DROP [KOLONNE] col_name | DROP PRIMARY KEY | DROP {INDEX | KEY} index_name | DROP FOREIGN KEY fk_symbol | DEAKTIVER nøgler | ENABLE nøgler | OMDØB [TO] new_tbl_name | ORDER BY col_name [, col_name] ...

| KONVERTER TIL KARAKTER SET charset_name [COLLATE collation_name] | [DEFAULT] KARAKTER SET [=] charset_name [Sætvis udskrivning [=] collation_name] | DISCARD TABLESPACE | IMPORT TABLESPACE | partition_options | ADD partition (partition_definition) | DROP PARTITION partition_names | Coalesce PARTITION nummer | REORGANISERE PARTITION [partition_names INTO (partition_definitions)] | ANALYSÉR PARTITION {partition_names | ALLE} | CHECK PARTITION {partition_names | ALLE} | OPTIMER PARTITION {partition_names | ALLE} | REBUILD PARTITION {partition_names | ALLE} | REPARATION PARTITION {partition_names | ALLE} | Partition ved partitioning_expression | FJERN PARTITIONING index_col_name: col_name [(længde)] [ASC | DESC] index_type: BRUG {BTREE | HASH} index_opt