sql tag

625 questions

1 answers
83 views
0

ID extraction across mysql work data dates

The following data is available:USER_NAME,ID,START_TIME,END_TIMEAAAA, 1, 2017/8/99:00, 2017/8/918:00AAAA, 5, 2017/8/9 12:00, 2017/8/9 13:00BBBB, 2, 2017/8/9 22:00, 2017/8/1000:00BBBB, 2, 2017/8/1000:0...

mysql

2 years ago

1 answers
90 views
0

Understanding PostgresqlDB Persistence on Docker

I am having trouble mounting the PostgreSQL server directory created by Docker on the host.Docker is trying to create a database container using PostgreSQL.to perpetuate data using the postgres formul...

postgresql docker

2 years ago

3 answers
43 views
0

What is the meaning of LIKE or _% used in SELECT statements?

The following formula is used for the conditions after WHERE:As an example, there is no explanation for the SELECT statement, so I don't know the meaning of the expression and how to interpret it in t...

sql

2 years ago

1 answers
131 views
0

Mysql2::Error (Access denied for user'b00120fa21c0f6'@'ip-10-139-25-93.ec2.internal' (using password: YES)) :

EnvironmentherokuClearDB MySQL I'm running the Rails app with Heroku, but while I was working on it, We're sorry, but something wrong. and the app stopped working.When I looked at the Heroku log, I fo...

ruby-on-rails mysql heroku

2 years ago

1 answers
98 views
0

I want to convert ROW_NUMBER()OVER(PARTION BY) to LINQ.

Thank you for always taking care of me.I want to get the same results as the SQL below on LINQ, but I'm struggling because I can't meet my expectations.I tried to create it based on the information he...

c# sql linq

2 years ago

2 answers
103 views
0

Questions for Error 1040 in MySQL

I would like to ask you a question to help me solve mySQL problem.I will write down the current symptoms first, and then write down how I handled it in my own way.Finally, I would appreciate it if you...

mysql

2 years ago

1 answers
93 views
0

Inserting the utf-8 string in psycopg2 in python3 causes garbled characters

If you insert a Japanese string of utf-8 into a column with type text in psycopg2 on python3, it becomes garbled.What should I do?The database encoding is UTF8If you insert from psql, there will be no...

python postgresql

2 years ago

1 answers
101 views
0

Confirmation of registered email address when completing registration form

When I create a registration form in HTML, I would like to display That email address is already registered in the MySQL database on the form, but what should I do?

html mysql

2 years ago

1 answers
149 views
0

Understanding PHP MySQL Prepared Statements Security

I made the following prepaid statement.id:int type, name:varcher type, area:int type.Assume area is a number from 1 to 10 that represents the position where you live.For example, 1=Kanto, 2=Kansai, 3=...

php mysql security

2 years ago

1 answers
103 views
0

partial match search for integer fields

I would like to write a SELECT statement that considers an integer field (the range of values is 0 to 99) to be a string and searches for a partial match.For example, if you specify 7, 17 or 73 will b...

sql postgresql sql-server oracle

2 years ago

- 9 -

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