执行一个查询比较短语是一个痛苦的屁股。查看下面的配置以了解我的问题。
sql.sql
create user "myStore"@"localhost" identified by "1234"; grant all privileges on myStore.* TO "myStore"@"localhost";
create database myStore character set utf8 collate utf8_general_ci;
use myStore;
create table ite
我遇到了一些奇怪的事情。我在windows上从一个文件名运行我的查询。
就像source c:\sql\general.sql一样,但是失败了
mysql> source c:\sql\general.sql
--------------
mysql Ver 14.14 Distrib 5.6.11, for Win32 (x86)
Connection id: 6
Current database: joins
Current user: root@localhost
SSL: Not in u
首先,我尝试使用SQL Server Migration Assistant for MySql迁移我的数据库,它工作得很好。
但是现在,我的代码出现了一些问题。
我在MYSQL版本上有这样一句话:
$fct="SELECT * FROM `users` WHERE `USER` LIKE CONVERT( _utf8 '$LOGIN' USING latin1 ) COLLATE latin1_swedish_ci AND `PASS` LIKE CONVERT( _utf8 '$PASS'USING latin1 ) COLLATE latin1_s
我有一个"?“(问号)代替搜索结果中的非拉丁字符。我有狮身人面像2.0.3和最新的Debian。这不是第一次使用狮身人面像,但这个问题是第一次。在UTF中完全使用编码和数据库连接:
character set client utf8
character set connection utf8
character set database utf8
character set results utf8
character set server utf8
character set system utf8
collation connection utf8_general_ci
colla
我尝试通过bash创建一个新的数据库,它的名称中有一个破折号。
这就是我尝试过的:
echo "CREATE DATABASE IF NOT EXISTS db-name CHARACTER SET utf8 COLLATE utf8_general_ci" | mysql -uuser -ppw
这将失败,并显示以下错误:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server versi
我正在使用pyodbc连接到MS SQL server数据库。我得到的错误如下所示
invalid byte sequence for encoding "UTF8": 0x93
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
SQL数据库是用Latin1编码的,我使用的是postgres和django,它需要U
我想从performance_schema.events_statements_history_long创建一个表,但得到了一个错误。
sql:
create table history select * from performance_schema.events_statements_history_long
错误:
Incorrect string value: '\xF0\x9F\x9F\xA8\xE8\xAD...' for column 'SQL_TEXT' at row 1108
字符集
SHOW VARIABLES WHERE Variable
我的-default.ini
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade t
好吧,我撞到了砖墙,没什么主意了。
Master: 8.0.25-0ubuntu0.20.04.1
Slave: 5.7.33-0ubuntu0.16.04.1-log
使用show slave status\G获取错误:
Last_SQL_Errno: 22
Last_SQL_Error: Error 'Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' fil
出于某种原因,工作台在输出脚本上包含了一个表,我很久以前就移除了这个表。
因此,在运行脚本时,它会标识以下错误。我知道从脚本中删除它可以解决我的问题,但我不知道工作台是否会得到那个桌子。
Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ENGINE = InnoDB
这是我的猜测。恢复在出现UTF-8字符的行处停止,这是一些非英语字符。所以它搞乱了整个过程。
我想通过我从另一个数据库转储的SQL文件恢复数据库。另一个数据库使用的都是utf-8。请参阅第二部分。
谁能告诉我把这个问题考虑在内的dump命令和restore命令?
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----
我试图将MySQL Workbench 8.0.3与MariaDB一起使用,但我得到了以下错误:
Executing:
CREATE TABLE `mydb`.`customer` (
`ID` INT UNIQUE UNSIGNED NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NOT NULL,
`Email` VARCHAR(255) CHARACTER SET 'utf8' NOT NULL,
`Street` VARCHAR(255) CHARACTER SET 'utf8' COL
我正在使用MySQL工作台,我刚刚在我的MySQL模型中添加了一个新表。当我尝试与数据库同步时,我得到以下错误:
Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLA
我对SQL非常陌生,实际上我昨天才刚开始接触。我正在阅读的这本书要求我从他们提供的文本文件中运行sql语句。但是,我收到一条错误消息,我不明白为什么。下面是我输入的命令和错误消息:
mysql> use bank;
Database changed
mysql> source c:\sql\LearningSQLExample.sql;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 9
Current database:
这是我的sql查询字符串:
select t.create_date, concat('+', t.points) as points,
case t.obtain_ways
when 'PURCHASE_PRODUCT' then '理财赠送'
when 'SOCIAL_NETWORK_SHARE' then '社交网络分享'
when 'CHECK
MariaDB [sqdc]> create table area( id int auto_increment primary key unsigned)engine=InnoDB default charset=utf8;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'unsigned)engine=InnoDB
我得到了一个新的迁移错误,一个非常旧的迁移(过去运行良好)。 我得到的错误是:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 NOT NULL COLLATE `utf8_unicode_ci`' at lin
在“mysqldump”错误上请求的帮助
我在地狱里搞清楚为什么会发生以下错误。所以,拜托,谁来帮我。我写的是: A,B,C,D S。这是my.ini文件。
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default loca
我正在尝试用表填充数据库(我是新手),执行.php后我得到的消息是:表"users“成功创建表"tempRes”成功创建表"empRec“成功创建但是第二个和第三个表没有出现在phpMyAdmin的数据库中。SHOW TABLES & SHOW table STATUS仅显示"user“表。有人知道为什么会这样吗?我该怎么纠正呢?下面是我的代码:
<?php
// connect to the MySQL server
$conn = new mysqli('localhost', 'fiona',
CREATE TABLE 'product_desc' (
`index` int(4) NOT NULL auto_increment,
`item_no` int(3) NOT NULL default '0',
`product_no` int(3) NOT NULL default '0',
`text` text NOT NULL,
PRIMARY KEY (`index`)
) ENGINE=product set CHARACTER SET utf8 COLLATE utf8_general_ci;
这是我在网
为什么会这样:
$query = "SET NAMES 'utf8'";
$query = str_replace("'", "\'", $query);
$pdo->query($query);
会有问题吗?
我目前收到这个错误:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\
问题:由于缺少排序规则,mysqldump将不会导入
1273年-未知校勘:'utf8mb4_unicode_520_ci‘
Mysql服务器(来自phpMyAdmin)是:
Server version: 5.5.40 - MySQL Community
Server charset: UTF-8 Unicode (utf8)
Database client version: libmysql - 5.0.95
这是一台centos5.11服务器。
mysql> show variables where Variable_name like 'characte