Category "mysql"

How do I insert text into MySQL with Julia?

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

Why Hibernate cant create DB? SQLSyntaxErrorException and CommandAcceptanceException

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

workbench Import dump Mysql loading forever and not processing

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

Using mysql in github workflow always leads to SQLSTATE[HY000] [1045] Access denied for user error

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

SQL FOREIGN KEY ERROR (errno: 150 "Foreign key constraint is incorrectly formed")

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

Can i have a one to many from a select case statement?

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

Object reference not set to an instance of an object on mySQL Installer while configuring mySQL Server 8.0.25

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

MYSQL workbench 8 Migration wizard error "SystemError: TypeError("'>' not supported between instances of 'NoneType' and 'int'")"

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

Subtracting rows based on condition

Suppose I have a table that looks like this: OrderNumber OrderType 1 D 1 D 1 R 2 D 2

Error when trying to use count and group by

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

SQL: What am I doing wrong? adding / sum returns null

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

Mysql 8.0.29 installation failed

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

java.sql.SQLException: Column 'serialnumber' not found. (spring boot)

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

MySQL How to join 2 tables and get a combined response

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",

First time SQL query is taking More time from Spring Boot application

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

Mysql 8.0 Not supports ST_POINTFROMWKB Any Alter Native?

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

SQL returning all rows and count

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

MYSQL query that works out the total amount of days between different time periods for a payroll

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

Relating Wordpress posts to a particular time of the year

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

Best way to get list of element combinations from two mysql tables

I have two tables: Table "products" ID Name Price Quantity 1 Product A 10 10 2 Product B 20 10 Table "promotions" ID Product ID Type Price Quantity 1 1 disco