create view

2008-12-24 02:43:33 116 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SDM660电源部分配置： SDM660电源部分配置： Panel power supplies 1、Reference power supplies Description Name Regulator Voltage (V) Panel power supply 0 vddio PMIC 660/L11 1.8 Panel power supply 1 Lab PMIC 660/lab 4.6 Panel power s... 阅读详情

create table hyzl_user(

	uID int unsigned auto_increment,

	uName nvarchar(50) not null,

	uPass nvarchar(20) not null,

	utName nvarchar(50) not null,

	uSex char(5) not null,

	uBir datetime,

	uConNum nvarchar(20),

	uNum nvarchar(20),

	uQQ bigint(8),

	uImg nvarchar(200),

	uEmail nvarchar(50),

	uAddr nvarchar(100),

	uConAddr nvarchar(100),

	uUrl nvarchar(50),

	uUserTypeID int unsigned default 1,

	primary key(uID)

) ;





/*版块信息表*/

create table bk_Module(

	bk_Name nvarchar(50) not null,

	bk_userName nvarchar(50) not null,

	bk_ID int unsigned auto_increment,

	primary key(bk_ID)

);



create view bk_user as select 

	bk_Module.*,

	hyzl_user.*

	from bk_Module left join bk_Module on(bk_Module.bk_userName=hyzl_user.uName);