Questions tagged [mysql]

MySQL is a free, open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. Those are different DBs that all use their own dialects of SQL to manage the data.

-3 votes
1 answer
10 views

Get All Rows When Variable Empty PHP Mysql

$frame_type = ''; $ret = mysqli_query($con, "select * from products where status='1' AND frame_type = '$frame_type' "); while ($row = mysqli_fetch_array($ret)) { $emparray[] = $...
user avatar
0 votes
0 answers
9 views

Mysql multi join or subquery category product main image

I have 3 tables and I would like to get all published product from a category with main image (thumb_name of the image). I need all products, but sometimes the image is missing. There are more images ...
user avatar
  • 1
-1 votes
0 answers
9 views

Rabdom list in a pwa

I have to implement a program that must show a random list of actions to put in a right order to make coffee. Should i start a spring project with mysql? Do I need to create a table with the actions?
user avatar
0 votes
0 answers
7 views

Error while applying configuration for mysql server 8.0.30

Mysql server configuration error
user avatar
0 votes
0 answers
24 views

How to read higher size DB from MySQL using Polars and ConnectoX?

I'm new to Polars. I'm trying to get data from MySQL using polars for one of my project. here I have made a connection and trying to retrieve some sample data from a table. on executing this query it ...
user avatar
0 votes
0 answers
13 views

Creating dynamic table name in MySQL based on the date and time using Python

I am going to create dynamic table name based on the date time function in MySQL using Python. I would like to use datetime function,to name the tables, when I run my code. however, it does not work. ...
user avatar
0 votes
0 answers
13 views

Node.js "Error: connect ECONNREFUSED 127.0.0.1:3306" when trying to connect to MySQL database

I'm a novice at node.js and I want to create an API which sends data to a MySQL server to store them. I followed a youtube tutorial to create a connection with a MySQL database, also checked other ...
user avatar
  • 1
0 votes
0 answers
9 views

PHP - Dynamic URLs using database values of geographical locations

Just getting the hang of custom database tables etc. This is a 2 part question. I am using WordPress (a requirement for my project) and am in the process of creating a directory listing website based ...
user avatar
0 votes
0 answers
15 views

Beginner SQL / Dune Analytics

I've been playing around with Dune Analytics but can't seem to get this to work! I've managed to filter a wallet to display the transactions showing the number of tokens sold and the corresponding BNB ...
user avatar
0 votes
0 answers
9 views

FLASK- Sqlalchemy: How to get multiple records from a table as one array object

I have 3 tables Products,Categories and ProductCategories. A Product can have multiple categories. I would like to fetch all the products and get associated category_ids and category_names in a ...
user avatar
  • 91
0 votes
0 answers
18 views

input type hidden does'nt post

I have a system where people can indicate whether they are attending an event. There are several events to choose from. The events come from the database and have a unique id. Everything works fine, ...
user avatar
1 vote
0 answers
38 views

How to send data from POST to Database with JSON

For my work I'm currently creating a schedular. The schedule looks good and has the info on th right place on the website. The editor of the schedule looks fine, with getting the data. I am working ...
user avatar
  • 21
2 votes
0 answers
12 views

Acessing MySQL DB in a container from the host machine

I have a MySQL DB running in a docker container. It has the 3306 port, the user root and host mysql. I now want to access this database via the MySQL workbench which is locally installed on my ...
user avatar
  • 31
0 votes
1 answer
28 views

Query is very slow, can i combine or optimized this

Good day, I have a query that takes a long time and I can't figure out how to optimize it. SELECT a.*, (SELECT COUNT(*) FROM sp_produkte WHERE bemerkung = '9' AND ...
user avatar
-9 votes
0 answers
15 views

Dialler number should be disappeared [closed]

I want to make appear some text like "BD customer" on caller mobile when we make a call to customer through app and after completing a call numbers will automatically delete from history,so ...
user avatar

15 30 50 per page
1
2 3 4 5
43344