mySql语句整理

一 mySql建表语句示例:

 CREATE TABLE `student` (
  `id` varchar(256) NOT NULL,
  `name` varchar(128) NOT NULL,
  `age` int DEFAULT NULL,
  PRIMARY KEY (`id`)
)

二 mybaits条件语句:

<select id="getMemoInfos" resultType="com.lxm.bean.MemoDBBean">
    select * from memoInfo
    <if test='id != null and  id != ""'>
        where id = #{id}
    </if>
</select>