sql tag

625 questions

2 answers
89 views
0

I have a question about My SQL.

Hi, everyone. I'm inquiring about the MySQL query statement.Not a web developer, but a bit weak in query statements.In the program you are developing now, you need to find out how many columns you hav...

mysql query-string column

2 years ago

1 answers
50 views
0

Extracting dates from timestamp in postgresql

I am using postgresql. There is a timestamp type column and an id column.I want to extract it like this. select date, count(distinct(id)) from table group by dateHow do I get the date when I want to u...

postgresql

2 years ago

1 answers
39 views
0

[mysql] Import data by selecting only specific column values

Hi, how are you?I'm implementing a web page using node As above, I want to select a record when it is a data value called health common sense in a column called categoryI'm not sure which way to choos...

mysql

2 years ago

1 answers
37 views
0

I'm trying to use the database in winform

I already installed sql in visual studio 2017 installer. But the book I'm reading now has a new version of Microsoft Sql Server ExpressCan I use it separately?

c# sql

2 years ago

1 answers
45 views
0

Attempt to multi-render mysql table in node.js...

Hi, how are you?I'm trying to load one sql table and one more in the page called readI just don't know how.The coding is as follows.router.get('/read/:idx',function(req,res,next) {var idx = req.params...

node.js mysql

2 years ago

1 answers
76 views
0

Please help me write a SQL statementㅜ

MYINFOID(PK)/CmpID(FK)/NAME/POSITION/PhoneNumber0/1 / Hong Gil-dong 1 / Employee / 010-1234-5678 1/ 1 / Hong Gil-dong 2 / Temple / 010-1234-5678 2/2 / Hong Gil-dong 3 / Temple / 010-1234-5678 3/3 / Ho...

database sql join

2 years ago

1 answers
108 views
0

Is there a way to ignore mysql ER_DATA_TOO_LONG?

Mysql server has been newly installed.In the past, I used it without any problems, but on the new server, ER_DATA_TOO_LONG error when inserting into mysql.In the old server, things that go over the nu...

mysql er_data_too_long

2 years ago

1 answers
36 views
0

I'd like to inquire about MySQL query speed 2.

A table consisting of 4 million rows is indexed as follows.index 1 to 2000: Company 1 to Company 2000 January 1, 2013 information index 2001-4000: Company 1 to Company 2000 January 2, 2013 information...

r mysql

2 years ago

1 answers
151 views
0

[Database] I want to create a new table with two different tables and add a property (vertical) value.

I have extracted only the necessary attribute values from the table A and the table B (extracted by Join I would like to make a table by adding extraction as join + new name/other to the new C table.-...

database sql join table postgresql

2 years ago

1 answers
47 views
0

django and character set

Hi, everyone.When deleting data from django, in the column in Korean, (1366, Incorrect string value: '\\xED\\x85\\x8C\\xEC\\x8A\\xA4...' for column 'object_repr' at row 1)An error occurs. Mysql's DB a...

django python mysql

2 years ago

- 57 -

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