【数据库】
我在天上飘
自信的生活态度最重要!
展开
-
数据库学习第一篇
首先Create database 名字; CREATE TABLE 名字 (….. ….. ); DESC 名字; 展示某表 SELECT子句用于在所有可能的列中,选择查询结果集要包含哪些列。 FROM子句定义了查询所使用的表,以及连接这些表的方式。 WHERE INSERT INTO VALUES UPDATE SET WHERE SHOW原创 2015-12-28 08:57:43 · 322 阅读 · 0 评论 -
【Android】SQLite使用基础
package com.example.databasetest; import android.os.Bundle; import android.app.Activity; import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteDat原创 2016-02-23 16:17:53 · 309 阅读 · 0 评论 -
mysql查询练习
Sutdent表的定义 字段名 字段描述 数据类型 主键 外键 非空 唯一 自增 Id 学号 INT(10) 是 否 是 是 是 Name 姓名 VARCHAR(20) 否转载 2016-05-22 09:58:52 · 11590 阅读 · 0 评论 -
181. Employees Earning More Than Their Managers
The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +----+-------+--------+-----------+ | Id | Name | Salary |原创 2016-05-23 09:51:51 · 250 阅读 · 0 评论 -
197. Rising Temperature
Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. +---------+------------+------------------+ | Id(INT) | Date(DA原创 2016-05-23 10:11:14 · 304 阅读 · 0 评论 -
182. Duplicate Emails
Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+ For原创 2016-05-23 10:59:01 · 234 阅读 · 0 评论 -
175. Combine Two Tables
Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | LastName | varchar | +-------------+---------+ Per原创 2016-05-23 11:06:36 · 217 阅读 · 0 评论 -
196. Delete Duplicate Emails
Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. +----+------------------+ | Id | Email | +----+-----原创 2016-05-23 11:12:39 · 284 阅读 · 0 评论