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,
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
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
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:
(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
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
I have an Azure DataFactory copy task set up to copy employee data from a MySQL database to a SQL Server database. The data copies over fine except for the fac
I've been trying for awhile to set id (primary key) for my Users table as UUID. However, I keep getting this error: Field 'id' doesn't have a default value, whe
Hello I'm currently trying to create a page based on a database under mysql that would update itself for a client. However what I'm trying to
I was trying to export my database from phpmyadmin but it said in the browser couldn't upload a file when I tried again and it loaded to an HTML file. index.php
Below is the existing T-SQL code which generates table data in JSON format just by using the keyword FOR JSON PATH, include_null_value. How to implement the sam
I need to write a code where i need to populate a dropdown1 from mysql table based on the selection of another dropdown which also where in need to give values
I am using Mysql 8.0, and something strange happened. I set the 'autoid' as primary key, and a group of keys as unique keys. SHOW CERATE TABLE below I use the
I am working with the employees table in SQL and I would like to fetch the data for max count of employees SELECT (COUNT(emp_no)) AS emp_count, dept_no FROM de
We have recently migrated our application to a new server. Since our migration we are experiencing a lot of PHP message: PHP Fatal error: Call to undefined meth
I have a server in google cloud with Ubuntu 18. I have installed WordPress. It was working fine. But suddenly, this screen is shown SCREENSHOT / IMAGE Any help/
I wrote the code bellow. It works on a .py file on my computer but not while running on Google Colab) import mysql import mysql.connector as msql from mysql.con
let absent_remove = result_database.filter(item => item.absentday != absent_days) console.log("absent_remove", absent_remove); I got this piece of code, I h
Hi I am trying to figure out why hackerrank is returning a syntax error on my query ran on their platform but when I run the same query I get no issues on mysql
has anyone been able to get Rails running with the MySQL via the mysql2 gem on Apple Silicon? I'm working with Ruby 2.5.3 and Rails 5.2.3 but would love to hea