MySQL Archives - Page 7 of 77

MySQL, Programming

IT Nursery

Connect to mysql in a docker container from the host

(It’s probably a dumb question due to my limited knowledge with Docker or mysql administration, but since I spent a whole evening on ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

Import SQL file into mysql

I have a database called nitm. I haven’t created any tables there. But I have a SQL file which contains all the necessary ...

June 1, 2022
0 Comments

WordPress

IT Nursery

Calculating Bayesian average for custom post type

I have a custom post type called entries, which holds contestants for a competition. There is a 5 star rating function, the ratings ...

June 1, 2022
0 Comments

PHP, Programming

IT Nursery

PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client [duplicate]

This question already has answers here: php mysqli_connect: authentication method unknown to the client [caching_sha2_password] (15 answers) Closed 2 years ago. I’m running ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL – Get row number on select

Can I run a select statement and get the row number if the items are sorted? I have a table like this: mysql> ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How to change the CHARACTER SET (and COLLATION) throughout a database?

Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

MySQL “NOT IN” query

I wanted to run a simple query to throw up all the rows of Table1 where a principal column value is not present ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How to get database structure in MySQL via query

Is it possible to somehow get structure of MySQL database, or just some table with simple query? Or is there another way, how ...

June 1, 2022
0 Comments

WordPress

IT Nursery

Performance issues with large website [closed]

Closed. This question is off-topic. It is not currently accepting answers. Questions that are too localized (such as syntax errors, code with restricted ...

June 1, 2022
0 Comments

WordPress

IT Nursery

AJAX in WordPress, sending coords data to MySQL and show after into map

I’ve spent some months trying to figure out how to get users geolocation and pass it into MySQL and so after being shown ...

June 1, 2022
0 Comments