Use dB;
-- List all tables in the current database
Show tables;
Show tables like's % ';
Create Table Name
(
Column name type modification constraints,
Sid int (3) unsigned zerofill primary key auto_increment
Sgender Enum ('male', 'female ',
The source of this article: http://www.cnblogs.com/wy123/p/6704619.htmlIssue backgroundIn a write SQL Server stored procedure, if a temporary table is defined in the stored procedure,Some people are used to explicitly delete a temporary table
Original post address: http://hi.baidu.com/liyanlin84/blog/item/eb306616cdb51e1c972b4389.html
Delete all data in the table, and you want to automatically increase the column from 1! Use truncate table tblname
Truncate is a SQL statement used
Management of 1.Oracle Tables
Naming conventions for table and column names:
Must start with a letter;
Length cannot exceed 30 characters;
Cannot use Oracle's reserved words;
Use only the following characters: A-Z, A-Z, 0-9,
Document directory
MySQL table replication
MySQL table modification
Delete a MySQL table
I didn't want to write this section, because it was very troublesome. There were many examples, which were representative, and I knew everyone was bored.
"Go" SQL create TABLE, delete table Add field Delete field actionHere are some common SQL Server and Access operations database structures that you would like to help.New table:CREATE table [table name]([AutoNumber field] int IDENTITY (PRIMARY KEY),[
Mysql 3-view table structure, modify and delete data tables bitsCN. comMysql 3-view table structure, modify and delete data tables view table structure
You can use DESCRIBE or show create table statements to view the TABLE structure. 1. view the
ALTER table: Add, modify, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column:
(1) The DELETE statement performs the deletion by deleting one row from the table at a time and saving the row's delete operation as a transaction record in the log for the rollback operation. TRUNCATE table deletes all the data from the table at
I. Temporary tableThe temporary table is placed in the temporal table space without generating redo, only with undo. You can create indexes, views, and triggers in a temporary table, and you can also export and import the definition of a temporary
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.