Category "mysql"

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

How to render a .sql file with parameters in MySqlOperator in Airflow?

I need help in passing parameters (xcom pushed from previous task), to a SQL query in a .sql file. However, I am unable to do so using the "parameters" option,

insert zk log check in and out to one row in database

I am retrieving data from ZK attendance device using zkteco-sdk-php. The out come is like this UID ID NAME STATE DATE TIME TYPE 55 275 Employ1 Fingerprint 19-0

MySQL Create View with Sequence Numbers for Each Group

I've seen a similar solution on this site but it's not usable in a view due to variable use limitations: Generating Sequence for Each Group in MySQL A table s

Laravel Migrate: "Column Already Exists" 1060 Duplicate Column Name

This is a fresh laravel app that I am using to learn. There is no current table as this would be a fresh/first time migration. Why is it giving me this error:

i have created some sql queries for mysql php my admin but i still have doubts

(1) Use GROUP BY and NATURAL JOIN to show the lecturer names and the number of courses taught by each lecturer. (11) Use GROUP BY to show the course IDs, course

Where Condition on google auto complete address

I have a home search table with have a city column which can have multiple cities like "Avignon, France|Nantes, France|". Addresses are "|" separated. There's a