[sql] dyna1

Viewer

  1. /* CREATE TABLE */
  2. CREATE TABLE TABLE_NAME(
  3. `Data_Code` DOUBLE,
  4. `_id` DOUBLE,
  5. `_name` VARCHAR(100),
  6. `_gClass` DOUBLE,
  7. `_gParent` DOUBLE,
  8. `_gState` DOUBLE,
  9. `_dUpdateDate` VARCHAR(100),
  10. `_gUpdateBy` DOUBLE,
  11. `_dStartDate` VARCHAR(100),
  12. `_dEndDate` VARCHAR(100),
  13. `_iPriority` DOUBLE,
  14. `_iHealth` DOUBLE
  15. );
  16.  
  17. /* INSERT QUERY NO: 1 */
  18. INSERT INTO TABLE_NAME(`Data_Code`, `_id`, `_name`, `_gClass`, `_gParent`, `_gState`, `_dUpdateDate`, `_gUpdateBy`, `_dStartDate`, `_dEndDate`, `_iPriority`, `_iHealth`)
  19. 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);
  20.  
  21.  

Editor

You can edit this paste and save as new: