Category "mysql"

carbon generated datetime not stored correctly into the database

I have a tv_shows table where i'm trying to store the start and end datetime of each tv show. this is my migration: Schema::create('tv_shows', function (Bluepri

create shema databse using XSD in mysql

I have a shema database in file type XSD this file contains descriptions of all tables. My question is how I can use this file to create a database in MySQL. i

Is this Mysql Bug？ About SELECT ... FOR UPDATE lock_mode X insert intention

have a table struct is id, aid, ...... the aid is an index(a type of int) trx1 and 2: begin; trx1: select max(id) from a where aid = 10 for update; trx2: sele

Is OPTIMIZE / ANALYZE required after mysql table TRUNCATE?

In mysql database, I have about 20 tables (data size is very small - most of the tables have about 1,000 to 20,000 records, only one table has 200,000 records).

pymysql just select value and save into variable

cursor.execute("SELECT price FROM tabel WHERE id = 1600") print cursor.fetchone() gives me the output {u'price': u'4345.6'} how can I select just the value

ORDER BY field from a comma separated subquery

I'm trying to order a query based on the comma separated result of another query SELECT t.field1, t.field2 /*, ...*/ FROM table t /* ... */ ORDER BY CASE W

Handle error for duplicate entries - PHP/MySQL

What is the proper way to handle error on duplicate entries for PHP/MySQL? The code below is not working even tho the code 1062 is the right code for duplicate

Laravel Sail Docker PHPMyAdmin : SQLSTATE[HY000] [2002] No such file or directory

I have some trouble connecting to PHPMyAdmin. So I always get the following message. SQLSTATE[HY000] [2002] No such file or directory I looked for a solution

RELIABLE way of starting and stoping xampp (Mysql, Apache, Tomcat) from a batch file without crashing mysql databases

THE ENVIRONMENT: I am using Xampp (Mysql, Apache, Tomcat) for writing Java applications in Windows 11. THE PROBLEM: Everytime i forget to close xampp, and resta

Named parameter not bound : DATE_FORMAT Native Query in Spring Boot

I am trying to get table data as list using select query between dateFrom and current date using MySQL Native Query in Spring Boot. and MySQL database field dat

Query to retrieve rows where a value has changed

trying to get back into some very rusty SQL skills and already over my head! I have a table (example below) where each week I upload rows that indicate the prog

How to fix a Laravel Sail "SQLSTATE[HY000] [1130] Host 'XXX.XXX.X.X' is not allowed to connect to this MySQL server" error

Laravel: 9.2Mac OS: 12.3.1Docker Desktop: 4.5.0 I have installed a default Laravel project using sail. My docker-compose.yml file includes the following: mysql:

Rank actors with movies released in India based on their average ratings. Which actor is at the top of the list?

-- Note: The actor should have acted in at least five Indian movies. -- (Hint: You should use the weighted average based on votes. If the ratings clash, then t

Linux Bash to mysql: Select or delete record with external value

I have a MariaDB (mysql) database with a table which looks like this: MariaDB [DevicesPool]> show columns from Dirs_and_Names; +-----------------+-------

Kafka producer can't create topics and throwing continuous error after creating Debezium MySQL connector

I am using Debezium as a CDC tool to stream data from MySql. After installing Debezium MySQL connector to Confluent OSS cluster, I am trying to capture MySQL bi

Use date (-1 day) on next row to be the end date for current row

I am trying to self join in my current script in order to find the next row and then whatever day specified it should minus 1 day from it and put that in the e

Inserting NaN value into MySQL Database

I have some data that contains NULLs, floats and the occasional Nan. I'm trying to insert this data into a MySQL database using python and MySqldb. Here's the

Install mysql client in docker image

I am trying to build a docker image for php, which can handle database dumping in my mysql container. The problem is that it seems to install the mariadb versio

GRANT 'role' TO 'user'@'%' denied with Error Code: 1227 in mysql 8.0 AWS

We are using MySQL version 8.0 on AWS RDS. Logged in with Admin user on the database using MySQL Workbench version 8.0.16 and performed below steps. CREATE ROL

Docker Container DB dont show up

Hello currently I get in touch with Docker. I am doing their getting started and I ran into a problem which I cant solve and I dont understand why it dont work.

Other Categories