sql tag

625 questions


1 answers
37 views
0
[MySQL] Whether it's better to consolidate sub-tables with the same structure into one or give them to each parent table

For example, there is a posts table and a users table, and there is a likes table and a bookmarks table. Both likes and bookmarks have FK keys of the top table posts and usersIf you leave only one lik...

2 years ago

1 answers
42 views
0
I am attaching a code debug error message that attaches the excel file below to mysql workbench using python.

The code was slightly modified and executed.The table exportimport201006 is in the created state.I'm trying to put a value in this table, but the following error appears.How do we solve this?

2 years ago

2 answers
123 views
0
DB Design Question. (BLOB)

When designing the db, I want to insert the Python code in blob type. I have a lot on my mind.I'm worried if this is efficient. Is it right to put it in considering translation and integrity?Or is it ...

2 years ago

2 answers
118 views
0
Python, I want to know how to remove the table name when loading SQL data.

The values of the table named Student currently in PostgreSQL (DB) using flasqlAlchemy in Python.session.They're calling me query.When a value is called, the table name and attribute name are grouped ...

2 years ago

1 answers
43 views
0
Check for presence of phpsql data (using PDO)

Hello, I'm a Php beginner.Using PHP Data Object, if there is a user with a specific name in the user table, I want to print out that the user is present or not, so I want to print out a message that t...

2 years ago

1 answers
40 views
0
Python mysql error

import pandas as pd import openpyxl import pymysql NP0 = pd.read_excel('c:/Temp/ChangeNP.xlsx', sheet_name = str(2011)+str(1)+'Q') Code=NP0.iloc[5:,0] Name=NP0.iloc[5:,1] for index in range(1,34): yea...

2 years ago

1 answers
39 views
0
Questions related to mysql query.

DB is using mysql but I'm a beginner at SQL so I don't know how to organize the query.First of all, there are three tables.useruid | int thingcid | intuid | intcontent | varcharmarkmid | intcid | intu...

2 years ago

2 answers
44 views
0
About mysql (question is easy) Please stop by

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 ...

2 years ago

1 answers
65 views
0
I have a question for Python Pandas (if you can use sql, please let me know)(Crying)

Let's say there's a data frame like thisHow do I extract more than one value from the column Alphabet?(c, d, e have only one value, so include X)

2 years ago

1 answers
128 views
0
Is Oracle different from Oracle's MySQL?

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...

2 years ago
« - 48 - »

© 2024 OneMinuteCode. All rights reserved.