mysql tag

409 questions

1 answers
83 views
0

Connection error after switching from XAMPP to MySQL (installed in homebrew)

I was using XAMPP a while ago, but after installing MySQL with homebrew and brew services stop mysql command, I received the following error when connecting with mysql-uroot:ERROR2002(HY000): Can't co...

mysql macos homebrew

2 years ago

1 answers
36 views
0

How to Determine MySQL Global and Thread Buffers

When I look online, I find one of the MySQL system variables: The key_buffer_size and so on are global bufferssort_buffer_size, etc. thread bufferIt is often called .Example: http://dsas.blog.klab.org...

mysql

2 years ago

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...

mysql database

2 years ago

1 answers
35 views
0

Error executing GRANT statement: ERROR 1064

SQL statementgrant all privileges on*.* to test_user1@% identified by 'test1234' with grant option;error messageERROR1064There seems to be an error in SQL grammar. What's the difference?

mysql

2 years ago

1 answers
120 views
0

How to select mysql from bash (shell) and output it in JSON

I would like to know how to select mysql on bash and output it on JSON.Specifically, echo SELECT* from testtable; | mysql --defaults-extra-file=./my.conf testdbI would like to print the results in JSO...

mysql bash jq

2 years ago

1 answers
77 views
0

For partial overwriting (hiding) of fullcalendar periodic event dow.

I have a stuck question about the fullcalendar event.WHAT YOU WANT TO DO1, Get National Holidays from Google2. Display staff's weekly work days in calendar [ ] (implemented in eventSources as dow) ← I...

javascript php jquery mysql fullcalendar

2 years ago

1 answers
36 views
0

Want to run the master nondisruptively when replicating with MySQL

https://dev.mysql.com/doc/refman/5.6/ja/replication-howto-masterstatus.htmlWe are proceeding with the replication by referring to the above URL, but it was written that you should type the following c...

mysql

2 years ago

2 answers
42 views
0

PHP undefined index error

I have created columns such as name and pw in the MySQL user table.Undefined index:name when running PHP belowI get the error, but I don't know the cause.The pw has been correctly determined.$ps=$db-&...

php mysql

2 years ago

1 answers
34 views
0

I would like to get the bottom 5 items from the top in mysql.

It's just like the title says. select * from column order by created desc limit 5;If you do this, of course it will be displayed in descending order.54321appears in This is 12345I'd like to.If possibl...

mysql

2 years ago

1 answers
101 views
0

Understanding How Good Features Work with mysql

We are currently making SNS and are trying to implement the functions of the Good Button.If you want to use mysal to implement good functionality in the databaseIt seems that a large amount of insert ...

mysql elasticsearch redis

2 years ago

- 12 -

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