SQL Error: 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 'sql longtext' at line 1
ALTER TABLE replicate_log MODIFY COLUMN SQL longtext
Checking STRUCTURE phase 2
ALTER TABLE xray_rent ADD `home_rent` CHAR(1) NULL
SQL Error: 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 'sql longtext' at line 1
ALTER TABLE replicate_log MODIFY COLUMN SQL longtext
ALTER TABLE replicate_lock ADD `computer_name` VARCHAR(100) NULL
ALTER TABLE referin ADD `staff` VARCHAR(50) NULL
ALTER TABLE person ADD `death` CHAR(1) NULL
ALTER TABLE person ADD `last_update` datetime NULL
ALTER TABLE person ADD `sps_cid` VARCHAR(13) NULL
ALTER TABLE person ADD `mother_cid` VARCHAR(13) NULL
ALTER TABLE person ADD `father_cid` VARCHAR(13) NULL
ALTER TABLE operation_screen_in ADD `chronic_disease` VARCHAR(200) NULL
ALTER TABLE operation_recovery_room ADD `complication` text NULL
ALTER TABLE operation_recovery_room ADD `recovery_dch_id` INT NULL
ALTER TABLE operation_list ADD `anes_complete` CHAR(1) NULL
ALTER TABLE operation_intra_complication ADD `complication_type_id` INT NULL
ALTER TABLE operation_anes_invent ADD `sp_use` VARCHAR(9) NULL
ALTER TABLE operation_agent ADD `price` DOUBLE(15,3) NULL
ALTER TABLE opduser ADD `show_tip` CHAR(1) NULL
ALTER TABLE lab_items ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE lab_items ADD `items_is_outlab` CHAR(1) NULL
ALTER TABLE drug_interaction ADD `check_old_prescription` CHAR(1) NULL
ALTER TABLE doctor_order_print MODIFY COLUMN bed_no VARCHAR(6)
Checking STRUCTURE phase 1
TABLE opdscreen has hos_guid
TABLE patient has hos_guid
TABLE ovst has hos_guid
TABLE opitemrece
หัวข้อ: MODIFY COLUMN sql text-----> longtext (อ่าน 6161 ครั้ง)