database tag

146 questions


1 answers
398 views
0
Update action does not update data

The value of the update action has not been changed, and there are no errors.Create works fine.views/searches/edit.html.erb<%=form_with(model:@search,local:true)do|f|%> <%=f.label:postal_code...


1 answers
504 views
0
What happens if I set the transaction isolation level arbitrarily in the source code?

As for how to set the transaction isolation level, Spring can be set casually by adding @Transactional for each method, or Rails can be set casually by ApplicationRecord.transaction (isolation:read_co...


1 answers
391 views
0
I want to create a Q&A site like Yahoo Chiebukuro.

For Q&A sites like Yahoo Chiebukuro, I think each question has a unique URL.Would it be possible to receive it from the database and display it and give it a unique URL at the same time?If possibl...

2 years ago

1 answers
93 views
0
Aggregate SQL in mariadb 10.4

I would like to do the following in mariadb 10.4.7.There is an inventory control table that registers data according to the entry and exit of the item.The inventory table looks like the following. | d...

2 years ago

1 answers
144 views
0
Understanding Data Combination in MySQL

The following databases are available:Please let me know if there are any SQL statements that combine the same names but lack data.

2 years ago

2 answers
127 views
0
Why does adding/removing columns in the migration file not reflect in schema.rb?

I'm a beginner at Rails.How does migration work?My senior taught me the following things.Rails compares the migration file to the schema_migrations table Automatically find and execute unexecuted migr...

2 years ago

1 answers
138 views
0
VBA Excel Databaseization

Excel has data organized by date in the first column and ID in the first column.I would like to organize this so that it can be used as a database, but please let me know if there is a VBA code that c...

2 years ago

1 answers
93 views
0
How to Disconnect AutoCommit from DB2 with VC++ ADO Connection

Connecting to IBM DB2 via Visual C++ 2010/ADO connection.I'm creating a program that moves files after adding/updating lines.I tried to roll back when the file move failed, but now I'm committed.Is th...


1 answers
127 views
0
The size of the FMDB file does not decrease even after DELETE.

DELETE does not reduce the size of the FMDB file (xxx.sqlite).As one of the solutions, I thought that if I create a new sqlite file and copy it as much as I need with an insert, I will be able to crea...

2 years ago

2 answers
116 views
0
I want to delete and page transition by pressing button.

When button is clicked and name='action' is POSTed, DELETE is executed(); but At this time, I would like to transition to home.php at the same time.<button type='submit'name='action'value='delete'o...

2 years ago
« - 2 - »

© 2024 OneMinuteCode. All rights reserved.