sql tag

625 questions


1 answers
108 views
0
How to use JDBC to join and store values in entity

I am currently learning JDBC for the first time.For example, if you run a select statement and create an entity class to store the returned values, I would like to ask you a question about how to do i...

2 years ago

2 answers
49 views
0
During AWS DynamoDB cross region replication, the status of the replication connection fails with bootstrap failed.

The user timeline is being used by AWS Tokio region using dynamicodb.The original table has the following specifications:There are two reasons for replication:Detailed tasks for replication are as fol...

2 years ago

1 answers
122 views
0
I'd like to find the value from the array type column to array.

There is a table as below.Books Table-----------------------COLUMN NAME | TYPEid | integername | character varyingsubjects | character varying [] subjects array types when is stored as the {educat...


1 answers
49 views
0
How do I verify that the table exists in SQLite?

I'm using SQLite on Android, but how do I check if there's a specific table?

2 years ago

2 answers
51 views
0
Update/delete table contents from Android to mySQL

How do I delete tables from mySQL DB on Android??I don't know about SQL at all, so I'm only looking at Android booksCreate DB, create table, add contents What did you do with execSQL?I don't know how ...

2 years ago

1 answers
47 views
0
In mysql, which column defaults should I write, null or not null?

Example) member_tableno - auto increment,id - not null,pw - not null,email, phone, address For example, in the table above, only id and pw are required inputs I wonder if the e-mail, phone, and addres...

2 years ago

1 answers
178 views
0
The name of the module that should be installed when using mariaDB in node.js? And the error content and solution when installing?

We are developing a web app with node.js. I'm going to study and start a startup.I was using mysql and found several issues about it and I'm switching to mariaDB.But... There's traffic from the first ...


1 answers
106 views
0
I'm making a chat like Kakao Talk with MySQL, but the query is extremely slow depending on the number of LIMITs

Hello. Like Kakao Talk, we are implementing a chat that shows the past conversation when you look up while looking at the recent conversation.SELECT * FROM chat WHERE user_id = user ID order by chat_i...

2 years ago

1 answers
115 views
0
Bulletin board page processing problems

Hi, everyone. I uploaded it because I had a question about the processing of the bulletin board page.To know the size of the page itself when implementing pagination on the webDon't you need the total...


1 answers
99 views
0
Node.js Web development in progress. First of all, DB is needed for membership management, but I think people often use mongoDB, what about MySQL?

Node.js is being studied and developed.First of all, I'm going to use DB because I need a member management function, so I'm seriously thinking about what to use.It seems that MEAN often uses mongdb f...

2 years ago
« - 42 - »

© 2024 OneMinuteCode. All rights reserved.