I need to create a frequency table that displays the revenue per bin. The bin has a range of 500. The code shown below almost do the work except it is displayin
Using MYSQL I am trying to get the avg amount spent by all the customers after determining the sum of what each customer spent. select customernumber, round(sum
According to MariaDB's website, you can simply replace MySQL with MariaDB. Great, I thought, however after installing MariaDB (10.5.7), some of my InnoDB tables
I am trying to code a website to work with ReactJS, NodeJs and MySQL. I have been using Sequelize and it works but i realised that it allows all usernames even
I try to import a CSV file in my database, I don't have any error but no rows are insert I checked my field name My table structure is: CREATE TABLE IF NOT E
I'm trying to create a linked server from my SQL Server to a MySQL db. No matter what I do, I get the following error: Cannot initialize the data source object
please help to solve one problem - I need to create after insert in table row with incremented value id number 1 inc1 2 inc2 I need to insert inc3 in number c
I am beginner in web dev and trying to create a Full stack project using Mysql Express React Node js. Facing this TypeError issue while using Sequalize with nod
Database Tables: The below tables contain the information about users and their licenses. Note: One user can have multiple licenses. users table Users( 'user_id
Here is my code. I am trying to use JUnit to test the deleteUsers() method, but everytime I write my test, it deletes all the users that I have in the database.
I'm working with MySQL for a while and also built an API in NodeJS including mySQL for work Basically i need a query like "SELECT * FROM table WHERE fieldA=varA
I know there are tons of question that includes that error, but I haven't seen one that incldues a subquery with row_numbers. Ok so I have this raw query which
I am using Laravel 8 and MySQL8. I have these tables: products id - integer name - string factories id - integer name - string factory_product
I have different tables like profiles, tournaments, tournamentdate, tournamentresult and pigeons. Profiles columns > ProfileId, Name, Address, etc. Tournamen
I'm working on a graph with a Satisfaction form with a database with jpgraph and I've encountered some issues with an handler error. This is my program: <?
Tables: Employee ( ID , Name ) EmployeeHours ( EmployeeID ,Date, Hours ) This is my requirement: Write a sql for following results for a year EmployeeI
I am using Amazon RDS MySql for data storage. I am able to load data by specifying the column values, however, when I try to load the data from my local machine
I'm working on a WordPress project with PHP & MySQL and I am using Tagify for create some tags. The trouble is that I want to have a dynamic whitelist based
I have query that use IN and OR in clause and cant manage to use index. Any ideas how to rework query to use index ? I tried with UNION as @ErgestBasha suggest
I am running some services in minikube and trying to connect to mysql running on localhost(127.0.0.1) on 3306 port. I read this and trying to create service a