select * from t1, t2;内连接 select * from t1 join t2;内连接
左外连接 t1 left join t2 on 条件;
右外连接 t1 right join t2 on 条件;
prepare SQL -> set @s=‘select * from t1 where id=?’;定义变量 -> set @a=‘110’;定义变量 -> prepare p from @s;准备SQL -> execute p using @a;执行SQL -> deallocate p;删除
select * from t1, t2;内连接select * from t1 join t2;内连接左外连接t1 left join t2 on 条件;右外连接t1 right join t2 on 条件;prepare SQL-> set @s=‘select * from t1 where id=?’;定义变量-> set @a=‘110’;定义变量-> prepare p from @s;准备SQL-> execute p using .