Welcome To Ask or Share your Answers For Others

Recent questions tagged mariadb

0 votes

1.1k views

1 answer

mariadb - MySQL: Grant **all** privileges on database

I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'% ... 'myuser'@'...' for table 't' Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

mariadb - How do I set a LOAD DATA working directory in DataGrip?

I have a task in school to load some CSV data into my MariaDB instance. The import is as follows: LOAD DATA ... 65844554/how-do-i-set-a-load-data-working-directory-in-datagrip...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mariadb - SQL - Return amalgamated row of most recent content from matching rows

I can't figure this out - I guess it's simple but I can't find a suitable method. I believe it's ... /65878382/sql-return-amalgamated-row-of-most-recent-content-from-matching-rows...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mariadb - How to do WHERE clause in UNION and LEFT JOIN?

I am trying to do a UNION on 4 tables to get the ID's from each table, WHERE the USER_ID = $_SESSION['uid'] ... com/questions/65878736/how-to-do-where-clause-in-union-and-left-join...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mariadb - MySQL workbench times out even after increasing timeout in the settings

Adding an index to our 25m record DB, which is understandably taking a long time. When I tried to run it ... mysql-workbench-times-out-even-after-increasing-timeout-in-the-settings...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

mariadb - How can i reset mysql root password on linux manjaro

When i try to use : sudo mysql -u root use mysql; SELECT user, plugin FROM user; UPDATE user SET plugin ... questions/65895518/how-can-i-reset-mysql-root-password-on-linux-manjaro...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mariadb - Grouping values for a column in mysql

Im new to mysql (coming from JS) and I would like to know how to group values for a column in a ... //stackoverflow.com/questions/65932746/grouping-values-for-a-column-in-mysql...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mariadb - Slow SQL Query with Federated engine

My set up is the following: website running both the php code and the mariaDB 10.2 dabatase local " ... /stackoverflow.com/questions/65937481/slow-sql-query-with-federated-engine...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mariadb 10.3 - Should a mysql slave answer queries much slower then the master? - Database Administrators Stack Exchange

question from:https://stackoverflow.com/questions/65948147/should-a-mysql-slave-answer-querys-much-slower-then-the-master...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mariadb - Can't connect to local mysql server - error 2002

I have what seems to be a common error, but all of the solutions I've found online aren't working for ... .com/questions/65545797/cant-connect-to-local-mysql-server-error-2002...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

mariadb - Laravel migration: "Foreign key constraint is incorrectly formed" (errno 150)

When migrating my DB, this error appears. Below is my code followed by the error that I am getting ... /laravel-migration-foreign-key-constraint-is-incorrectly-formed-errno-150...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

mariadb - Laravel migration: "Foreign key constraint is incorrectly formed" (errno 150)

When migrating my DB, this error appears. Below is my code followed by the error that I am getting ... /laravel-migration-foreign-key-constraint-is-incorrectly-formed-errno-150...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mariadb - vb.net Data source name not found no default driver and no default driver specified

why is it i am encountering this error? I already download Java SE 15 and i already configured ODBC data Source ... -name-not-found-no-default-driver-and-no-default-driver-specif...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

mariadb - MySQL how to search JSON Array or JSON_CONTAINS in where statement with column name

I am currently using MySQL 5.7. Products table contains a column to store category ids. These ids are stored in a ... -json-array-or-json-contains-in-where-statement-with-column-n...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

989 views

1 answer

mariadb - SQL, operation between paired rows

I have a table t1 a b 1 4 2 2 3 9 2 1 1 6 3 7 I need the output a result 1 4*6 ... you. question from:https://stackoverflow.com/questions/66067168/sql-operation-between-paired-rows...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

mariadb - How do I print a query by MySQL's version in sql file?

I want to print query by MySQL's version in .sql file. When I use MySQL version 5.6, want to print (2 ... mysql.user; Because MySQL 5.6 version doesn't have account_locked column....

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

4.1k views

1 answer

mariadb 意外crash ，自动重启，什么原因？

/lib64/libpthread.so.0(+0x7dd5)[0x7fce09bdbdd5] /lib64/libc.so.6(clone+0x6d)[0x7fce08199ead] Trying to get some variables. Some ... is invalid, but we will try to print it anyway....

asked Jan 25, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

4.0k views

1 answer

mariadb - Context of MySQL wildcards

I am trying to get a better understanding of the context in which MySQL interprets wildcards, especially the _ underscore wildcard, which ... +-----+ 1 row in set (0.00 sec)...

asked Jan 25, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

3.9k views

1 answer

mariadb - Context of MySQL wildcards

I am trying to get a better understanding of the context in which MySQL interprets wildcards, especially the _ underscore wildcard, which ... +-----+ 1 row in set (0.00 sec)...

asked Jan 25, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

5.0k views

1 answer

mariadb - MySQL fulltext with score by columns

I created an index like this: ALTER TABLE `blog_posts` ADD FULLTEXT `title_description_content` (`title`, `description`, ` ... and I couldn't find any example on Google. Thanks!...

asked Jan 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

To see more, click for the full list of questions or popular tags.

...