Advertisement
sakthyict

sql new echos after edited

Jun 22nd, 2018
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.94 KB | None | 0 0
  1. No rows to insert for .bank_accounts.
  2.  
  3. No rows to insert for .bank_transactions.
  4.  
  5. No rows to insert for .cashdrawer_open_time.
  6.  
  7. `id` column not found. ON DUPLICATE KEY UPDATE clause NOT added.
  8.  
  9. Columns Found:
  10.  
  11. Array
  12. (
  13.     [0] => `id`
  14.     [1] => `name`
  15.     [2] => `description`
  16.     [3] => `added_on`
  17.     [4] => `last_updated`
  18.     [5] => `department`
  19. )
  20. Insert query:
  21.  
  22. INSERT INTO `counters`
  23. (`id`,`name`,`description`,`added_on`,`last_updated`,`department`)
  24. VALUES
  25. ('2','B','SAKTHY','2018-06-21T12:49:30','2018-02-18T12:49:40','1'),
  26. ('5','E','SAKTHY2','2018-06-21T12:50:21','2018-06-21T14:52:18','1'),
  27. ('6','SAKTHY3','Sample Friday','2018-06-22T10:47:18','2018-06-22T10:47:18','1')
  28. 1062: Duplicate entry '2' for key 'PRIMARY'
  29. -1 Rows appended in .counters.
  30.  
  31. No rows to insert for .customer_transactions.
  32.  
  33. No rows to insert for .customers.
  34.  
  35. No rows to insert for .department_stock_transfers.
  36.  
  37. No rows to insert for .departments.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement