upload_mysql.sql

来自「一个用jsp开发的文件上传系统。利用javabean来实现的。来练习javabe」· SQL 代码 · 共 15 行

# **-----------------------------------------------------------------**
# ** Creates MySQL table to store binary files                       **
# **                                                                 **
# ** UploadBean/MySQL sample script.                                 **
# ** http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html   **
# ** Copyright JavaZOOM 1999-2003.                                   **
# **-----------------------------------------------------------------**
# DROP TABLE UPLOADS;
CREATE TABLE UPLOADS (
	UPLOADID INT NOT NULL, 
	FILENAME VARCHAR(255), 
	BINARYFILE LONGBLOB,
	PRIMARY KEY (UPLOADID)
);