Thanks, it's much easier with the structure and some data.
Code: Select all
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.5.9-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [test]> CREATE DATABASE PB_Test;
Query OK, 1 row affected (0.001 sec)
MariaDB [test]> USE PB_Test;
Database changed
MariaDB [PB_Test]> CREATE TABLE `orders` (
-> `aa` int(11) NOT NULL,
-> `hmeromhnia` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `wra` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `seconds` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `order_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `items` double DEFAULT NULL,
-> `amount` double DEFAULT NULL,
-> `discount` double DEFAULT NULL,
-> `vat` double DEFAULT NULL,
-> `amount_vat` double DEFAULT NULL,
-> `amount_net` double DEFAULT NULL,
-> `amount_total` double DEFAULT NULL,
-> `amount_paid` double DEFAULT NULL,
-> `amount_canceled` double DEFAULT NULL,
-> `user_id` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `transfer_from_user` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `kwd_prom_pel` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `table_id` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `table_comments` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `transfer_from_table` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `order_printed_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `additional_order` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `comments` blob,
-> `remarks` blob,
-> `user_comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `assign_to` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `pay_with_cash` double DEFAULT NULL,
-> `pay_with_card` double DEFAULT NULL,
-> `pay_with_cheque` double DEFAULT NULL,
-> `pay_with_exhange` double DEFAULT NULL,
-> `pay_with_credit` double DEFAULT NULL,
-> `rec_stamp` bigint(20) DEFAULT NULL,
-> `authorised_by` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `sxolia` blob,
-> `order_no` bigint(20) DEFAULT NULL,
-> `unique_id` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
-> `updated` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Query OK, 0 rows affected (0.007 sec)
MariaDB [PB_Test]> DESC orders;
+---------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+--------------+------+-----+---------+-------+
| aa | int(11) | NO | | NULL | |
| hmeromhnia | varchar(25) | YES | | NULL | |
| wra | varchar(25) | YES | | NULL | |
| seconds | varchar(25) | YES | | NULL | |
| order_id | varchar(50) | YES | | NULL | |
| items | double | YES | | NULL | |
| amount | double | YES | | NULL | |
| discount | double | YES | | NULL | |
| vat | double | YES | | NULL | |
| amount_vat | double | YES | | NULL | |
| amount_net | double | YES | | NULL | |
| amount_total | double | YES | | NULL | |
| amount_paid | double | YES | | NULL | |
| amount_canceled | double | YES | | NULL | |
| user_id | varchar(25) | YES | | NULL | |
| transfer_from_user | varchar(25) | YES | | NULL | |
| kwd_prom_pel | varchar(25) | YES | | NULL | |
| table_id | varchar(25) | YES | | NULL | |
| table_comments | varchar(25) | YES | | NULL | |
| transfer_from_table | varchar(25) | YES | | NULL | |
| order_printed_id | varchar(50) | YES | | NULL | |
| additional_order | varchar(50) | YES | | NULL | |
| comments | blob | YES | | NULL | |
| remarks | blob | YES | | NULL | |
| user_comments | varchar(255) | YES | | NULL | |
| assign_to | varchar(25) | YES | | NULL | |
| status | varchar(25) | YES | | NULL | |
| pay_with_cash | double | YES | | NULL | |
| pay_with_card | double | YES | | NULL | |
| pay_with_cheque | double | YES | | NULL | |
| pay_with_exhange | double | YES | | NULL | |
| pay_with_credit | double | YES | | NULL | |
| rec_stamp | bigint(20) | YES | | NULL | |
| authorised_by | varchar(25) | YES | | NULL | |
| sxolia | blob | YES | | NULL | |
| order_no | bigint(20) | YES | | NULL | |
| unique_id | varchar(100) | YES | | NULL | |
| updated | varchar(50) | YES | | NULL | |
+---------------------+--------------+------+-----+---------+-------+
38 rows in set (0.005 sec)
MariaDB [PB_Test]> INSERT INTO orders (AA, HMEROMHNIA, WRA, ORDER_ID, ITEMS, AMOUNT, DISCOUNT, AMOUNT_TOTAL, AMOUNT_PAID, AMOUNT_CANCELED, USER_ID, KWD_PROM_PEL, TABLE_ID, ADDITIONAL_ORDER, COMMENTS, REMARKS, USER_COMMENTS, ASSIGN_TO, STATUS, REC_STAMP, AUTHORISED_BY, SXOLIA, ORDER_NO, UNIQUE_ID, UPDATED) VALUES (1, '2020-04-30', '06:10:15', '20200430_061015_025579062-00001-1', 1.0, 1.6, 0.0, 1.6, 0.0, 0.0, '00001-1', '1100-000-021-3', '', '', 'ΜΕ|ΜΕΤΡΙΟ|', '', '', '00008-1', '01', 1588227015, '', '', 1, '78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300610150255790621303', '2020-04-30, 06:10:15.25579062');
Query OK, 1 row affected (0.001 sec)
MariaDB [PB_Test]> INSERT INTO orders (AA, HMEROMHNIA, WRA, ORDER_ID, ITEMS, AMOUNT, DISCOUNT, AMOUNT_TOTAL, AMOUNT_PAID, AMOUNT_CANCELED, USER_ID, KWD_PROM_PEL, TABLE_ID, ADDITIONAL_ORDER, COMMENTS, REMARKS, USER_COMMENTS, ASSIGN_TO, STATUS, REC_STAMP, AUTHORISED_BY, SXOLIA, ORDER_NO, UNIQUE_ID, UPDATED) VALUES (2, '2020-04-30', '06:21:19', '20200430_062119_026243812-00001-1', 1.0, 1.6, 0.0, 1.6, 0.0, 0.0, '00001-1', '1300-000-070-4', '', '', 'ΜΕΤΡΙΟ|', '', '', '00008-1', '01', 1588227679, '', '', 2, '78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300621190262438123782', '2020-04-30, 06:21:19.26243812');
Query OK, 1 row affected (0.002 sec)
MariaDB [PB_Test]> INSERT INTO orders (AA, HMEROMHNIA, WRA, ORDER_ID, ITEMS, AMOUNT, DISCOUNT, AMOUNT_TOTAL, AMOUNT_PAID, AMOUNT_CANCELED, USER_ID, KWD_PROM_PEL, TABLE_ID, ADDITIONAL_ORDER, COMMENTS, REMARKS, USER_COMMENTS, ASSIGN_TO, STATUS, REC_STAMP, AUTHORISED_BY, SXOLIA, ORDER_NO, UNIQUE_ID, UPDATED) VALUES (3, '2020-04-30', '06:25:36', '20200430_062536_026500796-00001-1', 2.0, 3.2, 0.0, 3.2, 0.0, 0.0, '00001-1', '1300-000-070-4', '', '', 'ΜΕΤΡΙΟ|', '', '', '00008-1', '01', 1588227936, '', '', 3, '78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300625360265007963007', '2020-04-30, 06:25:36.26500796');
Query OK, 1 row affected (0.001 sec)
MariaDB [PB_Test]> INSERT INTO orders (AA, HMEROMHNIA, WRA, ORDER_ID, ITEMS, AMOUNT, DISCOUNT, AMOUNT_TOTAL, AMOUNT_PAID, AMOUNT_CANCELED, USER_ID, KWD_PROM_PEL, TABLE_ID, ADDITIONAL_ORDER, COMMENTS, REMARKS, USER_COMMENTS, ASSIGN_TO, STATUS, REC_STAMP, AUTHORISED_BY, SXOLIA, ORDER_NO, UNIQUE_ID, UPDATED) VALUES (4, '2020-04-30', '06:26:56', '20200430_062656_026580312-00001-1', 1.0, 1.9, 0.0, 1.9, 0.0, 0.0, '00001-1', '1300-000-105-9', '', '', 'ΓΛΥΚΟΣ|', '', '', '00008-1', '01', 1588228016, '', '', 4, '78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300626560265803128479', '2020-04-30, 06:26:56.26580312');
Query OK, 1 row affected (0.001 sec)
MariaDB [PB_Test]> INSERT INTO orders (AA, HMEROMHNIA, WRA, ORDER_ID, ITEMS, AMOUNT, DISCOUNT, AMOUNT_TOTAL, AMOUNT_PAID, AMOUNT_CANCELED, USER_ID, KWD_PROM_PEL, TABLE_ID, ADDITIONAL_ORDER, COMMENTS, REMARKS, USER_COMMENTS, ASSIGN_TO, STATUS, REC_STAMP, AUTHORISED_BY, SXOLIA, ORDER_NO, UNIQUE_ID, UPDATED) VALUES (5, '2020-04-30', '06:31:48', '20200430_063148_026872718-00001-1', 2.0, 3.2, 0.0, 3.2, 0.0, 0.0, '00001-1', '1300-000-168-3', '', '', '', '', '', '00008-1', '01', 1588228308, '', '', 5, '78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300631480268727183471', '2020-04-30, 06:31:48.26872718');
Query OK, 1 row affected (0.002 sec)
MariaDB [PB_Test]> SELECT COUNT(*) FROM orders;
+----------+
| COUNT(*) |
+----------+
| 5 |
+----------+
1 row in set (0.000 sec)
MariaDB [PB_Test]> SELECT unique_id, updated FROM orders;
+------------------------------------------------------------------+-------------------------------+
| unique_id | updated |
+------------------------------------------------------------------+-------------------------------+
| 78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300610150255790621303 | 2020-04-30, 06:10:15.25579062 |
| 78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300621190262438123782 | 2020-04-30, 06:21:19.26243812 |
| 78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300625360265007963007 | 2020-04-30, 06:25:36.26500796 |
| 78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300626560265803128479 | 2020-04-30, 06:26:56.26580312 |
| 78a13aee-7e3e-11ea-9347-806e6f6e6963}202004300631480268727183471 | 2020-04-30, 06:31:48.26872718 |
+------------------------------------------------------------------+-------------------------------+
5 rows in set (0.000 sec)
MariaDB [PB_Test]>