This is the first time the younger brother writes an article. I don't know if I can release it. I write out the program is to want you to refer to. If you have a master who can change a better program,
Please don't forget to tell me. :P
The source program's demo page is elong.oso.com.cn/desk/
The first step is to create a database:
Let's take the Oso database as a list.
Log into the database first. Then at the point of your own database name, right on the left.
Enter the following command at the input command.
CREATE TABLE jpg (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE JPG1 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE JPG2 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE jpg3 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE Jpg4 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
The meaning of these commands is to create four tables to store the data. This represents the four classes of the picture. If you want to add a class you can add a table and change the source program.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.