استخدم الأوامر التالية
CREATE TABLE sss(
PRIMARY KEY (Identity),
Identity VARCHAR(11) NOT NULL,
Identity2 VARCHAR(11),
SchID BIGINT,
SubID TINYINT,
name1 VARCHAR(255),
name2 VARCHAR(255),
name3 VARCHAR(255),
FName VARCHAR(100),
NatID TINYINT,
QID TINYINT,
QDatey INT,
QDatem TINYINT,
QDated TINYINT,
University TINYINT,
Country TINYINT,
SpecialID TINYINT,
WID TINYINT,
PreSchool BIGINT,
Contract TINYINT,
ContractDated VARCHAR(2),
ContractDatem VARCHAR(2),
ContractDatey VARCHAR(4),
Educational TINYINT,
WorkDatey INT,
WorkDatem TINYINT,
WorkDated TINYINT,
IdDatey INT,
IdDatem TINYINT,
IdDated TINYINT,
IdReference VARCHAR(15),
JobID BIGINT,
BirthDatey INT,
BirthDatem TINYINT,
BirthDated TINYINT,
BirthPlace VARCHAR(25),
Level TINYINT,
Degree TINYINT,
EmpStatus VARCHAR(5),
AddressIn VARCHAR(35),
Mopaul VARCHAR(25),
Married TINYINT,
SunNo TINYINT,
SunUnder6 TINYINT,
SunF6_24 TINYINT,
ClassNo TINYINT,
OtherClasses TINYINT,
salary FLOAT,
absent INT,
mark1 FLOAT,
absent_W INT,
Reduction TINYINT,
NOTBAD VARCHAR(255),
phone VARCHAR(9),
WID_D VARCHAR(2),
WID_M VARCHAR(2),
WID_Y VARCHAR(4),
decision VARCHAR(255),
deciInvo VARCHAR(255),
guidance_date_d INT,
guidance_date_m INT,
guidance_date_y INT,
guidance_no VARCHAR(50),
IDW TINYINT,
NOTBAD1 VARCHAR(50),
PreSchoolS BIGINT,
trans_manteg1 TINYINT,
SpecialID2 TINYINT,
trans_mohafz2 INT,
completion VARCHAR(80),
quien TINYINT,
Quien_mark FLOAT,
Appointment VARCHAR(25),
AppDateD TINYINT,
AppDateM TINYINT,
AppDatey INT,
First_work TINYINT,
Nobby INT,
Sile_contract VARCHAR(50),
Escort_cont TINYINT,
area_Deleg TINYINT,
Deleg_dateD TINYINT,
Deleg_dateM TINYINT,
Deleg_dateY INT,
Work_Count_D TINYINT,
Work_Count_M TINYINT,
Work_Count_Y INT,
work_Area_D TINYINT,
Work_Area_M TINYINT,
Work_Area_Y INT,
Work_Shl_D TINYINT,
Work_Shl_M TINYINT,
Work_Shl_Y INT,
Level2 TINYINT,
Curator VARCHAR(50),
CuratorID VARCHAR(11),
Relation TINYINT,
Address VARCHAR(50),
Box VARCHAR(8),
Post VARCHAR(20),
Amail VARCHAR(50),
Authority1 TINYINT,
holiday_d TINYINT,
holiday_m TINYINT,
holiday_y INT,
GoToUp TINYINT,
continuance TINYINT,
tagdeer TINYINT,
mark2 FLOAT,
StIDAppointment TINYINT,
Jawal VARCHAR(10),
StQTID TINYINT,
Yno BIGINT,
Trid BIGINT,
SortNo BIGINT,
ResNo BIGINT,
ResDesi BIGINT,
ResST BIGINT
);
ومن ثم اضف المدخلات بشكل يدوي من خلال ال phpmyadmin
__________________
كل مالا يعطى يضيع
رد مع اقتباس
واي خدمه تحت امرك
