# Create a script that returns the quantity of customers attended by each employee.
# Add the employee’s data on the script.
I wanna count in my northwind database how many customers have been attended by a employee, but I cant find a so…
if I am searching record by phone without ClinicName, MySQL throws an error same as vice versa, if a search by clinicName without phoneNo.
Here is the query I am using :
SELECT UL.Id,IFNULL(UL.FirstName, ”) AS FirstName,
IFNULL(UL…
Having some issues joining tables. I think my syntax is wrong due to having to call the column names with “ I think it should be an easy fix. When I call it gives me an error code 1052. Column ‘Brand.Name’ in field is ambiguous.
select a….
Should I use Redis Pub/Sub or Redis Stream to solve the following problem?
Each device has its own MYSQL database
Each database need to be synced up between each other
Consider there are some cases of
At some time, more than one devices…
Is there a more efficient way to filter on a joined table as in the following example? Or is this a fine approach? This query returns the desired results, but I am an amateur at MySQL.
I have indexes on products.id, product_details.product…
I have a Django application. Sometimes in production I get an error when uploading data that one of the values is too long. It would be very helpful for debugging if I could see which value was the one that went over the limit. Can I confi…
I am searching for a way to update my sql database without refreshing the page by selecting the checkbox.
I am trying to achieve the id to be passed to the dolead.php when the user selects the checkbox and than check whether the id is high…
For a given URL, I need to find a list of other URLs it is allowed to reference, by returning a list of the highest scored unique URLs.
I have a pages table of URLs and the categories they’re associated with. I’m joining it with ITSELF usi…
I have an
employee table
customer table
credit table
In my design should I create a manytomany join in employee and customer or create an emplye_id and client_id column in the credit table?
knowing that the customer and employee table a…
I want to create a dashboard for my webpage that can post data like videos, photos, paragraphs, etc. But the problem is that I don’t know what is the most neutral or easiest way, first I thought with PHP and MySQL.
Can anybody tell me how can I link two containers such that from HTML pages hosted
by the HTTP server, you can enter data into a Mysql table managed by the MySQL-server in docker? I’ve searched many websites but stuck with lots of undesire…
I would like to convert the pandas/python code below to a Mysql UDF/procedure function. Can you please provide suggestions or point me to any code? The code conversion is for performance reasons.
I have a pandas data frame that need to be …
I have a table with a date column and a string column. I’m trying to filter the string column to the most recent 3 records.
+———-+————–+
| date | string |
+———-+————–+
|2000-11-14| AAA|
|20…
I’m try to delete the row with nulls but the query has no effect. What might be causing the query to not work?
In my company we use a leaderboard to show the performance of our sales agents. The leaderboard now only contains the amount of sales made of certain periods (today, this week and this month). Now I want to expand the leaderboard by adding…
I have a MySQL database shown on the picture MySQL tables
I want to create a week plan of meals (lunch&dinner) where each week there is at least 1 meal of specific type. For example:
Monday: Lunch – Meal with chicken meat and potatoes,…
I have a exercise_logs table with these columns:
user_id | exercise_name | mood_log_id | weight_log_id | stretch_log_id
I have three tables (mood_logs, weight_logs and stretch_logs) whose primary key is stored in the 3 last three respectiv…
I am learning python….I am trying to load a csv file into mysql.
I am getting the below error. can someone please help?
ordinal code:
import csv
import sqlalchemy
NULL_FIELD_VALUE = r’\N’
file_name = "C:/105AML11232…
I have a table which includes an IP address:
create table login_history
(
id int auto_increment primary key,
ip int unsigned,
created datetime(6) not null,
user_id int unsigned not null,
);
and anoth…
Table contents:
+—-+———+———–+
| id | title | author |
+—-+———+———–+
| 1 | book_1 | author_1 |
| 2 | book_2 | author_2 |
| 3 | book_3 | author_3 |
+—-+———+———–+
id – is UNIQUE and …