sql tag

625 questions


1 answers
61 views
0
How OPTIMIZE TABLE Works in MySQL

OPTIMIZE TABLE said, Only when DELETE lines create a lot of wasted space.How to interact with the InnoDB table for adultsFor example, suppose DELETE and INSERT are performed the same number of times, ...

2 years ago

4 answers
71 views
0
Using SQLite to Express Numbering to Tables

Thank you for your help.The database is limited to SQLite, and there are about 2000 specific tables.I'm looking for a fast way to do this by randomly wielding numbers.id, name, price, index1,Apple,300...

2 years ago

4 answers
143 views
0
Using SQLite to Express Numbering to Tables

Thank you for your help.The database is limited to SQLite, and there are about 2000 specific tables.I'm looking for a fast way to do this by randomly wielding numbers.id, name, price, index1,Apple,300...

2 years ago

1 answers
110 views
0
MacOSX XAMPP "doctrine-module" Does Not Work

Is my Mac love or is there not enough effort?I'm afraid they don't understand... Please help me.Because...I have Xampp on MacOSX and my database is trying to use MySQL.The language is PHP, the framewo...


2 answers
70 views
0
How do I create a database for Rails using MySQL Workbench?

Thank you for taking care of me.I would like to create an application with Rails, but I have some doubts about the MySQL database design, so please let me know.I usually use PHP to create applications...

2 years ago

1 answers
141 views
0
MacOSX XAMPP "doctrine-module" Does Not Work

Is my Mac love or is there not enough effort?I'm afraid they don't understand... Please help me.Because...I have Xampp on MacOSX and my database is trying to use MySQL.The language is PHP, the framewo...


2 answers
79 views
0
I want SQLPLUS to return a negative value when running a SQL file.

I would like to return a negative value when running SQL PLUS.As a result of the execution, it would be good to see the following:>sqlplus-Luser/pass@[email protected]>echo$?>-1Simply put in the D...

2 years ago

2 answers
116 views
0
I want SQLPLUS to return a negative value when running a SQL file.

I would like to return a negative value when running SQL PLUS.As a result of the execution, it would be good to see the following:>sqlplus-Luser/pass@[email protected]>echo$?>-1Simply put in the D...

2 years ago

1 answers
61 views
0
How to Import Existing Data into a Relationship Split Table

Thank you for your continuous support.This time, we are looking for a way to import existing data into a table divided into relationships.Currently, I try to combine programs using OR mapper to conver...

2 years ago

1 answers
86 views
0
MySQL on Plesk 12 is unable to access the database externally

I use Plesk 12.Attempts to access the MySQL database remotely from an external server fail.Allowing any host to connect did not change.When I read the log, there was nothing to do with it.

2 years ago
« - 12 - »

© 2024 OneMinuteCode. All rights reserved.