spb.sql

来自「关于shopmanager的源码」· SQL 代码 · 共 16 行

/*
SQLyog Enterprise - MySQL GUI
Host - 5.1.12-beta-community-nt 
*********************************************************************
Server version : 5.1.12-beta-community-nt
*/
/*!40101 SET NAMES utf8 */;

create table `spb` (
	`itemid` varchar (30),
	`shortname` varchar (30),
	`longname` varchar (60),
	`price` Decimal (11)
); 
insert into `spb` (`itemid`, `shortname`, `longname`, `price`) values('123','fth','ftydthdrty','212');