New answers tagged ddl
These MSDN links has an exclusive list of all possible DROP/CREATE/ALTER statements, There are plenty of options possible. What really are you looking for? CREATE ALTER DROP
I think that Percona's pt-online-schema-change might be a better solution for you as it can do an ALTER with very little downtime. It does, however, require adding a TRIGGER to the table. Runnig DDL on your table will lead you into rebuilding your table, mysql is a row based engine so you will suffer the index rebuild this can be quite expensive depending ...
re 1: that's the default value you define when you create the table: create table foo ( id integer default 42, last_modified timestamp default now() ) Details are in the manual: http://www.postgresql.org/docs/current/static/ddl-default.html http://www.postgresql.org/docs/current/static/sql-createtable.html re 2: an index can be defined on ...
Top 50 recent answers are included