RojerChen's 的學習筆記

顯示具有 Programming 標籤的文章。顯示所有文章

RojerChen.2018.09.12

You're given strings J representing the types of stones that are jewels, and S representing the stones you have. Each character in Sis a type of stone you have. You want to know how many of the stones you have are also jewels.

The letters in J are guaranteed distinct, and all characters in J and S are letters. Letters are case sensitive, so "a" is considered a different type of stone from "A".

Example 1:

Input: J = "aA", S = "aAAbbbb"
Output: 3

Example 2:

Input: J = "z", S = "ZZ"
Output: 0

Note:

S and J will consist of letters and have length at most 50.
The characters in J are distinct.

RojerChen.2018.08.31

今天在解 LeetCode 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            |
+----+------------------+
| 1  | john@example.com |
| 2  | bob@example.com  |
| 3  | john@example.com |
+----+------------------+
Id is the primary key column for this table.

For example, after running your query, the above Person table should have the following rows:

+----+------------------+
| Id | Email            |
+----+------------------+
| 1  | john@example.com |
| 2  | bob@example.com  |
+----+------------------+

Note:

Your output is the whole Person table after executing your sql. Use delete statement.

PHP 可以用 Smarty 這個 Framework 框架來做網頁上面的開發，讓 PHP 和 HTML 分離，比方說可以透過下面這種方式來載入 HTML 檔案。

$smarty->display("XXX.HTML");

當我 HTML 裡面有值要傳入的時候，可以先在 PHP 上面先設定參數的值，然後再顯示出來。

#XXX.PHP
設定值

$smarty->assign("data","value);



#XXX.HTML

顯示資料

<%$data%>

訂閱：文章 ( Atom )

RojerChen's 的學習筆記

ReSharper 調整 import namespace 的位置

AD 連線工具：Active Directory Explorer

ORA-12514 TNS: 監聽器目前不知道連線描述區中要求的服務之 Service & SID 傻傻分不清楚

$.ajax is not a function

TDD LeetCode：905. Sort Array By Parity

TDD LeetCode：461. Hamming Distance

TDD LeetCode：804. Unique Morse Code Words

TDD LeetCode：771. Jewels and Stones

LeetCode：196. Delete Duplicate Emails

關於 Microsoft Fake 的使用情境與除錯

[30天快速上手TDD][Day 7]Unit Test - Stub, Mock, Fake 簡介

如何使用 NHibernate 連接 Sybase ASE

Could not create the driver from NHibernate.Driver.SybaseAseClientDriver.

PHP Smart 框架 assign 傳遞參數

MySQL：Error Code 1449 There is no account@localhost registered

64/32 bit ODBC 設定

Eclipse 匯出 WAR 檔

Javascript：Array.prototype 的使用

Definition and Usage

jQuery 的學習筆記-1：jQuery 的載入

[筆記] 變更 Eclipse SVN 帳號密碼

近期文章

統計資料

Blog Archive