hero913
(文风大侠)
高级会员
现在穷疯了，没钱
UID 70150
精华
0
积分 924
帖子 958
金钱 924 喜悦币
威望 0
人脉 0
阅读权限 50
注册 2006-3-23
状态 离线
|
[推荐阅读] 寻一下实习机会(广东地区)
现在才发现，提示的是另外两表
本来是$sql="insert into w03a_packinglistbody
没办法了，搞了半天不知道错在哪里了
-- 表的结构 `w03_packinglisthead`
--
CREATE TABLE `w03_packinglisthead` (
`w03_rid` int(10) unsigned NOT NULL auto_increment,
`w03_customer` varchar(3) NOT NULL default '',
`w03_plid` varchar(7) NOT NULL default '',
`w03_invoiceid` varchar(10) default NULL,
`w03_date` date NOT NULL default '0000-00-00',
`w03_noteid` varchar(10) NOT NULL default '',
`w03_input` varchar(6) NOT NULL default '',
`w03_time` datetime NOT NULL default '0000-00-00 00:00:00',
`w03_ip` tinytext NOT NULL,
PRIMARY KEY (`w03_rid`),
KEY `w03_plid` (`w03_plid`,`w03_noteid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='装箱单表头' AUTO_INCREMENT=1 ;
的结构 `w03a_packinglistbody`
--
CREATE TABLE `w03a_packinglistbody` (
`w03a_rid` int(10) unsigned NOT NULL auto_increment,
`w03a_w03_plid` varchar(7) NOT NULL default '',
`w03a_arkno` tinyint(2) NOT NULL default '0',
`w03a_name` varchar(40) NOT NULL default '',
`w03a_contid` varchar(9) NOT NULL,
`w03a_assistid` varchar(5) NOT NULL default '',
`w03a_custstyles` varchar(20) NOT NULL default '',
`w03a_styles` varchar(8) NOT NULL default '',
`w03a_size` tinytext NOT NULL,
`w03a_color` varchar(20) NOT NULL default '',
`w03a_no` int(5) NOT NULL default '0',
`w03a_remark` text NOT NULL,
PRIMARY KEY (`w03a_rid`),
KEY `w03a_w03_plid` (`w03a_w03_plid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='装箱单表体' AUTO_INCREMENT=1 ;
表的结构 `y03_shipmenthead`
--
CREATE TABLE `y03_shipmenthead` (
`y03_rid` int(10) unsigned NOT NULL auto_increment,
`y03_client` varchar(3) NOT NULL,
`y03_date` date NOT NULL default '0000-00-00',
`y03_delidate` date NOT NULL default '0000-00-00',
`y03_id` varchar(10) NOT NULL,
`y03_operation` varchar(6) NOT NULL,
`y03_time` datetime NOT NULL default '0000-00-00 00:00:00',
`y03_ip` tinytext NOT NULL,
PRIMARY KEY (`y03_rid`),
KEY `y03_client` (`y03_client`),
KEY `y03_client_2` (`y03_client`),
KEY `y03_id` (`y03_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[ 本帖最后由 hero913 于 2006-7-25 03:04 PM 编辑 ]
| 
MSN:aaron-0913@hotmail.com
skype:chenqiangang
QQ:105915495
php我的最爱，希望志同道合的加我，聊一聊
给我留言 |
|
