sql tag

625 questions

1 answers
87 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...

mysql docker docker-compose docker-for-mac

1 years ago

2 answers
54 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...

mysql sql

1 years ago

2 answers
32 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...

python mysql sql

1 years ago

1 answers
38 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...

mysql

1 years ago

1 answers
109 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...

ruby-on-rails mysql deployment capistrano

1 years ago

1 answers
79 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,...

c sql oracle

1 years ago

1 answers
26 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...

html sql

1 years ago

1 answers
44 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...

postgresql

1 years ago

1 answers
40 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?

mysql

1 years ago

2 answers
54 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...

mysql

1 years ago

- 41 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656