linux mysql 语法_linux mysql 语法

表的数据select*fromusers;+---------+------------+-----------+---------+----------------------------------+---------------------------------+|user_id|first_name|last_name|...

表的数据

select *

from users;

+---------+------------+-----------+---------+----------------------------------+---------------------------------+

| user_id | first_name | last_name | user | password | avatar |

+---------+------------+-----------+---------+----------------------------------+---------------------------------+

| 1 | admin | admin | admin | e10adc3949ba59abbe56e057f20f883e | dvwa/hackable/users/admin.jpg |

| 2 | Gordon | Brown | gordonb | e99a18c428cb38d5f260853678922e03 | dvwa/hackable/users/gordonb.jpg |

| 3 | Hack | Me | 1337 | 8d3533d75ae2c3966d7e0d4fcc69216b | dvwa/hackable/users/1337.jpg |

| 4 | Pablo | Picasso | pablo | 0d107d09f5bbe40cade3de5c71e9e9b7 | dvwa/hackable/users/pablo.jpg |

| 5 | Bob | Smith | smithy | 5f4dcc3b5aa765d61d8327deb882cf99 | dvwa/hackable/users/smithy.jpg |

+---------+------------+-----------+---------+----------------------------------+---------------------------------+

修改的

mysql> updata users set user_id='6' where user='admin';

ERROR 1064 (42000): 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 'updata users set user_id='6' where user='admin'' at line 1

错在哪里 求指点

展开