[sql] dyna1
Viewer
- /* CREATE TABLE */
- CREATE TABLE TABLE_NAME(
- `Data_Code` DOUBLE,
- `_id` DOUBLE,
- `_name` VARCHAR(100),
- `_gClass` DOUBLE,
- `_gParent` DOUBLE,
- `_gState` DOUBLE,
- `_dUpdateDate` VARCHAR(100),
- `_gUpdateBy` DOUBLE,
- `_dStartDate` VARCHAR(100),
- `_dEndDate` VARCHAR(100),
- `_iPriority` DOUBLE,
- `_iHealth` DOUBLE
- );
- /* INSERT QUERY NO: 1 */
- INSERT INTO TABLE_NAME(`Data_Code`, `_id`, `_name`, `_gClass`, `_gParent`, `_gState`, `_dUpdateDate`, `_gUpdateBy`, `_dStartDate`, `_dEndDate`, `_iPriority`, `_iHealth`)
- VALUES (100, 1102, 'Classic', 166, 0, 1, '2024-02-03T16:30:26.063362+05:30', 0, '1980-01-01T00:00:00', '2116-02-07T06:28:15', 0, 5);
Editor
You can edit this paste and save as new: