Createtablesalary (random (100), employeeIdchar (100), employeeNamechar (100), yearchar (100), monthchar (), interval, overtimeWagefloat, interval, totalWagefloat, interval, secureReducefloat, taxRed... mysqlsql statement
Create table salary (
SalaryId int identity (1, 1 ),
EmployeeId char (100 ),
EmployeeName char (100 ),
Year char (100 ),
Month char (100 ),
BasicWage float,
OvertimeWage float,
TrafficWage float,
TotalWage float,
KaoqinReduce float,
SecureReduce float,
TaxReduce float,
TotalReduce float,
RealWage float,
EditTime char (100 ),
Apsaradb for memo char (100)
)
Then the error message is displayed: (I actually run it on Navicat)
[Err] 1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identity ),
EmployeeId char (100 ),
EmployeeName char (100 ),
Year char (100 'at line 2
Year char (100 'at line 2