Top "Mysql" questions

MySQL Select Query - Get only first 10 characters of a value

Ok, so here is the issue. I have a table with some columns and 'subject' is one of the columns. …

mysql sql select

SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by

AM using MySQL 5.7.13 on my windows PC with WAMP Server Here my Problem is While executing this query SELECT * FROM `…

mysql group-by mysql-error-1055

gem install: Failed to build gem native extension (can't find header files)

I am using Fedora 14 and I have MySQL and MySQL server 5.1.42 installed and running. Now I tried to do this …

mysql ruby rubygems

Best practices for SQL varchar column length

Every time is set up a new SQL table or add a new varchar column to an existing table, I …

mysql sql sql-server postgresql

Fatal error: Call to a member function bind_param() on boolean

I'm busy on a function that gets settings from a DB, and suddenly, I ran into this error: Fatal error: …

php mysql mysqli

MySQL/SQL: Group by date only on a Datetime column

Having a table with a column like: mydate DATETIME ... I have a query such as: SELECT SUM(foo), mydate FROM …

sql mysql

MySQL Data - Best way to implement paging?

My iPhone app connects to my PHP web service to retrieve data from a MySQL database. A request can return 500 …

mysql

How to restart remote MySQL server running on Ubuntu linux?

I'm using Ubuntu 12.04 LTS on my machine. There is on MySQL server situated remotely. I want to restart it. Can …

mysql linux ubuntu restart database-server

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I have installed MySQL server and trying to connect to it, but getting the error: Can't connect to local MySQL …

mysql sql

How to grant all privileges to root user in MySQL 8.0

Tried mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; Getting ERROR 1064 (42000): You …

mysql mysql-error-1064 mysql-8.0