mysql tag

409 questions

1 answers
358 views
0

I want to extract records by specifying a Limit condition for a specific column.

Is it possible to adapt LIMIT to specific columns?As an example, I would like to extract two records with the same id, assuming the following data is available.data for:Desired Results:*If id=3000, th...

mysql sql

2 years ago

1 answers
381 views
0

kill process id does not exit

I ran kill process ID in MySQL, but the process did not finish successfully.mysql>SHOW FULL PROCESSLIST;+-----+-----------------+-----------------+------+---------+---------+-----------------------...

mysql

2 years ago

1 answers
423 views
0

Password is not hashed.

environmentmampphp7.4mysql 5.7phpmyadminWhat you want to do and what you can't doThe current feature is that after registering with signup.php and saving the name, password column to the users table, ...

php mysql

2 years ago

1 answers
377 views
0

If the reference value is NULL when creating the View table, I want to merge under different conditions.

We are currently creating a View table.I am combining the table data as shown below, but if hoge2.player1_id is NULL, I would like to combine the player table with hoge.player1_id.CREATE VIEWHOGE_view...

mysql sql

2 years ago

1 answers
426 views
0

If I change the MySQL isolation level for each transaction, what is the load on the DB?

I'm using TypeORM as the ORM for Node.js, but when I look at the document (https://typeorm.io/#/transactions),import {getManager} from typeorm;wait getManager().transaction(SERIALIZABLE, transactional...

mysql node.js

2 years ago

2 answers
65 views
0

If mysql sets the external connection to root@%, it cannot be created.

If you set mysql to externally connectable root@%, you will not be able to createGRANT ALL PRIVILEGES ON shop.shop TO root@'%' Authorization GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD,...

mysql

2 years ago

1 answers
81 views
0

I don't want to write the same query over and over again because the query is redundant.

Yes, it is possible to do it as it is, but I was wondering what to do to avoid redundancy, so I asked you.I tried my_goals - enemy_goals but now it's Unknown columns.The original SQL is the correct pa...

mysql sql

2 years ago

1 answers
118 views
0

'Illegal mix of collations' Error Occurs When Running Mysqldump

Attempting to dump an existing database in MySQL on a Windows PC mysqldump-uroot-p testdb>testdb.dumpWhen I ran , the following error occurred:mysqldump Error: 'Illegal mix of collations (utf8_gene...

mysql

2 years ago

1 answers
115 views
0

I want to divide the select results into columns for each common item and re-output them.

□What you want to doCould you tell me about the SQL query statement when I divide the 'value' column for each 'name' below and redisplay it?□mysql version+---------------+| version()|+------------+| 5...

mysql

2 years ago

1 answers
114 views
0

I want to change the reference DB in Bitnami Redmine

I installed Bitnami Redmine on Sakura no VPS where the LAMP environment is built, but I have confirmed that MySQL included with Bitnami and MySQL, which was originally included, cannot be started simu...

mysql redmine bitnami

2 years ago

- 3 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656