2108 solutions found
Page 38 of 106votes
After upgrading MySQL to 5.7.8-rc and loging to server I got error: Table 'performance_schema.session_variables' doesn't exist I can'...
votes
I'm working with map data, and the `Latitude/Longitude` extends to 8 decimal places. For example: Latitude 40.71727401 Longitude -74.00898606...
votes
In MySQL I am trying to copy a row with an **autoincrement** `column ID=1` and **insert** the data into same table as a new row with `column ID=2`. How can I...
votes
Is it possible to do a select statement that takes only NOT NULL values? Right now I am using this: SELECT * FROM table And then I have to filter o...
votes
On [Mac OS X v10.6][1] (Snow Leopard), starting MySQL gives the following error: > The server quit without updating PID file ### File *my.cnf* ### `...
votes
I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a...
votes
I'm building a Django site and I am looking for a search engine. A few candidates: - Lucene/Lucene with Compass/Solr - Sphinx - Postgresql built...
votes
If I have a table CREATE TABLE users ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, profession varchar(2...
votes
How do I use the `json_encode()` function with MySQL query results? Do I need to iterate through the rows or can I just apply it to the entire results object?
votes
I'm having a problem where when I try to select the rows that have a NULL for a certain column, it returns an empty set. However, when I look at the table i...
votes
I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm thinking of limiting passwords t...
votes
When I run `show status like 'Con%'` it shows the number of connections, which is 9972 and constantly growing. Is this an active number of connections o...
votes
I have created a table and accidentally put `varchar` length as `300` instead of `65353`. How can I fix that? An example would be appreciated.
votes
In MySQL, I have a table, and I want to set the `auto_increment` value to `5` instead of `1`. Is this possible and what query statement does this?
votes
How do I enable the MySQL function that logs each SQL query statement received from clients and the time that query statement has submitted? Can I do that in p...
votes
Does anyone know if there is a function to obtain the server's time zone setting in MySQL? **UPDATE** This doesn't output any valid info:...
votes
I have a MySQL database configured with the default collation `utf8mb4_general_ci`. When I try to insert a row containing an emoji character in the text using t...
votes
I am getting the following error when I try to connect to mysql: `Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'...
votes
I want to create a new user in MySQL with the syntax: create user 'demo'@'localhost' identified by 'password'; But it returns...
votes
I have a server with Rackspace. I want to access the database from my local machine command line. I tried like: mysql -u username -h my.application.com -p...