mysql / alter

the MySQL command-line tool

copy
412

ALTER TABLE tbl AUTO_INCREMENT = 100;

copy
260

select * from siteExampleCmds where parentID=1 and example like '%alter%'

copy
245

ALTER TABLE CountryLanguage ENGINE=NDBCLUSTER;Set the Engine type to NDBCLUSTER on table CountryLanguage

copy
225

ALTER TABLE tt MODIFY ActualPC VARCHAR(15);

copy
209

ALTER TABLE orig_name RENAME new_name;

copy
197

ALTER TABLE Country ENGINE=NDBCLUSTER;

copy
166

ALTER TABLE tt MODIFY AssignedPC VARCHAR(15), MODIFY ClientID VARCHAR(15);

copy
194

ALTER TABLE City ENGINE=NDBCLUSTER;

copy
170

ALTER VIEW v AS SELECT * FROM t;

copy
182

ALTER TABLE t1 MODIFY b CHAR;Modify the table t1 set the column b to type CHAR

copy
159

ALTER TABLE myTable AUTO_INCREMENT = 4;Set the auto increment to 4 on table my table

copy
131

ALTER TABLE new_table RENAME old_table;