我正在学习MySQL,我刚刚创建了我的第一个数据库,但当我创建了一个名为"pessoas“的表时,正如Youtube教程中所示,它显示了这两个附加的错误消息,并且没有让我看到创建的表。我试着把单词周围的重音调回来,但不起作用。有人能给我解释一下怎么回事吗?

发布于 2020-06-18 05:07:34
A.A.,您的CREATE TABLE在MariaDB 10.4.13上运行成功。
实际的错误消息与检索数据库用户信息的查询有关,我猜这些查询来自MySQL工作台本身。我最好的猜测是你的数据库和工作台有不同的版本。就我个人而言,我不太喜欢这个工作台(只用于查询分析),所以也许可以尝试另一个客户端: MySQL命令行、HeidiSQL、phpMyAdmin等等。
致以最好的问候,马丁
发布于 2020-06-18 06:02:27
您的SELECTa对于mysql是胡言乱语,这就是它们失败的原因。
见你的第二选择示例
SELECT
Db as scopeuserhostSelect_priv
AS Selectlnsert_priv
AS lnsertUpdate_priv
AS UpdateDelete_priv
AS DeleteCreate_priv
AS CreateDrop_priv
AS DropGrant_priv
AS GrantReferences_priv
AS Referenceslndex_priv
AS IndexAlter_priv
AS AlterCreate_View_priv
AS Create ViewShow_view_priv
AS Show viewTrigger_priv
AS TriggerDelete_versioning_rows_priv
AS Delete versioning rows
FROM mysql.db
WHERE cadastro2 likedb查询如下所示
SELECT `test12`.`id` as id,
`test12`.`usr_id` as usr_id,
`test12`.`category` as category,
`test12`.`comp_id` as comp_id,
`test12`.`position`as position,
`test12`.`description` as description,
`test12`.`country` as country,
`test12`.`state` as state,
`test12`.`city` as city,
`test12`.`start_date` as start_date,
`test12`.`end_date` end_date,
`test12`.`timestamp` as timestamo
FROM `testdb`.`test12`
WHERE `category` LIKE 'tesmeifyou can';每列用逗号分隔,列的别名需要实际的列,LIKE需要比较字符串
在这里您可以找到有关SELECT的更多信息
https://stackoverflow.com/questions/62438264
复制相似问题