Advertisement
Guest User

Untitled

a guest
Feb 16th, 2016
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. `system("mysql --host=$db_host --user=$db_user --password=$db_password -v -v -v $database < ../update.sql");`
  2.  
  3. --------------
  4. ALTER TABLE `phppos_customers` ADD `current_sales_for_discount` int(10) NOT NULL DEFAULT '0' AFTER `current_spend_for_points`
  5. --------------
  6.  
  7. Terminal close -- sending "KILL QUERY 966" to server ...
  8. Terminal close -- query aborted
  9. Aborted
  10.  
  11. mysql> SHOW VARIABLES LIKE "%_timeout";
  12. +-----------------------------+----------+
  13. | Variable_name | Value |
  14. +-----------------------------+----------+
  15. | connect_timeout | 10 |
  16. | delayed_insert_timeout | 300 |
  17. | have_statement_timeout | YES |
  18. | innodb_flush_log_at_timeout | 1 |
  19. | innodb_lock_wait_timeout | 50 |
  20. | innodb_rollback_on_timeout | OFF |
  21. | interactive_timeout | 28800 |
  22. | lock_wait_timeout | 31536000 |
  23. | net_read_timeout | 30 |
  24. | net_write_timeout | 60 |
  25. | rpl_stop_slave_timeout | 31536000 |
  26. | slave_net_timeout | 60 |
  27. | wait_timeout | 28800 |
  28. +-----------------------------+----------+
  29. 13 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement