|
I have a mysql shell but for security reasons I cannot run the mysqldump command.
I have a table that I made a while ago with a lot of columns, and I want to generate a new "create table" command to create that table on a different database.
Is there ...
Started by zak23 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
FYI, if your user has access to both databases on the same server, you can do this:
CREATE TABLE.
This should work:
SHOW CREATE TABLE tbl_name
You should have SELECT privileges for the table.
|
|
For each table in my MySQL database I have a mytablename.sql file which contains the CREATE TABLE statement for that table.
I want to add a test to check that noone has added/altered a column in the live database without updating this file - that it, ...
Started by therefromhere on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
SHOW CREATE TABLE works, or just SELECT * FROM x LIMIT 1 be to use the information_schema system....
(The -Bs suppresses some a list of columns per each table to check.
Pared and sorted SHOW output on a temp table made by your .sql file.
|
|
How to Set a existing column of MS SQL table as NOT NULL?
Started by Vinodtiru on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
ALTER TABLE tablename ALTER COLUMN columnname datatype NOT NULL
You will obviously have to make.
|
Ask your Facebook Friends
|
How do you add a column, with a default value, to an existing table in SQL Server 2000/2005?
Started by Mathias on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
ALTER TABLE Protocols ADD ProtocolTypeID int NOT NULL DEFAULT(1) GO
ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT....
ALTER TABLE ADD ColumnName Options
Here is a link that has all of the alter table syntax: http.
|
|
Hi All,
I have two existing tables, with different fields, except for Primary ID (a varchar, not an int). I want to create a third table which is essentially a merge of these two, such that for a given Primary Key I have all fields in one table.
What'...
Started by Richard on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If you go with the....
CREATE TABLE result AS (SELECT first.*, second.f1, second.f2, second.f3 FROM first INNER JOIN second ON first.id = second.id);
To get a view, do the same except replace "TABLE" with "VIEW".
Similar for a VIEW as well.
|
|
Using tsql, sqlserver 2005.
I would like insert records from table table2 into an existing table table1 as easily as I could enter it into a new table table1 using:
select facilabbr, unitname, sortnum into table1 from table2
Any ideas?
Started by Lill Lansey on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Assuming you just want to append and that the columns match up:
INSERT INTO Table1 SELECT facilabbr, unitname, sortnum FROM table2
If you want to replace and the columns still match:
Truncate Table1 INSERT INTO Table1 SELECT facilabbr, unitname, sortnum... .
|
|
I already have a table which consists of data. I need to alter table to add two new columns which are not null. How can i do that without loosing any existing data?
NOTE: The new columns are not null fields.
Started by sanjeev40084 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Alter ....
Alter table table_name add column_name datetime not null constraint DF_Default_Object_Name default (getdate())
or this one for a varchar field.
You just set a default value in the new columns and that will allow you to add them .
|
|
I have a table:
+ + + + + + + | Field | Type | Null | Key | Default | Extra | + + + + + + + | fooID | int(11) | NO | PRI | NULL | auto_increment | | fooDetails | varchar(200) | YES | | NULL | | | fooListingID | int(10) | YES | | NULL | | | fooStatus |...
Answer Snippets (Read the full thread at stackoverflow):
You can accomplish this fairly easily:
#first make all the existing ids odd UPDATE oldtable SET fooID=fooID*2-1; #now insert rows from the....
To make all the existing fooIDs odd, and then merge into that table some new, even fooIDs.
|
|
Is it possible to change the auto-increment offset on a pre-existing table with JavaDB?
I'm having a problem where inserting new records usually (but not always) fails with an error complaining about using an existing key (my auto-increment column). To...
Started by Outlaw Programmer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
TABLE tbl ALTER COLUMN col SET INCREMENT BY x
hi this is great article.
|
|
I have a SQL Express 2008 DB that has gone live. I'd like to create a new table in that database without deleting all the existing data in the live DB. I created an entity class for the new table and a separate data-context.
What is the best way for me...
Started by Redshirt on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
?
Why you add unmapped to Entity which shipped with Visual Studio 2010 there is easy way to create Database table from Model.
Why not just execute the SQL statement, like create table [mytable] ...
|
