Top "Mysql" questions

What is the location of mysql client ".my.cnf" in XAMPP for Windows?

What is the location of mysql client .my.cnf using XAMPP in Windows? Clarification: This file does not exist by …

mysql windows xampp

Combine Multiple child rows into one row MYSQL

Thanks in advance, I just can't seem to get it! I have two tables Ordered_Item ID | Item_Name 1 | Pizza 2 | …

mysql select join

php artisan migrate throwing [PDO Exception] Could not find driver - Using Laravel

I have a bad experience while installing laravel. However, I was able to do so and move to the next …

php mysql pdo laravel driver

How can I rebuild indexes and update stats in MySQL innoDB?

I have experience with MS SQL server where it is possible and useful to update statistic and rebuild indexes. I …

mysql innodb

Export DataBase with MySQL Workbench with INSERT statements

I am trying to export the DataBase i have at MySQL Workbench but I am having troubles to generate the …

mysql mysql-workbench

Checking for empty result (php, pdo, mysql)

Please, can anyone tell me what I'm doing wrong here? I'm simply retrieving results from a table then adding them …

php mysql pdo

Inserting records into a MySQL table using Java

I created a database with one table in MySQL: CREATE DATABASE iac_enrollment_system; USE iac_enrollment_system; CREATE TABLE …

java mysql sql jdbc insert-into

Create table variable in MySQL

I need a table variable to store the particular rows from the table within the MySQL procedure. E.g. declare @…

mysql variables database-table

Docker (Apple Silicon/M1 Preview) MySQL "no matching manifest for linux/arm64/v8 in the manifest list entries"

I'm running the latest build of the Docker Apple Silicon Preview. I created the tutorial container/images and it works …

mysql docker apple-silicon

'LIKE ('%this%' OR '%that%') and something=else' not working

I have a select query where I am trying to search strings for multiple patterns LIKE ('%this%' or …

mysql sql sql-like