sql tag

625 questions


1 answers
37 views
0
It works with Android SQLite, but it doesn't run during Run.

---------- error log portion. I've copied and pasted only the suspected cause ---------FATAL EXCEPTION: mainProcess: com.example.karry.autocompleted, PID: 1707java.lang.RuntimeException: Unable to ins...

2 years ago

2 answers
81 views
0
Is there a way to find out on the web when changing the db data?

The database is using mysql.Is there any way that the web will notice and process when the DB specific value is updated?

2 years ago

1 answers
119 views
0
Python socket communication and mysql communication questions

import socketimport jsonimport pymysqlHOST = ''PORT = i = 0list_data =[]s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)s.bind((HOST, PORT))s.listen(1)while True : try : conn,addr = s.accept() ...


1 answers
85 views
0
MSSQL Query - How do I get the last index of the string I'm looking for?

Hello seniorsThe query I'm looking for now is Hello World, This is sample codein the string When you look for the word sample,I'm trying to pull out an index that corresponds to 'e' (last index of the...

2 years ago

2 answers
100 views
0
The index is created in postgres, but I wonder if you do seq scan instead of index scan.

The background of knowing the problem is that when selecting, the index was clearly created in consideration of the corresponding select statement, and in development db (local db), the index scan was...

2 years ago

1 answers
61 views
0
How do you measure the query rate in the long run?

I'm using a storage and post-grescual.By the way, I want to know how fast the query sentence I made speeds up when there is a lot of data.I used django debug toolbar In this case, I can't figure out h...

2 years ago

1 answers
41 views
0
How do I query mysql RANK?

Hello, I'm trying to print out the ranking on mysql. SELECT * FROM ( SELECT cu_distribution, count(cu_status), @curRank := @curRank + 1 AS rank FROM cs_customer p, (SELECT @curRank := ...

2 years ago

1 answers
46 views
0
When I put Excel data into the table in Mysql...

When putting Excel data in the Mysql table LOAD DATA INFILE 'File Name' INTO TABLE Table Name As far as I know, you put it in this query, not all the Excel data in the table like thatCan't we just spa...

2 years ago

1 answers
45 views
0
put mysql temporary field (virtual field)

Hi, everyone. +-------+---------+| | Field |count |+-------+---------+| test | 4 | <- Fields in Table +-------+---------+| etc | 2 | <- Temporary field of fields not in table.+-------+---------+...

2 years ago

1 answers
38 views
0
I'm planning a source for php membership, but how can I not allow you to join with an ID that is already in the DB when you sign up for membership?

I'm planning a source for php membership, but how can I not allow you to join with an ID that is already in the DB when you sign up for membership?

2 years ago
« - 56 - »

© 2024 OneMinuteCode. All rights reserved.