Desktop Center (I) creating databases

Desktop Center (I) create a database Source: Aesop

Desktop Center (I) creating databases

Author: elong


This is the first time the younger brother wrote an article. I don't know if it can be released .. I want to write the program for your reference. If any expert can develop a better program,
Please don't forget to speak with me. : P
On the demo page of the source program, go to elong.oso.com.cn/
Step 1: create a database:
We will describe it in the OSO database column.
Log on to the database first. Click your database name on the left.
Enter the following command in the command field.
Create table jpg (
Id int (8) not null auto_increment,
Url char (255) not null,
Mess char (100) not null,
Fromx char (50) not null,
Url1 char (255) not null,
Mess1 char (100) not null,
Fromx1 char (50) not null,
Url2 char (255) not null,
Mess2 char (100) not null,
Fromx2 char (50) not null,
Url3 char (255) not null,
Mess3 char (100) not null,
Fromx3 char (50) not null,
Primary key (id)
);
Create table jpg1 (
Id int (8) not null auto_increment,
Url char (255) not null,
Mess char (100) not null,
Fromx char (50) not null,
Url1 char (255) not null,
Mess1 char (100) not null,
Fromx1 char (50) not null,
Url2 char (255) not null,
Mess2 char (100) not null,
Fromx2 char (50) not null,
Url3 char (255) not null,
Mess3 char (100) not null,
Fromx3 char (50) not null,
Primary key (id)
);
Create table jpg2 (
Id int (8) not null auto_increment,
Url char (255) not null,
Mess char (100) not null,
Fromx char (50) not null,
Url1 char (255) not null,
Mess1 char (100) not null,
Fromx1 char (50) not null,
Url2 char (255) not null,
Mess2 char (100) not null,
Fromx2 char (50) not null,
Url3 char (255) not null,
Mess3 char (100) not null,
Fromx3 char (50) not null,
Primary key (id)
);
Create table jpg3 (
Id int (8) not null auto_increment,
Url char (255) not null,
Mess char (100) not null,
Fromx char (50) not null,
Url1 char (255) not null,
Mess1 char (100) not null,
Fromx1 char (50) not null,
Url2 char (255) not null,
Mess2 char (100) not null,
Fromx2 char (50) not null,
Url3 char (255) not null,
Mess3 char (100) not null,
Fromx3 char (50) not null,
Primary key (id)
);
Create table jpg4 (
Id int (8) not null auto_increment,
Url char (255) not null,
Mess char (100) not null,
Fromx char (50) not null,
Url1 char (255) not null,
Mess1 char (100) not null,
Fromx1 char (50) not null,
Url2 char (255) not null,
Mess2 char (100) not null,
Fromx2 char (50) not null,
Url3 char (255) not null,
Mess3 char (100) not null,
Fromx3 char (50) not null,
Primary key (id)
);
These commands mean creating four tables to store data. This represents four types of images. If you want to add classes, you can add more tables and modify the source program.