79 questions
from the combination table belowI would like to create SQL to delete the one with the same group ID as the A number.I created SQL to extract, but I can't create SQL to delete.I'd appreciate it if you ...
Do you want to improve this question?Edit this post and update the question to focus on one issueClosed 3 years ago.Three years agoI would like to create a program like the one below.1. You must be ab...
I am creating a blog project in Django 2.0.The database was changed from the default SClite3 to PostgreSQL and deployed to Heroku.As I can no longer log in from the management screen on the Heroku sit...
https://github.com/blobmon/simplechanI installed the bulletin board above on the Internet, but the home screen is displayed, but when I click on it and enter it, it doesn't show what should be display...
https://github.com/blobmon/simplechanAfter completing the above site and entering the database to change the name of board1 displayed on the site to Anime&Manga, simplech_db-# update boards set bo...
https://github.com/blobmon/simplechanI want to enter the database as a user, but I can't.Now, once you are back again being the normal, default user, cd into /sql/ directory in Simplechan repository.W...
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...
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...
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...
I would like to create a complete list based on incomplete list information in PostgreSQL. Is there a good way?The following tables are available: CREATE TABLE abscissa( a_id TEXT o_id_list TEXT[]);US...
| « | - 2 - | » |
© 2024 OneMinuteCode. All rights reserved.