Alter Table « Table Index « SQL / MySQL

Home
SQL / MySQL
1.Aggregate Functions
2.Backup Load
3.Command MySQL
4.Cursor
5.Data Type
6.Database
7.Date Time
8.Engine
9.Event
10.Flow Control
11.FullText Search
12.Function
13.Geometric
14.I18N
15.Insert Delete Update
16.Join
17.Key
18.Math
19.Procedure Function
20.Regular Expression
21.Select Clause
22.String
23.Table Index
24.Transaction
25.Trigger
26.User Permission
27.View
28.Where Clause
29.XML
SQL / MySQL » Table Index » Alter Table 




1.Altering Database Tables: Add a Column
2.Altering Database Tables: Add More Columns
3.Altering Database Tables: Drop a Column
4.Altering Database Tables: Drop Unique Constraint and Add Primary Key
5.Alter table: add unique
6.Alter table: drop primary and foreign key
7.Alter table: add primary key, foreign key and add column
8.Altering and Dropping Tables
9.Alter table to change the auto_increment setting and comments














10.Alter table to change the order
11.Alter table to add column
12.Alter table to change column sequence
13.Alter table to add columns
14.Alter table to drop primary key
15.Alter table to drop foreign key
16.Alter table to add fulltext search
17.Changing the Table Design (ALTER TABLE)
18.Use ALTER TABLE to change the column type
19.The Effect of ALTER TABLE on Null and Default Value Attributes
20.Create the table and then set the initial sequence value with ALTER TABLE
21.Alter table to set the primary key start
22.ALTER TABLE statement modifies the table accordingly
23.Alter table to add primary key, add new column, change column, drop column
24.Using ALTER TABLE command to add the names_num column to the cust_names table
25.Two ALTER TABLE statements can be combined
26.Alter table to add foreign key
27.Syntax for Altering a Column
28.Syntax for altering table and delete a Column
29.Storing Altered Character Strings
30.To drop a default value, use ALTER col_name DROP DEFAULT:
31.ALTER column to BINARY
32.Use the asterisk to try matching against the name ian or the alternative spelling, iain.
33.Specifying Multiple Alterations
34.Alter table to add an index
35.Alter table to add unique index
36.Alter table to Delete an Index
37.Alter table to add index
38.To drop an index with ALTER TABLE
39.Reduce the number of significant characters per index in the index to the first 16 characters
40.Add IGNORE to the statement, then use SELECT to have a look at the table contents to see how the duplicates ha
41.Change j from INT to BIGINT
42.MODIFY statement should specify the null and default value attributes explicitly
43.Redefine i to be NOT NULL, then try again
44.Change column definition
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.