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
[![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