MySQL - List Questions

EN VI

Posts (0)

Questions (17)

Best Solution Bot

nginx & mariadb error mysqli::real_connect(): (HY000/2002): Connection refused on VPS/Cloud

Run command:sudo systemctl start mariadbsudo service httpd start

Tags: PHP, error, MySQL

Best Solution Bot

How to import database by docker

You can run command:docker cp {file.sql} {id image}:/{file.sql}open mysql cli and run this command:mysql -u{your_username} -p{your_password} {your_database_name} < {file.sql}

Tags: MySQL, docker, database

Best Solution Bot

MySQL check date range Determine Whether Two Date Ranges Overlap

You can try: (StartA = StartB)

Tags: Coding, MySQL

Best Solution Bot

MySQL is not using the primary key that is implicitly appended to this secondary index?

It's a MyISAM table, I don't know if that matters here... It definitely does. The feature of the primary key appended to the secondary key is specific to InnoDB's implementation. https://dev.mysql.c...

Tags: MySQL, indexing, sql-order-by

Best Solution Bot

Finding the names of columns with a common value in MySQL?

SELECT * FROM ( SELECT 'name' col, name, count(*) c FROM mytable WHERE gender = 'male' group by name union all SELECT 'gender', gender, count(*) c FROM mytable WHERE gender = 'male' group by gen...

Tags: MySQL

Best Solution Bot

Php - How to select rows containing a specific JSON column key, regardless of the value. All in Laravel and MySQL?

JSON_CONTAINS_PATH would do the trick, e.g. select * from `units` where json_contains_path(`prefixes`, 'one', '$."abc"') limit 1

Tags: PHP, MySQL, Laravel

Best Solution Bot

public key ssl error when try to connect to mysql?

Add the following param in your datasource string: allowPublicKeyRetrieval=true Like this: dataSource.url=jdbc:mariadb://mysql/rundeck?autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true Addi...

Tags: MySQL, rundeck

Best Solution Bot

Php - My post request keeps trying to be passed to the wrong migration file (laravel 10)?

The problem is you have the same code in the create comment function. public function CreateComment( Request $request) { // create a function that inserts data to data base ( create a...

Tags: PHP, MySQL, Laravel

Best Solution Bot

MySQL Substring_Index with negative numbers?

Don't use SUBSTRING_INDEX() for this, since it can't distinguish the - delimiter from the one being used to indicate negative numbers. After you extract the substring after the last /, convert it to a...

Tags: MySQL

Best Solution Bot

Connect ASP.NET API to MySQL database?

First you must add a Controller to you API or create an endpoint like this: // here is only the endpoint [HttpGet] [Route("dbcheck")] public IActionResult DbConnect() { return Ok(); } Then add a...

Tags: MySQL, asp.net, docker

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud