sql tag

625 questions

1 answers
91 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
43 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
86 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
98 views
0

Error running pg_dump on git bash: too many command-line arguments

I did the following on the git bash I installed on Windows 10.There will be no response.pg_dump-c-Uxxxx-h xxxx.rds.amazonaws.com-f C:\Users\xxxx.sqlWhen I ran the same command at the command prompt, t...

postgresql git-bash

2 years ago

1 answers
111 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...

sql database oracle

2 years ago

1 answers
58 views
0

PostgreSQL does not work: could not connect to server

PostgreSQL does not seem to work on macOS.$brew services list Name Status User Plistmysql stopped postgresql error user/Users/user/Library/LaunchAgent/homebrew.mxcl.postgresql.plistBy the way, psql-l ...

postgresql

2 years ago

1 answers
40 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
38 views
0

Understanding How to Name a Table

I'm a beginner in SQL.I'm thinking of developing a household account book app at home to study, but I can't decide the name of the table.Specifically, I am worried about XXX below.Monthly_expense is m...

sql

2 years ago

1 answers
128 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
86 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

- 20 -

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