Guest User

Untitled

a guest
Dec 14th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. character_set_client utf8
  2. character_set_connection utf8
  3. character_set_database utf8
  4. character_set_filesystem binary
  5. character_set_results utf8
  6. character_set_server utf8
  7. character_set_system utf8
  8.  
  9. import * as mysql from "mysql"
  10.  
  11. let connection = mysql.createConnection({
  12. user: "login",
  13. password: "***",
  14. database: "bazaname",
  15. host: "hosting.ru",
  16. port:3306
  17. })
  18.  
  19. connection.connect()
  20.  
  21. connection.query('INSERT INTO `info`(`ordertime`, `ordertimefmt`, `ordertype`, `orderamount`, `orderform`, `ordercode`, `cadnum`, `useripaddr`, `useragent`, `userphone`, `exectime`, `exectimefmt`, `orderstatus`, `uuid`) VALUES ("1513230713158","2017-12-14T00:51:53.158Z","1",-100,"{\"region\":\"Москва\",\"city\":\"\",\"street\":\"\",\"type_street\":\"\",\"house\":\"\",\"apartment\":\"\",\"t1\":\"1\"}","","66:41:705006:719","192.168.1.123","","81234567890","1513230713158","2017-12-14T00:51:53.158Z",1,"c630f86b-9333-4f02-b980-230dcf945017");')
  22. connection.end()
Add Comment
Please, Sign In to add comment