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
[![enter image description here][1]][1] the highlighted column needs to be updated with value from other tables which are linked on the basis of value of column
I need to test something by changing the ft_stopword_file without restarting the server. I know that SET GLOBAL works to change global variables until the next
I am trying to install Mariadb on Debian but I am getting the error below when I try to install it. Mariadb was actually working for me for a while. I just tr
SELECT DISTINCT {c2.name} FROM {BrandCategory AS c JOIN CategoryProductRelation AS c2p ON {c.pk} = {c2p.source} JOIN Product AS p
For the past 3 days now I have been struggling with an issue with MySQL connector in C#. Basically, I follow the MySQLConnector tutorial to open my connection
I was working to make a crypto app but I have some issues displaying crypto pairs in UI. I've tried different ways but it's not working. Please can you suggest
DB::enableQueryLog(); $mines = Cranks::where([['crank_id', '=', $this->crank_id], ['mine_id', 'like', '%'.$script_value->mine_id.'%'] ])->get(); $query
The idea is I'm making a little restaurant app in Java so in this class is given the option to make an order. It works this way: the user writes which products