Creation and modification of database table

xiaoxiao2021-03-06  57

## Creating create Table Tmp Asselectr * from TMP

## Add Column ALTER TABLE TMPADD (TMP1 DATE, TMP2 INT);

## Modified column ALTER TABLE TMPMODIFY TMP1 INT

## Delete Column ALTER TABLE TMPDROP COLUMN TMP2

## Modify Table Name Rename Table TMP to Temp

转载请注明原文地址:https://www.9cbs.com/read-112861.html

New Post(0)