Top "Mysql" questions

How to post query parameters with Axios?

I am trying to post on an API with some query params. This is working on PostMan / Insomnia when I …

javascript mysql post axios

Closing JDBC Connections in Pool

Our standard code section for using JDBC is... Connection conn = getConnection(...); Statement stmt = conn.conn.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, …

java mysql jdbc connection-pooling

Mysql strip time component from datetime

I need to do a date comparison in Mysql without taking into account the time component i.e. i need …

sql mysql datetime

Can you use an alias in the WHERE clause in mysql?

I need to use an alias in the WHERE clause, but It keeps telling me that its an unknown column. …

mysql sql having having-clause

SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)

MySQL has something like this: INSERT INTO visits (ip, hits) VALUES ('127.0.0.1', 1) ON DUPLICATE KEY UPDATE hits = hits + 1; As …

sql mysql database sqlite upsert

How to connect IntelliJ with local MySQL?

I have been struggling to learn how the localhost MySQL and IntelliJ to connect and program a database related task. …

mysql intellij-idea programmers-notepad

How to force case sensitive table names?

I'm working on a MySQL database in windows. I must move it into a Linux environment. MySQL database contains a …

mysql windows case-sensitive

MySQL vs. SQL Server vs. Oracle

I have always only used MySQL and no other database system. A question came up at a company meeting today …

mysql sql-server oracle

Calculate average of column from MYSQL query

I've got a table that I am trying to calculate the average of the values in a column. Here is …

mysql sum average

How to solve mysql warning: "InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal "?

I ran a mysql import mysql dummyctrad < dumpfile.sql on server and its taking too long to complete. The …

mysql mysql-5.6 mysql-5.7