Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- character_set_client utf8
- character_set_connection utf8
- character_set_database utf8
- character_set_filesystem binary
- character_set_results utf8
- character_set_server utf8
- character_set_system utf8
- import * as mysql from "mysql"
- let connection = mysql.createConnection({
- user: "login",
- password: "***",
- database: "bazaname",
- host: "hosting.ru",
- port:3306
- })
- connection.connect()
- 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");')
- connection.end()
Add Comment
Please, Sign In to add comment