alter-table
Create an index on a huge MySQL production table without table locking
I need to create an index开发者_如何学Go on a ~5M rows MySQL table. It is a production table, and I fear a complete block of everything if I run a CREATE INDEX statement...[详细]
2023-01-26 12:33 分类:问答Alter a live table to make a key non-unique
I saw some other questions related to this, but they were not MySQL. The database is a live database, so I don\'t want to delete and recreate the table. I s开发者_开发问答imply want to make a column[详细]
2023-01-24 02:26 分类:问答Error renaming a column in MySQL
How do I rename a column in table xyz? The columns are: Manufacurerid, name, status, AI, 开发者_开发问答PK, int[详细]
2023-01-20 21:13 分类:问答DB2 REORG TABLE from client side with Migrator.NET
I\'m using Migrator.NET with a DB2 database and my current migration executes an ALTER TABLE statement, which causes the table to go into the \"reorg pending state\". This state requires the reorganis[详细]
2023-01-20 20:10 分类:问答MySQL dropping all indexes from table
I have a MySQL database that runs for some time now with many changes on it. Lately I looked over it and I noticed that in some cases I have doubled the index on the same field. Some Indexes开发者_Pyt[详细]
2023-01-17 10:49 分类:问答Can I create a named default constraint in an add column statement in SQL Server?
In SQL Server, I have a new column on a table: ALTER TABLE t_tableName ADD newColumn NOT NULL This fails because I specify NOT NULL without specifying a default constraint. The table should not ha[详细]
2023-01-16 23:35 分类:问答Why can't SQL Server alter a view in a stored procedure?
I\'m using MS SQL Server, and I\'d like to alter a view from within a stored procedure, by executing something like \"alter view VIEWNAME as ([some sql])\".[详细]
2023-01-16 18:37 分类:问答ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
We\'ve recently had the need to add columns to a few of our existing SQLite database tables.This can be done with ALTER TABLE ADD COLUMN.Of course, if the table has already been altered, we want to le[详细]
2023-01-13 14:30 分类:问答MySQL rename column from within PHP
I need to rename columns in my MySQL table using PHP. This is made difficult because the syntax is ALTER TABLE [table] CHANGE COLUMN [oldname] [newname] [definition].The definition is a required para[详细]
2023-01-12 16:37 分类:问答SQL Server, How to DROP COLUMN if condition is satisfied?
I have been trawling google for answers to this but no luck. Any help would be great! I have a SQL table: tblFeedback. It stores answer开发者_运维知识库s to feedback questions. The Questions are held[详细]
2023-01-12 09:29 分类:问答