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

Различия между постами #121446 (23.05.2019 10:54) и #148194 (10.10.2020 23:36).
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
1
Привет всем участникам форума! Класный у вас сайт!
2
Что думаете по этим новостям?:
3
ЛНА начала контрнаступление южнее Триполи http://techrize.ru/news/46804-lna-nachala-kontrnastuplenie-yuzhnee-tripoli.html
4
http://techrize.ru/politika/23108-pensionerki-iz-kieva-priglasili-trampa-na-ukrainu-plakatami-na-angliyskom.html
5
Ещё много интересного нашел тут:  новости украины сегодня видео  http://techrize.ru/
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 |

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;