Pages

▼
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
Wednesday, October 25, 2023

Mysql trigger for checking duplicate record in Table before insert using trigger

›
I am to creating a trigger for my table User which checks for duplicates (Mobile number) in the User table before inserting a ne...
Thursday, October 19, 2023

How to fix the MySQL error: Illegal mix of collations for operation union

›
Well, you probably have different collations in some MySQL views or stored procedures, try to force collation like this: S...
Saturday, December 31, 2022

How to export some rows of a MySQL table using WHERE clause - Selectively dumping data with mysqldump feature - MySQL export few rows from selected table as SQL file

›
How to export some rows of a MySQL table with where clause? I have a MySQL say test and I want to create a impo...
Monday, December 26, 2022

Where can I find the MySQL log file in XAMPP - Activate logs in Xampp-Mysql

›
I use PHP (PDO) to access MySQL in XAMPP. My question is where I can find the MySQL query log, exact query that ...

PHP & MySQL PDO: PDO binding values for MySQL IN statement - Bind an array to an IN() condition?

›
The answer there was that, for a variable sized list in the in clause, you'll need to construct the query you...
Sunday, December 25, 2022

Rollback or Commit with PDO transaction using PHP and MySQL - SELECT query with PDO - PDO with INSERT INTO through prepared statements

›
A transaction should end with either a rollback() or a commit(), (only one of them). In case you are using MyS...
Friday, October 28, 2022

MySQL "Group By" and "Order By"

›
A simple solution is to wrap the query into a subselect with the ORDER statement first and applying the GROUP BY ...

How to convert result table to JSON Array or JSON Object or JSON String in MySQL

›
I'd like to convert result table to JSON Array of Object in MySQL using preferably only plain MySQL commands....

MySQL casting from decimal to string - mysql cast to varchar - mysql convert decimal to string char varchar

›
MySQL - casting from decimal to string select CAST(ROUND(345345345345345345345353453453453454.4345345,6) AS C...