Category "mysql"

Character set "utf8mb4" error between migration from mysql 5.7 (ubuntu 16.04 LTS) to mysql 8.0 (Ubuntu 20.04 LTS)

I am having some problems I can't figure out. I have a database "DatabaseA" on mysql 5.7 (server A), which I would like to migrate to "DatabaseA" on myql 8.0 (s

Liquibase insert from old database into new schema

I have a database user with access to 2 schemas, oldDb and newDb and I want to select everything from oldDb.users table and insert them into newDb.users using L

PreparedStatement getMaxRows always returns 0

So i have a problem where i want to see how many rows there are in my database, after i've made an update. Im trying to use "GetMaxRows" but it always returns 0

Error mysql syntax use 'declare pfee int default null;',check the manual that corresponds to your MySQL server version

delimiter // create procedure payFees(in deviceid int, in fee int) begin declare pbalance int default null; declare ptype varchar(2) default ""; dec

Wordpress Multisite installation issue on staging website

I am trying to change my website into multisite on my staging server. When I add define('MULTISITE', true); in wp-config.php on my local machine setup, it works

How to delete a record depending on the following record

I have a table with the following columns Car | User | Location | Time | Type The type can be 'OUT' if the user's request to rent the car is accepted

Search in a non-existing table - relationship

I try to make hasMany relationship in Laravel and I have this problem. If I rename table name in Model to test, relationship works fine, seraching by my new tab

How to Join two tables and update a column?

I have two tables as below TableA TableB ID1 ID2 ID1 ID3 1 X 1 X 2 NULL 2 A 3 (NULL) 3

Saving multiple pictures for a website that will work like an ecommerce [duplicate]

I am developing a website that will work a little bit like ecommerce. It is a website where people will upload picture of items they want peop

How do I login to phpadmin on azure mysql in app

I am trying to migrate a local MySQL database to azure MySQL In App, when I click on Manage in the MySQL in App pane on portal.azure.com it takes me to phpadmin

Many to many relationship doesn't add new Entity into the table

I have two entities Book and BookTag. They are connect by many to many relationship. @Getter @Setter @Entity @NoArgsConstructor @AllArgsConstructor @Builder(toB

How do I login to phpadmin on azure mysql in app

I am trying to migrate a local MySQL database to azure MySQL In App, when I click on Manage in the MySQL in App pane on portal.azure.com it takes me to phpadmin

How can I insert a link in this SQL table

I am a complete n00b when it comes to SQL / Databases but I am trying to insert a link in the part that reads "Terms & Conditions" in the SQL entry below.

MySQL, count values by key

I need to count values on a table accordingly with their presence or missing. With a clear example consider a table with 2 field: +-------+---------+ | K |

MySQL pagination with limit returns the same values

I'm trying to do pagination, but the SQL query returns the same values on different pages. I show them the queries and the results, and it shows that there are

why does python3.6 container uses the /usr/lib of python 3.9

I start a docker contain with FROM python:3.6 ARG DEBIAN_FRONTEND=noninteractive RUN apt-get update RUN apt-get install -y apt-utils vim curl apache2 apache2-ut

Save data found from mysql to local variable [duplicate]

I'm trying to save the returned data from MySQL to a local variable, This is what I tried const queryUser = "SELECT * FROM Users WHERE email

MYSQL 8 running in WHM cPanel high CPU usage/crashing requiring mysql reset after 2 days

I have about 30 websites running Magento/Wordpress. Every 1-2 days I would need to reset mysql and then the CPU usage would be around 27% but then it'll slowly

Mysql, querying kopano / MAPI / PT_SYSTIME data

We had some problems with a corrupted Kopano / Zarafa database and needed to query appointments. Because it took some time to figure out how to get the date tim

Scrapy INSERT into "new_table" only if records do not exist in "current table"

I tried some website scrapping. I success scraped datas in my current db table. But I would like to INSERT into "new_table" only if records do not exist in "cur