MySQL - List Questions - Page 2

EN VI

Posts (0)

Questions (17)

Best Solution Bot

MySQL Query unique field but only when there is no double entry?

You can use Not Exists select plz from table t1 where not exists (select 1 from table t2 where t1.plz = t2.plz and ort = gemenide)

Tags: sql, MySQL

Best Solution Bot

Mysql - slow query log includes even queries that are fast because it includes time spent waiting for lock?

The slow query log does not count the lock time. It only logs a query if the execution time is at least as great as long_query_time in seconds. https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.h...

Tags: MySQL, mysql-slow-query-log

Best Solution Bot

C# - Sql connection works with MySql.Data but not with Dapper/IDbConnection with path not found error?

Of course it doesn't work. You're using SqlClient in the second code snippet, which is specific to SQL Server. If you want to connect to MySQL then you still need to use a MySQL provider.

Tags: c#, MySQL, winforms

Best Solution Bot

Mysql - Count # of valus that exist in column string?

You can try something like this: SELECT ToolCode.ToolCode, COUNT(*) AS Quantity FROM ToolCode JOIN WorkCenter ON WorkCenter.WorkCenter LIKE CONCAT('%', ToolCode.ToolCode, '%') GROUP BY ToolCode.ToolCo...

Tags: MySQL

Best Solution Bot

MySQL: ignore WHERE clause if column does not exist?

Not in straight SQL. If you are sending the SQL query from another programming language, you can selectively add the condition to the query based on the table definition. You can either hard-code th...

Tags: MySQL

Best Solution Bot

SQL: join of 3 select queries from the same table (inner join and left join)?

For intersecting results across multiple conditions in a single table, INNER JOIN is used with the table itself based on matching document IDs and specific conditions for each intersecting set: SELECT...

Tags: sql, MySQL, select

Best Solution Bot

Updating ordinal numbers for child records in MySQL table?

WITH cte AS ( SELECT id, ROW_NUMBER() OVER (PARTITION BY article_id ORDER BY amount) AS ordNum FROM price ) UPDATE price JOIN cte USING (id) SET price.ordNum = cte.ordNum; This requires MySQL 8.0...

Tags: sql, MySQL, foreign-keys

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