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...
- Modified
- 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...
- Modified
- 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...
- Modified
- 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...
- Modified
- 1 Feb at 18:12
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...
- Modified
- 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....
- Modified
- 20 Nov at 22:16
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...
- Modified
- 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...
- Modified
- 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 ...
- Modified
- 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...
- Modified
- 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...
- Modified
- 26 Sep at 08:24
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...
- Modified
- 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...
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...
- Modified
- 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 ...
- Modified
- 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...
- Modified
- 15 Jun at 20:22
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...
- Modified
- 17 Nov at 06:4
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...
- Modified
- 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...
- Modified
- 19 Jul at 23:36
Equivalent of varchar(max) in MySQL?
Equivalent of varchar(max) in MySQL? What is the equivalent of varchar(max) in MySQL?
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...
- Modified
- 26 Apr at 03:5
Count table rows
Count table rows What is the MySQL command to retrieve the count of records in a table?
- Modified
- 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?
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...
- Modified
- 31 May at 09:35
setting multiple column using one update
setting multiple column using one update How to set multiple columns of a table using update query in mysql?
- Modified
- 8 Sep at 11:59