|
Hello,
we are trying to minimize (maintenance) downtimes of our mysql based application.
It seems that InnoDB hotbackup will give us the possibility to do regular backups without stopping the server; Master/Slave replication will give us failover capabilities...
Started by filibuster on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This doesn't work for all ALTER TABLE commands, but it can handle the majority of themThe best ....
With ALTER TABLE on the slave, let the slave catchup after it is done, swap roles, and then ALTER on the former master.
|
|
I'm working with an old Access database (yes, it's very ugly and I hate it). I need to modify some of the columns from a VB app that I'm creating. I have most the modifications setup correctly, but I'm fighting with the fact that modifying a column to...
Started by Ryan Smith on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Something like:
ALTER TABLE [Applicant Table] ADD CONSTRAINT As TableDef Dim fld As DAO.Field Set db = CurrentDb Set tbl = db.TableDefs![Applicant Table] Set fld.
Is to use a CHECK constraint e.g.
|
|
I want to programmatically create a new column in an Access table. I've tried many permutations of "ALTER TABLE MyTable Add MyField DECIMAL (9,4) NULL;" and gotten "Syntax Error in Field Definition". I can easily create a number field that goes to a Double...
Started by CindyH on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
CurrentProject.Connection.Execute "ALTER TABLE myTbl ADD COLUMN myColumn DECIMAL(9,4 this into the SQL window:
....
Try an ADO connection e.g.
The ALTER TABLE syntax is only supported in Jet 4.0/ACE while in ANSI-92 Query Mode.
|
Ask your Facebook Friends
|
I have a need to change the length of CHAR columns in tables in a PostgreSQL v7.4 database. This version did not support the ability to directly change the column type or size using the ALTER TABLE statement. So, directly altering a column from a CHAR...
Started by E Brown on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I would dump the table contents to a flat file with COPY, drop the table, recreate described requires making the table unusable for a period of time, how long depends on the data.
|
|
In a SQL server database, I have a table which contains a TEXT field which is set to allow NULLs. I need to change this to not allow NULLs. I can do this no problem via Enterprise Manager, but when I try to run the following script, alter table dbo.[EventLog...
Started by Tim C on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
TABLE dbo.TestTable GO EXECUTE sp_rename N'dbo.Tmp_TestTable', N'TestTable', 'OBJECT' GO ALTER TABLE UPDATE tmp1 SET col2 = '' WHERE col2 IS NULL ALTER TABLE tmp1 ALTER COLUMN col2 TEXT NOT NULL SELECT of my ....
|
|
SQL Server 2005: 240 million row table. Column requirements changing from NOT NULL to NULL.
Generally bad practice (and often impossible) to use ALTER statements when dealing with tables this big, however, trying to avoid rebuilding the table, if possible...
Answer Snippets (Read the full thread at stackoverflow):
A change from NOT NULL to NULL is fine because existing data .
Is getting the lock for the entire table.
|
|
I am not getting option like 'ALTER To' when am right clicking on TVP
Started by VinnaKanna on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Under new name alter dependencies to use (1) drop old TVP recreate (1) under original name alter.
|
|
We are currently thinking about different ways to implement custom fields for our web application. Users should be able to define custom fields for certain entities and fill in/view this data (and possibly query the data later on).
I understand that there...
Started by Dennis G. on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
With this approach with a name/value type table, you'd be storing multiple data types as one type (nvarchar probably) - unless you complete that name/value table....
I see nothing wrong with adding new custom fields to the database table.
|
|
Is there a simple way to modify a table in recent sqlite versions so that it matches a predefined schema?
Schema:
war_id INTEGER NOT NULL, clanname VARCHAR(64), clanhomepage VARCHAR(128), date DATETIME, server VARCHAR(64), warmode_id INTEGER, squad_id...
Answer Snippets (Read the full thread at stackoverflow):
The only restriction you'll face is that the column will be at the end of the table, but for normal use column order shouldn't ....
Id,squad_id,notes FROM War; DROP TABLE War; ALTER TABLE War_TMP RENAME TO War; COMMIT;
here .
|
|
What I need is a collection which allows multiple keys to access a single object.
I need to apply frequent alterations to this object.
It also must be efficient for 500k+ entries.
Started by Duncan on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Any implementation of java.util.Map<K,V> will do this - there is no restriction on how many times a particular value can be added under separate keys:
Map<String,Integer> m = new HashMap<String, Integer>(); m.put("Hello", 5); m.put("... .
|
