The Idea of the Query is to get all the entries where the seo_path_info has duplicates and the corresponding product is set to active. My Query is: SELECT `seo_path_info`,COUNT(`seo_path_info`) FROM `shopware`.`seo_url` seo GROUP BY `seo_path_info` HAVING COUNT(`seo_path_info`)>1 LEFT JOIN product…
I want to insert/update decimal number to mysql. But everytime I did. It return the round number or truncate dot number. I tried change the datatype of lv_pay and lv_dis either to decimal and double but still the result. MySQL…
I've recently upgraded MySQL to version 5.7.35 and PHP to version 7.4.21. This PHP script is failing to enter the data into 'my_table' $hoje = date("Y-m-d H:i:s"); $stmt = $db->prepare("INSERT INTO my_table(teste_id,data) VALUES (:ftesteid, :fdata)"); $stmt->bindParam(':ftesteid', $testeMaisRecente, PDO::PARAM_INT); $stmt->bindParam(':fdata', $hoje,…
Environment This is my environment: System: CentOS 7 virtual machine, created by virtualbox, only mysql installed MySQL: 5.7.35 Setup MySQL by this chinese toturial: link my.cnf: [mysqld] # slow query log slow_query_log=on slow_query_log_file=/var/log/mysql/slow_query.log long_query_time=1 # UTF-8 collation-server=utf8_general_ci init-connect='SET NAMES utf8'…
I have a query that is not returning all the results it should. I'm using Laravel, but the result is the same if I write the query directly in PHPMyAdmin: clientpages::selectRaw('page as value, COUNT(ID) as `count`') ->where('page', 'like', '%blog%') ->orWhere('page',…
I am trying to create a script, which will update column lang_id in table static if static.method_id = methods.method_id and if methods.mm_id = languages.mm_id and if languages.is_default = 1. But this one is not working, tell me please, why? UPDATE…
EDIT : the pbm is not that I used space in the password after all, so I changed the description While trying to configure xampp, I ran into an error : fatal: unknown configuration directive 'function' on line 44 of…
I've been using the code below to populate tables in a MySQL database for a few years and it's been working fine. Imports MySql.Data.MySqlClient Public sub Thing(dt as datatable) Try 'dt is datatable object populated from MSsqlServer Dim MySQLcmdSelect As…
I'm using xampp as a dev server and it has worked great for weeks. I had to reboot the machine xampp is installed on today and now, this evening, I am getting errors (warnings) when trying to do the exact…
I have table look like this in phpmyadmin: +-----------+-----------------+-------------------+ |nom_ele_id | nom_ele_title | nom_ele_parent_id | +===========+=================+===================+ | 7060 | STANDARD | NULL | | 6953 | SOL | 7060 | | 6957 | type de sol | 6953 | +-----------+-----------------+-------------------+…