mysql tag

409 questions


1 answers
156 views
0
Bring 4 limit each by combining the various filter conditions of sqlalchemy sentence???

ended_94 = db.session.query(Ended_event).filter(Ended_event.league_id == 94).order_by(Ended_event.time.desc()).limit(4)ended_99 = db.session.query(Ended_event).filter(Ended_event.league_id == 99).orde...

2 years ago

1 answers
36 views
0
Search MySQL Bulletin

Hello, I'm a student implementing a bulletin board search.When writing implements pagenation on the current bulletin board at more than 1 million rows, The number of pages is calculated by using a sep...

2 years ago

1 answers
157 views
0
ORM: Sequelize: I want to change mySQL query to Sequelize.js query.

A query is a self-joined sentence with one table as follows:SELECT cat.cat_id, cat.cat_name, sub_cat.cat_id, sub_cat.cat_nameFROM Categories AS catLEFT JOIN Categories AS sub_catON sub_cat.parent = ca...


1 answers
39 views
0
How to connect MySQL databases in Python

Please tell me how to access the MySQL database using the Python program.

2 years ago

1 answers
118 views
0
Real-time App Server Implementation

Hello, everyone We are implementing app programming that shows the waiting time and number of people at a restaurant in real time. As far as I know, database, server, app exists, so when data comes in...


1 answers
38 views
0
mysql How do I delete multiple data from one table at once?

tbl_member I'm trying to delete 2 members at the same time from the table, but I keep getting errorsI got 2 id values delete from tbl_member where userid in (user30,user20) ordelete from tbl_member wh...

2 years ago

1 answers
35 views
0
Number of mysql columns

Hi, everyone. I am currently designing a DBThe number of columns in a table is likely to easily exceed 400.As far as I know, the number of max columns is thousands, so I don't think it'll matterWhat a...

2 years ago

1 answers
134 views
0
MYSQL MAX batch value is slow

Hello, how are you?I'm white-headed to be in charge of my own MYSQL + Apache application server in a small company without any IT staff, especially Infra. ㅜ

2 years ago

1 answers
47 views
0
Refresh Android Studio

I'm making a simple soccer-related application.I want to make a team management page in the league, but after saving the results of web crawling in Python to mysql Using php language, spray it on the ...

2 years ago

2 answers
40 views
0
I want to select node.js from mysql and then use the data I gotㅜㅜ

var results=[]; // Empty array for resultsconnection.query('SELECT * from img_result_tb', function(err, rows, fields) {if (!err){ for(var i=0; i<6;i++){ results.push(rows[i].resultId); // get only...

2 years ago
« - 34 - »

© 2024 OneMinuteCode. All rights reserved.