![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
【数据库】
我在天上飘
自信的生活态度最重要!
展开
-
数据库学习第一篇
首先Create database 名字;CREATE TABLE 名字(…..…..);DESC 名字; 展示某表SELECT子句用于在所有可能的列中,选择查询结果集要包含哪些列。FROM子句定义了查询所使用的表,以及连接这些表的方式。WHERE INSERT INTO VALUES UPDATE SETWHERESHOW原创 2015-12-28 08:57:43 · 315 阅读 · 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 · 282 阅读 · 0 评论 -
mysql查询练习
Sutdent表的定义字段名字段描述数据类型主键外键非空唯一自增Id学号INT(10)是否是是是Name姓名VARCHAR(20)否转载 2016-05-22 09:58:52 · 11568 阅读 · 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 · 221 阅读 · 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 · 278 阅读 · 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 · 227 阅读 · 0 评论 -
175. Combine Two Tables
Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+---------+Per原创 2016-05-23 11:06:36 · 207 阅读 · 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 · 272 阅读 · 0 评论