sql tag

625 questions

1 answers
30 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...

mysql

2 years ago

1 answers
34 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?

python mysql

2 years ago

2 answers
112 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 ...

database mysql mariadb

2 years ago

2 answers
108 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 ...

python orm flask postgresql

2 years ago

1 answers
36 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...

php mysql

2 years ago

1 answers
33 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...

python mysql

2 years ago

1 answers
31 views
0

Questions related to mysql query.

mysql sql

2 years ago

2 answers
36 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 ...

mysql

2 years ago

1 answers
57 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)

python pandas sql dataframe

2 years ago

1 answers
108 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...

oracle mysql dbms

2 years ago

- 48 -

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