409 questions
There is a point of blockage while working with mysql. Our company's DB status is... There are dozens of the same data in a field in the table.What I want to do is to specify and update only one data ...
In the IT development process of the six-month state-funded course Today, we've started a new journey with a book called Oracle SQL and PL/SQL, which are easy to learn with a variety of examples.There...
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...
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%)...
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...
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 ...
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...
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...
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...
What should I do to know the number of rows in mysql's table as the title says?
| « | - 32 - | » |
© 2024 OneMinuteCode. All rights reserved.