Сравнение постов

Различия между постами #121446 (23.05.2019 10:54) и #121447 (23.05.2019 12:14).
1
mak@sol ~/.go/src/gitlab.com/mak-alex/talapricing $ ssh talapai@vs02.talapai.kz
2
Last login: Thu May 23 13:09:10 2019 from 89.20.48.161
3
[talapai@vs02.talapai.kz ~]$ mysql -utalapai -pm9zUtMNSq0ap parsers
4
mysql: [Warning] Using a password on the command line interface can be insecure.
5
Reading table information for completion of table and column names
6
You can turn off this feature to get a quicker startup with -A
7
8
Welcome to the MySQL monitor.  Commands end with ; or \g.

9
Your MySQL connection id is 102765402

10
Server version: 5.7.24-log MySQL Community Server (GPL)

11
12
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

13
14
Oracle is a registered trademark of Oracle Corporation and/or its

15
affiliates. Other names may be trademarks of their respective

16
owners.

17
18
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

19
20
mysql> select * from products_bindings limit 10;

21
+-------+--------------------+-----------------+---------+

22
| id    | talapai_product_id | shop_product_id | shop_id |

23
+-------+--------------------+-----------------+---------+

24
|  9900 |                 15 |            9359 |       7 |

25
|  2218 |                 15 |         2900011 |       1 |

26
| 10587 |                 27 |        22500134 |       1 |

27
| 10653 |                 28 |        22500139 |       1 |

28
|  9212 |                 39 |           10187 |       7 |

29
|  2660 |                 39 |         3601163 |       1 |

30
| 15226 |                 40 |            9802 |       7 |

1
mak@sol ~/ $ talapai_dump && parser_dump

2
mak@sol ~/.go/src/gitlab.com/mak-alex/talapricing $ ssh talapai@vs02.talapai.kz

3
Last login: Thu May 23 13:09:10 2019 from 89.20.48.161

4
[talapai@vs02.talapai.kz ~]$ mysql -utalapai -pm9zUtMNSq0ap parsers

5
mysql: [Warning] Using a password on the command line interface can be insecure.

6
Reading table information for completion of table and column names

7
You can turn off this feature to get a quicker startup with -A

8
9
Welcome to the MySQL monitor.  Commands end with ; or \g.

10
Your MySQL connection id is 102765402

11
Server version: 5.7.24-log MySQL Community Server (GPL)

12
13
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

14
15
Oracle is a registered trademark of Oracle Corporation and/or its

16
affiliates. Other names may be trademarks of their respective

17
owners.

18
19
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

20
21
mysql> select * from products_bindings where talapai_product_id=15;

22
+------+--------------------+-----------------+---------+

23
| id   | talapai_product_id | shop_product_id | shop_id |

24
+------+--------------------+-----------------+---------+

25
| 9900 |                 15 |            9359 |       7 |

26
| 2218 |                 15 |         2900011 |       1 |

27
+------+--------------------+-----------------+---------+

28
2 rows in set (0.00 sec)

29
30
mysql> delete from products_bindings where shop_product_id=2900011 and talapai_product_id=15 and shop_id=1;

31
| 12853 |                 40 |           36697 |       5 |

32
| 12852 |                 40 |          694088 |       4 |

33
| 12851 |                 40 |         3600775 |       1 |

34
+-------+--------------------+-----------------+---------+

35
10 rows in set (0.00 sec)

36
37
mysql> select * from products_bindings where talapai_product_id=15;

38
+------+--------------------+-----------------+---------+

39
| id   | talapai_product_id | shop_product_id | shop_id |

40
+------+--------------------+-----------------+---------+

41
| 9900 |                 15 |            9359 |       7 |

42
| 2218 |                 15 |         2900011 |       1 |

43
+------+--------------------+-----------------+---------+

44
2 rows in set (0.00 sec)

45
46
mysql> delete from products_bindings where shop_product_id=2900011 and talapai_product_id=15 and shop_id=1;