select from table mysql code example

Example 1: mysql show data from table

mysql> SELECT * FROM [table name];

Example 2: select tables from mysql database

SHOW TABLES from <databasename>;

Example 3: how select from db

SELECT columname FROM tablename

Example 4: mysql read row

$sql = "INSERT INTO users (name, surname, sex) VALUES (?,?,?)";$stmt= $pdo->prepare($sql);$stmt->execute([$name, $surname, $sex]);

Example 5: php + get sql query

echo $select->__toString();

Example 6: MySQL SELECT

SELECT select_list
FROM table_name;