mysql tag

409 questions

2 answers
87 views
0

Design to register random regular holidays

I'm making data on the tourist attraction list, but I'm having trouble setting up regular holidays.Specifically close_mon~close_sunI have prepared the columns in and judge them by 0,1, but depending o...

mysql database-design

2 years ago

3 answers
136 views
0

Understanding Database Design

I'm worried about designing the database.For example, create a database for user information.usersidnameIf you want this to be gender, usersidnamesex_idsexesidnameI think this is fine, but for example...

mysql database-design

2 years ago

1 answers
89 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

2 years ago

2 answers
56 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

2 years ago

2 answers
34 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

2 years ago

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

2 years ago

1 answers
112 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

2 years ago

1 answers
42 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

2 years ago

2 answers
56 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

2 years ago

2 answers
45 views
0

Update/delete table contents from Android to mySQL

How do I delete tables from mySQL DB on Android??I don't know about SQL at all, so I'm only looking at Android booksCreate DB, create table, add contents What did you do with execSQL?I don't know how ...

mysql android

2 years ago

- 26 -

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