Top "Mysql" questions

JPA: how do I persist a String into a database field, type MYSQL Text

The requirement is that the user can write an article, therefore I choose type Text for the content field inside …

java mysql orm jpa

Ordering by the order of values in a SQL IN() clause

I am wondering if there is away (possibly a better way) to order by the order of the values in …

mysql sql sql-order-by

MySQL my.cnf performance tuning recommendations

I am kind of hoping that someone might be able to offer some assistance with optimizing a my.cnf file …

mysql optimization performance my.cnf

SQL query with avg and group by

I have some problems with writing a SQL query for MySQL. I have a table with the following structure: mysql&…

mysql sql group-by average

How do I count unique visitors to my site?

I am making a visitor counting system for user posts to show the most viewed posts on homepage. I have …

php mysql counting visitor-statistic

WAMP Cannot access on local network 403 Forbidden

I know this question has been asked a lot of times I followed Most of the answers in the internet …

php mysql apache wampserver

Reloading .env variables without restarting server (Laravel 5, shared hosting)

My Laravel 5 has run OK until the database was configured, then found this error: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo …

php mysql laravel laravel-5 dreamhost

MySQL ORDER BY multiple column ASC and DESC

I have 2 MYSQL tables, users and scores. Detail: users table: scores table: My intention is get 20 users list that have …

mysql sql-order-by multiple-columns

How to get the max of two values in MySQL?

I tried but failed: mysql> select max(1,0); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual …

mysql max

Import and insert sql.gz file into database with putty

I want to insert a sql.gz file into my database with SSH. What should I do? For example I …

mysql import gzip putty