sql tag

625 questions

3 answers
166 views
0

Which GUI application is best suited for Google Cloud SQL?

Google Cloud Platform > Cloud SQL > MySQL 2nd Generation Instancehas been created.The DB in this instance has my Mac and Microsoft Access (no MacOS version) or LibreOffice Base (There is a Mac v...

mysql google-apps-script google-cloud google-app-engine libreoffice

2 years ago

1 answers
49 views
0

I'd like to check the number of people born in 1991 and 1981.

Please find out how many celebrities were born in 1991 and 1981.However, do not use the date function, but use the UNION clause.SELECT COUNT(birth),SUBSTRING (birth, 1, 4) AS 'Year of Birth'from `cele...

mysql sql

2 years ago

1 answers
56 views
0

What is the difference between "separating access control by DB" and "separating access control by schema"?

This is PostgreSQL12.The PostgreSQL server uses AWS RDS.legend) User: SQL ExecutorGroup—Indicates the range of access.Assume there are DBs, schemas, and tables under the group.Group A: User 1, User 2G...

postgresql

2 years ago

1 answers
119 views
0

Understanding How to Extract Data Within a Specified Time Period: No matching signature for operator BETWEEN for argument types: TIMESTAMP, DATE, DATE

You want to specify a specific column (timestamp type) for the data table in a big query to extract only data within any period of time.·Satei_date is within 2 monthsThe query is listed as follows, bu...

sql google-bigquery

2 years ago

1 answers
129 views
0

Enter HTML in MySQL in Django (Save?)

I'm sorry to bother you at such a busy time.This is my first time to ask you a question.I was creating an application on Django this time, but When creating one page, save each HTML tag in MySQL and W...

html mysql python3 django

2 years ago

1 answers
54 views
0

Mysql.sock disappeared.

When I updated my Mac to High Sierra, the mysql.sock under /tmp disappeared.I thought it would be fixed after uninstalling and reinstalling, but the sock file was not generated.That's why I can't use ...

mysql macos

2 years ago

1 answers
156 views
0

Want to know how to implement best practices for accessing split tables in Spring Data JPA

For example, a user table with user informationuser_0, user_1, user_2, user_3 (when userId is divided by 4, the remainder follows the table name) I would like to know how to implement without having t...

mysql spring spring-boot database jpa

2 years ago

1 answers
103 views
0

Why do rails use datetime instead of timestamp for created_at?

Rails ActiveRecord creates a datetime type on the DB for columns created_at and updated_at that are introduced in migration with t.timestamps at least in MySQL.The datetime type is close to storing th...

ruby-on-rails mysql rails-activerecord

2 years ago

1 answers
53 views
0

MySQL Workbench Cannot Connect to DB

I recently started using MySQL Workbench.I've been using it for a long time, but when I tried to start it today (2022/6/22), I got the following error.I tried the following.Add C: WindowsWindows SySys...

mysql mysql-workbench

2 years ago

1 answers
68 views
0

Understanding Date Aggregation by sql

I use postgresql.in SQL using two tables: A (date, month, quantity), B (start date, end date)select sum (quantity) as total group by month is the formula I would like to exclude the quantity between t...

sql postgresql

2 years ago

- 14 -

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