Thinking in SQL Series One: Chessboard Placement

Originality: Niu Chao 2017-02-08  DALIAN Speaking of SQL, many friends in the industry think it is simple and not worth investing too much energy. So when we encounter complex data processing, we use PLSQL, T-SQL, JAVA and other languages to concatenate SQL, and gradually weaken the trend of SQL. Since I started my career, I have ex ...

Posted on Sun, 24 Mar 2019 00:33:27 -0400 by mrdeadman

C

This paper briefly introduces some common attributes, as well as some terminology explanations and illustrations, which are not comprehensive enough. I hope readers can add more. 1. Overload: Function names are the same, and the number or type of parameters are different.   public void MyDog(string s); public void MyDog(int i); p ...

Posted on Sun, 24 Mar 2019 00:27:27 -0400 by LOUDMOUTH

Actual combat: mapper file to sql statement

Actual combat: mapper file to sql statement Actual combat: mapper file to sql statement Actual combat: mapper file to sql statement Recent code cloud projects, excellent open source projects, table structure sql, descriptive documents, may as well be some semi-open source projects, there are entity classes, there is no SQL ...

Posted on Sat, 23 Mar 2019 22:06:27 -0400 by Tekime

Android Data Storage-SQLite

Android Data Storage-SQLite Copyright Statement: This article is the original article of the blogger. It can not be reproduced without the permission of the blogger. SQLite The Android platform embedded a relational database, SQLite, which, unlike other databases, does not need to specify a data type when storing data. A field is decl ...

Posted on Sat, 23 Mar 2019 11:18:54 -0400 by jmcneese

Implementation of OCI Calling Oracle Stored Procedures

OCI calls stored procedures Recently, in the development of wind control framework, there is a scenario that programs need to call stored procedures in Oracle, but the current framework does not support it. It only supports invoking assembled SQL statements, that is, basic database addition, deletion and modification operations. Thus, OCI cal ...

Posted on Sat, 23 Mar 2019 09:27:52 -0400 by corporateboy

rsyslog collects network device logs

Install rsyslog rpm -qa rsyslog #CentOS7Default will install rsyslog yum install rsyslog-mysql -y #rsyslogUse this module to pass data in MySQL Database, must be installed Import rsyslog-mysql database file Import database # cd /usr/share/doc/rsyslog-7.4.7/ # mysql -uroot -p<mysql-createDB.sql # Enter password ...

Posted on Fri, 22 Mar 2019 13:03:52 -0400 by padma

Keyword Method of SQL Query Statement

Some keywords commonly used in SQL 1. distinct keyword Displays a list of names, prices and categories of goods that are not duplicated select distinct ware_name,price from t_ware; 2. Use computational columns Check the prices of all commodities after they have been increased by 20%. select ware_id,ware_name,price*1.2 from t_ware' 3. Al ...

Posted on Fri, 22 Mar 2019 01:54:52 -0400 by mooshuligan

Understanding and understanding of sql statements in oracle

Recently, because the front-end often needs to query the database, according to different conditions to query the data and display. Here we meet some problems of sql statements. Now we summarize them. First I paste out my sql statement, in which the model table is the main information table of the query, and then in not exists I query that the ...

Posted on Thu, 21 Mar 2019 13:36:52 -0400 by ole968

Detailed examples of SQL SERVER partition

In our daily work, we will encounter the following situations: a table grows by tens of thousands of degrees every day, and the data queried is usually used occasionally this month or this year, but the efficiency of query and insertion is slower and slower. Using database partition will help to solve this problem. There are a lot of theoretica ...

Posted on Thu, 21 Mar 2019 11:21:53 -0400 by Rodders

Implementing AOP Based on RealProxy.Net

I. overview About AOP (Aspect-Oriented Programming), let's start with an everyday scenario called "Error Log Recording". Generally speaking, when we code, we want to record error logs by try. catch. Slowly, you will find that every method has to add try. catch to record the error logs of every method. And what can be done to achieve a ...

Posted on Thu, 21 Mar 2019 06:51:53 -0400 by ntbd