tagged [mysql]

Access mysql remote database from command line

Access mysql remote database from command line I have a server with Rackspace. I want to access the database from my local machine command line. I tried like: But it gives an error: > ERROR 2003 (HY00...

20 Jun at 09:12

MySQL Workbench reports "is not valid at this position for this server version" error

MySQL Workbench reports "is not valid at this position for this server version" error For the following SQL query: I receive the following error message: I am a total newbie at SQL. How do I resolve t...

26 Nov at 03:13

MySQL error 2006: mysql server has gone away

MySQL error 2006: mysql server has gone away I'm running a server at my office to process some files and report the results to a remote MySQL server. The files processing takes some time and the proce...

11 Nov at 06:4

How to connect to MySQL Database?

How to connect to MySQL Database? New to C# programming, I'd like to be able to access `MySQL` Databases. I know `MySQL connector/NET` and `MySQL for Visual Studio` are required for C# development. Do...

How to resolve ambiguous column names when retrieving results?

How to resolve ambiguous column names when retrieving results? I have two tables in my database: NEWS table with columns: - `id`- `user` USERS table with columns: - `id` I want to execute this SQL: Wh...

15 Mar at 13:42

How to connect to a MySQL Data Source in Visual Studio

How to connect to a MySQL Data Source in Visual Studio I use the [MySQL Connector/Net](http://dev.mysql.com/downloads/connector/net/) to connect to my database by referencing the assembly (MySql.Data....

MySQL Error #1133 - Can't find any matching row in the user table

MySQL Error #1133 - Can't find any matching row in the user table Unable to set password for a user using for . When trying to set the password while logged onto `phpMyAdmin` as the user, it pops up t...

21 Jan at 04:24

How to insert pandas dataframe via mysqldb into database?

How to insert pandas dataframe via mysqldb into database? I can connect to my local mysql database from python, and I can create, select from, and insert individual rows. My question is: can I directl...

10 May at 06:29

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause? Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause? ``` CREATE TABLE ...

20 Feb at 01:48

How to search JSON array in MySQL?

How to search JSON array in MySQL? Let's say I have a JSON column named in some MySQL table, and this column is a single . So, for example, data may contain: > [1,2,3,4,5] Now I want to select all row...

6 Jun at 13:26

How do you use the "WITH" clause in MySQL?

How do you use the "WITH" clause in MySQL? I am converting all my SQL Server queries to MySQL and my queries that have `WITH` in them are all failing. Here's an example: ``` WITH t1 AS ( SELECT arti...

How do I conditionally set a column to its default value with MySqlParameter?

How do I conditionally set a column to its default value with MySqlParameter? I have a table in a MySql database that stores user accounts. One of the columns, expires, stores an expiration date but d...

18 May at 14:15

PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client

PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client I'm running MySQL version 8 on PHP 7.0. I'm getting the following error when I try to connect to my database...

16 Jun at 18:30

How can I directly view blobs in MySQL Workbench

How can I directly view blobs in MySQL Workbench I'm using MySQL Workbench CE 5.2.30 CE / Rev 6790 . When execute the following statement: I only get back a nice `BLOB` icon, I need to left-click to s...

3 Dec at 09:57

Export DataBase with MySQL Workbench with INSERT statements

Export DataBase with MySQL Workbench with INSERT statements I am trying to export the DataBase i have at MySQL Workbench but I am having troubles to generate the INSERT statements on the .sql file. I ...

14 Oct at 21:33

1052: Column 'id' in field list is ambiguous

1052: Column 'id' in field list is ambiguous I have 2 tables. `tbl_names` and `tbl_section` which has both the `id` field in them. How do I go about selecting the `id` field, because I always get this...

Error importing SQL dump into MySQL: Unknown database / Can't create database

Error importing SQL dump into MySQL: Unknown database / Can't create database I'm confused how to import a SQL dump file. I can't seem to import the database without creating the database first in MyS...

Installing specific package version with pip

Installing specific package version with pip I am trying to install version 1.2.2 of `MySQL_python`, using a fresh virtualenv created with the `--no-site-packages` option. The current version shown in...

3 Apr at 19:58

MySQL Error #1071 - Specified key was too long; max key length is 767 bytes

MySQL Error #1071 - Specified key was too long; max key length is 767 bytes When I executed the following command: ``` ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` ); #1071 - Specified key...

19 Jul at 23:36

Using column alias in WHERE clause of MySQL query produces an error

Using column alias in WHERE clause of MySQL query produces an error The query I'm running is as follows, however I'm getting this error: > #1054 - Unknown column 'guaranteed_postcode' in 'IN/ALL/ANY s...

26 Apr at 03:5

Equivalent of varchar(max) in MySQL?

Equivalent of varchar(max) in MySQL? What is the equivalent of varchar(max) in MySQL?

2 Dec at 01:49

MySQL Error 1093 - Can't specify target table for update in FROM clause

MySQL Error 1093 - Can't specify target table for update in FROM clause I have a table `story_category` in my database with corrupt entries. The next query returns the corrupt entries: I tried to dele...

How to connect to a MySQL Database without SSL

How to connect to a MySQL Database without SSL I'm trying to connect to a local MySQL DB. I have this connector: ``` using(MySqlConnection conn = new MySqlConnection("Database=Studentenverwaltung;Port...

23 Jan at 10:36

Count table rows

Count table rows What is the MySQL command to retrieve the count of records in a table?

23 Jun at 22:20

Clear MySQL query cache without restarting server

Clear MySQL query cache without restarting server Is there any way to mysql without restarting mySQL server?

8 Mar at 11:14