sql tag

625 questions


1 answers
497 views
0
How to Get Two Types of Data in the Same Column

I would like to get data similar to the ideal execution result from the teiki_oyaprod_cd value in the table teikiideal execution resultsmeisai is teikimeisai.meisai_no and NULL for set child informati...

2 years ago

1 answers
465 views
0
MySQL crashed

I am using MySQL installed from Homebrew on my Mac.When I tried to launch MySQL, ERROR!The server quit without updating PID file(/usr/local/var/mysql/****.pid).failed to boot with the boot.For /usr/lo...

2 years ago

1 answers
467 views
0
I do not understand why the group method is not available.

Sorry for the rudimentary question.Connection.group(:user_id) causes Object doesn't support #inspect.Ruby 3.1.0Ruby on Rails 6.1.4 modelclass User<ApplicationRecord has_many —connectionsendclass Co...

2 years ago

1 answers
379 views
0
WH clause (CTE) in MariaDB in Docker for Windows environment error

SQL statements using WITH clauses fail for MariaDB in the Docker for Windows environment.For example, SELECT* FROM table01;↑ This is OK, but WITH t01 AS (SELECT* FROM table01)SELECT* FROM t01;Doing so...

2 years ago

1 answers
258 views
0
I don't know what count(*) is doing when using group by and having.

I don't know the count(*) when I ran this SQL.select name from usersgroup by belonghaving count(*)>=2The tables and data are as follows.create table users( id int, name varchar(60), belong int);ins...

sql
2 years ago

1 answers
263 views
0
Want to separate data sources by user within multi-tenant services

I plan to develop a multi-tenant service.It is assumed that each user (service user) will have a direct reference to the database of this service from an external system.We want to separate data sourc...

2 years ago

1 answers
439 views
0
Unable to create database using db.create_all()

Using the video as a reference, create the following code (app.py) in the web application development course for todolist using Python.>>>from app import db>>>db.create_all()I would ...


1 answers
437 views
0
FOREIGN_KEY constraint error when attempting to ETL s3 data to rds in embulk

When I try to ETL the data of s3 to rds in embulk, I get a FOREIGN_KEY constraint error.Specifically, the error is as follows:java.lang.RuntimeException: com.mysql.jdbc.exception.jdbc4.MySQLIntegrityC...

2 years ago

1 answers
439 views
0
Please tell me what to do when the mysql container does not stand up in docker-compose.

Developing web applications running in rails+mysql environment My PC is an m1 chip macbook, but the mysql container doesn't stand up, so I checked the cause and found out that if you want to use mysql...


1 answers
382 views
0
Spring boot partial match search I don't know what's wrong

The previous question worked well, so I tried to change the table and run it, but it didn't work.What is the cause?package com.example.demo.mysql;import javax.persistence.Column;import javax.persisten...

2 years ago
« - 3 - »

© 2024 OneMinuteCode. All rights reserved.