mysql语法如何实现查询、更新数据

如何利用mysql语法实现查询数据、更新数据，下面编程教程网小编给大家简单介绍一下具体语法！

mysql查询数据

SELECT * FROM tablename;

SELECT column1, column2, column3 FROM tablename;

SELECT * FROM tablename WHERE column1 = 'value';

mysql更新数据

UPDATE tablename SET column1 = 'newvalue' WHERE column2 = 'value';