ChinaUnix.net
相关文章推荐:

create table like

DB2 中有 create table like 的用法,可以根据一张表生成另一张表结构一样的表,使用起来很方便INFROMIX中有无类似的用法呢?

by drwine - Informix - 2006-08-10 13:40:33 阅读(2114) 回复(3)

相关讨论

目的:测试create table a as select * from b 与create table a like b的区别 mysql下测试: 源表:ti 表结构如下 root:test> show create table ti\G *************************** 1. row *************************** table: ti create table: create table `ti` ( `id` int(11) DEFAULT NULL, `amount` decimal(7,2) DEFAULT NULL, `m_photo_big` varchar(64) DEFAULT NULL, `tr_date` date DEFAULT NULL, ...

by la19850302 - MySQL - 2009-10-17 11:43:06 阅读(22659) 回复(6)

请问oracle 9i中有没有create table like这样的语法? 就是可不可以使用这样的语句 create table table_new like select * from table_old?谢谢各位老大了,急!!

by cdma313 - Oracle - 2008-11-24 07:49:23 阅读(3286) 回复(2)

create table products(

id int not null auto_increment,
title varchar(100) not null,
description text not null,
image_url varchar(200) not null,
price decimal(10,2) not null,
primary key(id)
);

by I_am_tbag - MySQL - 2011-12-23 03:17:48 阅读(772) 回复(0)

use DW_Part go --有三个存储过程,依次执行为 --SP1 Sp_Promotion_activity_fact_tmp_Groupby --SP2 SP_Promotion_activity_fact_Insert_missing_data_for_YTD --SP3 SP_Promotion_activity_fact_update -- 共享表 tmpForYtd if exists (select * from dbo.sysobjects where id = object_id(N\'tmpForYtd\') and xtype=\'U\') drop table dbo.tmpForYtd go Select \'1000000000000000000000000000\' as...

by liyihongcug - SQL server - 2007-07-20 20:21:04 阅读(2858) 回复(0)

create table lb_tj as select number,sum(cost) cost from rec_213_200705 where number=888888' group by number 这个语句在从ORACLE角度来看这样的语句是没问题的,不知INFORMIX的create table要怎么用才可以有上面的效果。

by gdmmlibo - Informix - 2007-06-15 21:51:52 阅读(3523) 回复(3)

Creating a Basic table Adding and Controlling Borders Adding a border to the table can help distinguish the data cells and make the table more readable. Use the BORDER attribute in the table element to set a one-pixel border for the table border="1"> Alberts $160,251 $245,600 $132,000 $537,851 Setting Spacing and Padding The CELLSPACING attribute adds space between cells, whereas the CELLPA...

by 紫冰 - Java文档中心 - 2006-04-19 10:43:09 阅读(732) 回复(0)

drop table t_theme; create table netbank.t_theme (id_theme serial not null , theme varchar(50), choice_num integer(4), choice1 varchar(50), choice2 varchar(50), choice3 varchar(50), choice4 varchar(50), choice5 varchar(50), choice6 varchar(50), standard_answer varchar(2), ); 如果要制定id_theme 为主键,,应该如何加? 多谢!

by yebinlei - Informix - 2005-09-05 13:06:15 阅读(1249) 回复(1)

我用下面的语句创建了一张表,create table db_test2 (country varchar(30),location varchar(30),address varchar(50),username varchar(30)) tablespace test storage(initial 100k next 50k maxextents 20); ,接着查看了 INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS 106496 1 2147483645 为什么和我上面的创建的不符合呢;max_extents怎么会...

by net_xiaobao - Oracle - 2005-07-04 08:41:09 阅读(1093) 回复(1)

create TEMPORARY table actors ( id DECIMAL(03), name VARCHAR(40), CONSTRAINT actor_id CHECK (id < 150) ) ; insert into actors(id, name) values(1, 'camera'); insert into actors(id, name) values(2, 'flash mem'); "TEMPORARY 此表只是为这次会话创建,并且在会话结束后自动删除。当临时表存在时,同名的永久表是不可见的。" 但我觉得在对话结束后并没有自动删除 为什么上面的语句不...

by wsswh - PostgreSQL - 2003-12-13 10:16:26 阅读(2107) 回复(0)

我要建立c表,是a 表和b表的组合, 下列语句不对, 请sqlserver 高手指教。。 create table c select a.* ,b.corcode ,b.stockshort from ccc a join stockcode b on a.stockcode=b.stockcode :)

by sherrywong - SQL server - 2002-06-03 14:12:49 阅读(3077) 回复(1)