Android 常用代码---SQL

1创建表 权限代码CREATE TABLE songs(    id  INTEGER,    name  TEXT,      genre  TEXT,     rate  REAL,    some_raw_data BLOB   );2使用其它表的数据创建表权限代码SELECT *  INTO rockssongsFROM songs WHERE genre ='rock';3计数示例权限代码SELECT COUNT(DISTINCT student_city) AS totalFROM students;4删除行权限代码DELETE FROM songsWHERE rating< 5;5删除表权限代码DROP TABLE"bad_songs";6左联接示例权限代码SELECT students.nameFROM students LEFT JOIN math_class    ON students.id = math_class.student_id WHERE math_class.grade > 5;7内部联接示例权限代码SELECT DISTINCT students.id, students.nameFROM students INNER JOIN math_class ON students.id = math_class.student_id;8插入示例权限代码INSERT INTO albums(ambum_id, artist_name, album_name)VALUES('12345', 'David Bowie','Ziggy Stardust');9更新表权限代码UPDATE songs SET already_listened ="yes"WHERE genre = "rock";