database tag

146 questions


1 answers
109 views
0
How to manage associated data in combination

Suppose you have a table with about 30 columns, and you have a huge number of records every day.We initially fix 30 columns, but we may increase them to 35.AAA,BBB,FFFAAA, CCC, DDDBBB, CCC, EEE If you...

2 years ago

1 answers
93 views
0
CLI Connection Errors in IBM DB2 v9.5

As stated in the title, I would like to connect to DB2(v9.5) from PHP 5.6, but an error occurred and I cannot connect.Error Contents [IBM] [CLI Driver] SQL0332N Character conversion from the source co...

2 years ago

2 answers
102 views
0
About C#64bit DB Connection Paradox

// Obtain registry data from OLE DBconn.ConnectionString=string.Format(Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0}; Extended Properties=Paradox 5.x;, inputFolderName);conn.Open();This operation...

2 years ago

1 answers
143 views
0
Want to know how to implement best practices for accessing split tables in Spring Data JPA

For example, a user table with user informationuser_0, user_1, user_2, user_3 (when userId is divided by 4, the remainder follows the table name) I would like to know how to implement without having t...


1 answers
69 views
0
I want to achieve table output in HTML for the contents of the SELECT result from DB (MSSQL) and the number of columns that are not expected.

The server-side language is PHP 7.0.In general, I couldn't imagine what kind of solution I should take when I accomplished the subject matter, and I asked an unreasonable question.However, after recei...

2 years ago

3 answers
64 views
0
Information About DDD Transaction Management

DDD recognizes transaction management at the application layer.For example, there are two domain models: User and Company.Let's say that each of them has a DB registration process on the master screen...

2 years ago

2 answers
101 views
0
Android App Development ~ Loading Existing DBs~

I have a question about how to use DB for Android app development.実現What I want to realizeInstead of creating a DB in the app, you can import an existing DB into the app and use it.疑問Question1, When I...


1 answers
78 views
0
Do I need to lock the SELECT...WHERE id=100 statement with a unique index?

The MySQL reference documentation provides these descriptions and examples of the gap lock [1].A statement that locks a row by using a unique index to search for a unique row does not require a gap lo...

2 years ago

1 answers
102 views
0
ORA-00936—The expression is missing.

SELECT syainNo , name ,date ,place , time FROM YOTEI_DATA_TBL;I selected what I created in oracle db. ORA-00936—The expression is missing.00936.00000 - missing expression*Cause: *Action:Row 16 Co...

2 years ago

2 answers
74 views
0
Normalization of product tables such as EC sites

We create applications that mimic EC sites.I would like to normalize the product table.Currently, the table configuration is as follows.1 id2. Product name3. List Price4. Number of stocks5 Date of arr...

« - 3 - »

© 2024 OneMinuteCode. All rights reserved.