I have a question in term of my database courses, hope that you can help me. The table bellow is an exemple: +------------------------------------+ |ID_EMPLOYEE
I'm struggling to get text from an input file into MySQL with Julia. Using this code: using CSV using MySQL conn = DBInterface.connect(MySQL.Connection, "local
I have three DBs, of which hibernate can only create 2/3. Can someone explain why hibernate can not create a third table "goods" 1: org.hibernate.tool.schema.sp
I'm trying to migrate from a dump to a base in OceanDigital, and I'm having the following problem: the dump keeps loading forever without any signal that it's p
Im currently configuring a CI pipe for my laravel project via github actions. This is my build.yml file # GitHub Action for Laravel with MySQL and Redis name: A
Hi I have this three very simple tables but I can't fix it to get the right format of foreign key. CREATE TABLE company( company_name varchar(30) UNIQUE NOT NUL
I have two tables that I'm working on for a project at work. The first table (crm_users) has id, username and 16 fields that start with "state_license_" with a
I recently deleted mySQL and now when i am trying to reinstall it is giving me an error while configuring the mySQL Server i have tried deleting everything from
I've been trying to migrate a PSQL (v13.4) database to MySQL (8.0.26) with the Migration wizard tool from Mysql Workbench. I've had to change some code from "db
Suppose I have a table that looks like this: OrderNumber OrderType 1 D 1 D 1 R 2 D 2
Here is my query: SELECT DISTINCT takes.semester, takes.sec_id, takes.course_id, instructor.name, COUNT(takes.ID) FROM takes INNER JOIN teaches ON takes.cour
Totally MySQL newbie here. I'm a network systems management student and I have a problem with one of the exercises. The exercise asks to create a function that
The installation failed at this point I have already installed Microsoft Visual Studio c++ 2019. I already uninstalled and delete all the hidden folders. I rea
I am writing to-do list web app with spring boot. I Have 2 entities: User (fields: userid (ID), username, password Item (fields: serialnumber (ID), task, userid
I have 2 tables projects and images. My goal is to get all images of a project and get this kind of response. { "data": { "id": "this is project id",
I have to fetch some records and then display in output. In my Spring Boot Application, I am using JPA Specification for creating Criteria and then calling repo
SELECT * from ip2loc.netacuity as IP where MBRCONTAINS(IP.ip_poly,ST_POINTFROMWKB(POINT(2925896821,0))) [SQL] SELECT * from ip2loc.netacuity as IP where MBRCO
I have 3 tables, Property managers, Addresses and Units. I'm trying to get all the rows using the aggregate function COUNT, but it only returns 1 row. I want to
I know this question may seem like a simple one and might have been asked before but what makes this tricky is how do I work out the total days for a payroll. N
I have a 'diary' type blog in which I want to highlight all the posts made around the current day and month, regardless of the year. You could say they need to