sql tag

625 questions


1 answers
98 views
0
Mysql container goes into exit(1) immediately after startup in Docker

PrerequisitesI'm trying to launch a laravel environment with docker-compose, but the container in mysql will be exited(1) as soon as it starts.It started up until about 3 days ago, but suddenly it did...


2 answers
62 views
0
I want to return only the first value of duplicate records when I join, and NULL after the second value.

There are three tables as followsI would like to join these three and get the following results, but I don't know how to do itWhen I do OUTER JOIN, I get duplicate records, but I want to return only o...

2 years ago

2 answers
41 views
0
I want to check if there is a 5-digit sequence in the 6-8 digit sequence.

This is my first time asking a question.Currently, Python+SQL replaces the formula written in Excel and displays it in PHP.I'm working on a project.(I'm aiming to get out of Excel) I got caught in the...

2 years ago

1 answers
45 views
0
Changing the MySQL Table Character Code for Tables That Always Have Updates

MySQL default character code during production has been found to be different from before.I would like to modify the character code of the table created during that timeMost of the tables could be mod...

2 years ago

1 answers
121 views
0
libmysqlclient load error when deploying with Capistrano

When I was deploying Rails in AWS, there was a heading error, so I looked at articles online, but I couldn't solve it.Also, I am planning to deploy Capistrano 3.ruby-vruby 2.2.3p173LoadError: /usr/lib...


1 answers
88 views
0
I want to prevent SQL from deleting comment statements on the c file created by pro*c precompilation

pro*c is used to develop a business application that handles Oracle databases, but if you write the SQL portion embedded with comments (bound by /* to */) in the pc file and precompile it.For example,...

2 years ago

1 answers
32 views
0
View SQL in HTML [Closed]

Do you want to improve this question?Edit your post to clarify the issue you are trying to resolve by adding details.Closed 2 years ago.Two years agoI can't connect to sql from html everywhere I lookA...

2 years ago

1 answers
52 views
0
About Locking Postgresql Backup

Hello, I do backup every day at work, but I heard that backup is the lowest access share mode.If it's backup, I think it's pg_dump or pg_dumpall, but I can't find it when I look for documents online.I...

2 years ago

1 answers
48 views
0
I want only certain users to have access to the new table.

To allow only certain users to access the table, should I do identified by' when I do create table? Or should I do grant later?

2 years ago

2 answers
62 views
0
How to configure after insert update trigger in Mysql.

Thank you for your help.Could you give me some guidance and advice?I created a trigger in mysql to start immediately after the data is inserted into tbl_products, but it does not start when I insert t...

2 years ago
« - 41 - »

© 2024 OneMinuteCode. All rights reserved.