sql tag

625 questions


1 answers
31 views
0
SQL: Implementing many-to-many relationships in

Hello.Node.js is developing an om, but I am asking you this question because there are some confusing parts. Do I need only two tables to make a many-to-many relationship? Or do I need three tables th...

sql
2 years ago

1 answers
48 views
0
Mr. Yeopto, I am uploading the result file.

Query 1Query 2 CREATE TABLE `Basic12MFW1D` ( `code` longtext, `name` longtext, `ChangeOP` double DEFAULT NULL, `ChangeNP` double DEFAULT NULL, `ChangeOPM` double DEFAULT NULL, `ChangeROE` double DEFAU...

2 years ago

1 answers
48 views
0
Postgresql I have a recent date inquiry question.

There are two tables./*article table*/article_code / article_company / article_name / article_standard / article_unit / article_qauntitya004 Sungsim Medical Device Disposable Injection 15cc 1 BOXa005 ...

2 years ago

1 answers
42 views
0
Change mysql real number type column to percent (%) type and output it

There is a table like the following picture in the table called Basic1WAbout row with year=2013, month=1, day=1 ChangeOP (1w) to Change Sales (1W) column expressed as a real number as % (0.11->11%)...

2 years ago

1 answers
121 views
0
I have a question regarding Python gspread + pymyql.

Hello, everyoneAfter accessing the DB using pymysql, I sent a query and found the result value I would like to update the Google spreadsheet through gspread.Currently, I can access the spreadsheet thr...

2 years ago

1 answers
43 views
0
MySQL: There is even fake data in the table, but there is a sync error.

Hello. After completing the table and data migration using javascriptorm, I entered the mysql shell and did desc <table name> because the query did not work. But ERROR 1064 (42000): You have an ...

2 years ago

2 answers
36 views
0
Python nontype operation

TypeError: unsupported operand type(s) for -: 'NoneType' and 'NoneType' If the nontype is included when Python specifies the operation, I want to return it as a NULL valueHow do I write code?For examp...

2 years ago

2 answers
53 views
0
Related to connecting to Amazon Web Services RDS (mysql) in Rails

First of all, what I know about Rails DB is that sqlite is used.Regarding DB, I felt like it would be overwhelming with sqlite after launching an actual service. Working with the Web Server-Applicatio...

2 years ago

1 answers
49 views
0
Set mysql Korean in Ubuntu

I installed mysql5.7 version in Ubuntu 16.04LTS.But now the Korean is broken, so I'm going to set it up in KoreanEntered vi /etc/mysql/my.cnf. Do you usually want to change from my.cnf to UTF-8?But wh...

2 years ago

1 answers
38 views
0
Calculate the number of mysqlows

What should I do to know the number of rows in mysql's table as the title says?

2 years ago
« - 49 - »

© 2024 OneMinuteCode. All rights reserved.