- 博客(44)
- 收藏
- 关注
原创 Different Ways to Add Parentheses
class Solution {public: void get_result(const vector<int>&digits, const vector<char>& sign, int left, int right, vector<int>&result){ if(left == right){ result.push_back(digits
2015-08-01 08:45:45 210
原创 Solve the problem of "Java: illegal start of expression"
After declare an array, I assigned value to the array without enclosing it in the bracket. So after I modified the error, the error disappears.
2015-05-29 10:14:31 2998
原创 MySQL Database storage engine
I occasional knows that MySQL Database Storage Engine differs though they share a common database name. To see the storage engine of database, use show [storage] engines; command is okHere is my data
2015-05-24 18:57:57 376
原创 Php link to MySQL
how can php get ajax parameter?Connection failed on Mac OS X: php + MySQL: Error message: Warning: mysqli::mysqli():(HY000/2002):No such file or directory in /Library/WebServer/Documents/php/getDB
2015-05-24 08:37:01 331
原创 Problem to be solved for MySQL create view
The select statement cannot contain a subquery in the from clause Then what if I need a list of contents from a subquery? Create a view or table I cannot really understand the following three
2015-05-23 20:46:55 345
转载 Cha-cha-cha dance music
Cerezo Rosa广岛蔷薇 Anjolina安卓丽娜 Feat Helena壮举赫勒 Mambo No.5第5号Mambo Cute Horse可爱的马 Miss Announce怀念的播音员 Maria Lao玛丽亚老挝 Beautiful East
2015-05-23 19:55:11 381
原创 Two methods to show warning information in MySQL
Problem clarification:After executing a statement in MySQL, feedback information is Query OK, 0 rows affected, 7 warning (xxx.xx sec). However, it didn’t show any warning information.Solution:run s
2015-05-23 19:32:04 354
原创 OS X Import data from local file to MySQL
Syntax: LOAD DATA LOCAL INFILE ‘absolute path’ INTO TABLE table-name FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ IGNORE 1 ROWS; IF the local modifier
2015-05-23 17:30:56 276
原创 MySQL exit prompt when typing a wrong command
sometimes we meet with continuous mysql > mysql > in MySQL command line mode just type \c after the prompt is OK
2015-05-23 17:14:55 265
原创 Move vim cursor to a specific column
Try a number followed by a pipe to get to the specific column in that line.
2015-05-23 17:01:53 306
原创 MySQL the DATE, DATETIME and TIMESTAMP Types
The Date type is used for values with a data part but no time part, MySQL retrieves and displays DATE values in ‘YYYY-MM-DD’ format. The supported range is ‘1000-01-01’ to ‘9999-12-31’.The DATETIME typ
2015-05-23 16:48:15 279
原创 Confusing conditions about MySQL script
after an error happens, I have to use \g to end a command line explicitly rather than just a semicolon;after modify a script and run it again, I will meet with Fail to open file xxx: error 2
2015-05-23 16:30:32 384
原创 MySQL how to show table in a database
use show tables command; don’t forget to change to that database before use the command
2015-05-23 15:33:53 644
原创 Grant Super privilege to DB user
I grant all privilege on a database to a user, however, I still cannot carry out a stored procedure. The error information is Access denied: you need (at least one of) the SUPER privilegess for this
2015-05-23 12:18:08 495
原创 A new concept: dynamic SQL
dynamic SQL is a concept corresponding to static query.
2015-05-23 11:36:30 200
原创 One Importance Difference between Stored Procedure and Stored Function
Stored Function returns a single scalar value, not query results; while Stored Procedures return query results.
2015-05-23 11:24:18 253
原创 Error met at attempts to write stored procedure in MySQL[SOLVED]
Error Information: No database Selected Forget to pass database name parameter and company name parameter to my sql script
2015-05-23 11:23:59 210
原创 Use of delimiter on Stored Procedure in MySQL
not known yet. To be known further.
2015-05-23 11:03:21 236
原创 Decipher the internal structure of some webpage
use chrome browser and see its source code or use Developer Tools or Inspect Elements
2015-05-23 09:53:22 266
原创 time stamp data format
many programming language have pre-defined functions to translate unix time stamp to human-readable strings
2015-05-23 09:38:17 397
原创 MySQL Union
Syntax: select column1 [, column2] from table1[,table2] [where condition] union select column3 [, column4] from table3[,table4] [where condition]Usage Prerequisite: each table must have th
2015-05-22 22:27:17 348
原创 数据库 PCC OCC
For isolation characteristic of transaction management in database, two mechanisms are used: PCC and OCC. PCC(Pessimistic Concurrency Control): get lock before access; application: competitive race
2015-05-11 17:42:08 1277
原创 Codeforces 519B
#include<iostream>#include<cstdio>#include<string>#include<cstring>#include<string.h>#include<algorithm>using namespace std;int main(){ int n; scanf("%d", &n); unsigned long long sumOf
2015-05-10 16:54:57 481
原创 Terms in English
定点表示: fixed point representation浮点表示: floating point representation格雷码: Gray Code
2015-05-06 00:51:37 290
原创 Codeforces 527B
#include<iostream>#include<cstdio>#include<string>#include<string.h>#include<cstring>#include<algorithm>using namespace std;const int maxn = 200005;char s[maxn];char t[maxn];int graph[27][27];
2015-05-04 16:12:41 326
原创 Python Learning Note
Never, never and never give up!!!python version 2.7interactive interpreter: practice python in command linePython Data Type NumbersStrings: escape characters by default. Use print to avoid unreadab
2015-05-02 00:44:57 281
原创 Codeforces 540B School Marks
#include<iostream>#include<cstdio>#include<string>#include<cstring>#include<string.h>#include<algorithm>using namespace std;const int maxn = 1000;int mark[maxn];int n, k, p, x, y;int main(){
2015-05-01 18:12:50 296
原创 Leetcode Customers Who Never Order
WA: select Customers.Name as Customers from Customers where Customers.Name not in (select Customers.Name from Customers join Orders on Customers.Id = Orders.CustomerId) ; AC: select Customers.Name a
2015-04-23 16:34:02 226
原创 Protocol Layers in Computer Network
describe how a protocol layer is similar to a airplane transport? both are layered architecture. Each layer is assigned a task, while at the same time provides api for both upper and lower layer.
2015-04-23 16:33:48 520
原创 db 错题
Select out of following the code which uses a JOIN to show a list of all the departments and number of employed teachersWA: SELECT dept.name, COUNT(teacher.name) FROM teacher JOIN dept ON dept.
2015-04-23 09:07:59 238
原创 Network Core Notebook
definition: network core is the mesh of packet switches and links that interconnects the Internet’s end systems.two approaches to move data within a network of links and switches: packet switchingci
2015-04-23 09:05:20 312
原创 leetcode Number of 1 Bits
class Solution {public: int hammingWeight(uint32_t n) { n = ((n & 0xAAAAAAAA) >> 1) + (n & 0x55555555); n = ((n & 0xCCCCCCCC) >> 2) + (n & 0x33333333); n = ((n & 0xF0F0F0F0
2015-04-22 00:59:08 190
原创 leetcode Bitwise AND of Numbers Range
class Solution {public: int rangeBitwiseAnd(int m, int n) { unsigned int mask = 0x80000000; int ret = 0; while(mask != 0){ int bit1 = n & mask; int
2015-04-22 00:49:58 272
原创 Core Java Note
Robust pointer model that eliminates the possibility of overwriting memory and corrupting data. So the compiler can detect problems that in other languages, show up at only runtime.ActiveX technolog
2015-04-22 00:05:39 257
原创 sql JOIN
(natural) join (natural) join … using …join…ondifference between natural join using and join on in natural join, column specified by using appears only once, but in join on, it appears twice.join
2015-04-18 23:27:42 322
原创 DB Manipulation
delete, insert, modify these operations which may alter the contents of a table have to be done before any change to the table happens.insert insert into table values(column_v1, column_v2, column_v3
2015-04-18 15:10:06 215
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人