Previous issue resolution records and issue resolution records
------------------------- Html/css ----------------------------------
The QR code at the bottom of the web page is visible, and the text block on the right disappears. It turns out to be a width problem. Modify the width and the two divs will be 49%.
Similar to the li at the bottom of Baidu or Baidu, it will appear. Use list-style: none; global
Some quartz records and quartz records
Scheduled tasks always run in the case of overlapping tasks. For example, if a task is executed once every minute and the task execution time exceeds one minute, two identical tasks are executed concurrently. Sometimes we allow this situation to happen. For example, the Code executed by a task is idempotent, and sometimes we may consider that it is not allowed to happe
When PHP reads the records in the database to generate XML, the records contain Chinese characters. what should I do if I want to use the DOM function of PHP to generate XML documents? if the documents contain Chinese characters, an error occurs, that is, it is useless to use CDATA to contain Chinese characters, the code is as follows:
$ Owen1 = 'Student Work ';
Header ('content-type: text/XML ');
$ Resul
Large website records and website records
Reading experiences in "technical architecture of large websites: Core Principles and Architecture Analysis" (I hope you can correct the mistakes if any of the following statements are correct)
1. Machine Evolution
Initial architecture level 1: an application server contains applications, files, and databases.
Level 2: divided into three server application servers,
[Batch records] Batch records and links in UNC tunnels
In order to prevent other users from installing the python programTherefore, I share the python portable version winpython with samba.However, if you want to enable the winpython cammand prompt. exe command, it's too troublesome.So I used the batch program to directly compile my python program.Pushd is used because it is a shared space.% ~ Dp0 is the c
MySQL database to view the data table space and number of records, mysql records
If you want to know the space occupied by each table in the MySQL database and the number of rows recorded in the table, you can open the information_schema database of MySQL. There is a TABLES Table in this database. The main fields of this table are:
TABLE_SCHEMA: Database NameTABLE_NAME: Table NameENGINE: The storage ENGINE
How do I randomly select n records or sort records randomly? Q. How do I get the random sorting result?
A. You can use random numbers to obtain columns in random sorting or return x randomly selected columns. However, the RAND function can return only one result in a query. You can create order by on the columns returned BY the NOWID function. See the example:
SELECT *FROM Northwind... OrdersOrder by ne
Linux environment deployment records (1) and linux environment deployment records
Time settings
View the current system date/time:
date -R
View the system hardware clock:
hwclock --show
Set the hardware time:
hwclock --set --date="07/18/17 20:55"
Time Synchronization with hardware:
hwclock --hctosys
Time zone settings
tzselect
Select Asia-> China-> Beijing-> YES.
Port/firewall Problems
Check the usage of
Two failed django application records and failed django application records
Sharing the process of solving the problem is valuable, but I did not solve it at last. I just came to two possible conclusions.
First question:
I found a django application called simple-blog on github and wanted to add it to my project.
Python setup. py install is successful
Added this entry in urls. py.
Url (R' ^ blog/',
View User Logon records in Linux and user logon records in linux
User logon information is recorded in utmp (/var/run/utmp), wtmp (/var/log/wtmp), and btmp (/var/log/btmp) and lastlog (/var/log/lastlog) files.
Commands such as who, w, and users query the information of the currently logged on user through the utmp (/var/run/utmp) file.The last and ac commands use the wtmp (/var/log/wtmp) file to query the i
PHP learning records and PHP learning records
This is my first blog. I am a beginner in PHP. I didn't know anything about it before. Now I am going to buy some books to study. I am not talking about it. Let's start recording my notes.
Function: The English name of a function is function, that is, the meaning of a function. You need to add function + function name + parameter + content to a user-defined fu
Share Component usage records and component records
Sharing components are often used in applications. Of course, many third parties provide social sharing services, such as ShareSDK and umeng.
This is neither sharesdk nor umeng.
Record the integration details today:
① No matter which platform you share, you must register an application on this platform.
② Take sharing to, circle of friends, and Weibo as an
--Query a table to effectively remove duplicate records, UserID as a self-growing primary key, Roleid as a repeating field
The code is as follows
Copy Code
SELECT MIN (UserID) as UserID, Roleid from Tmptable GROUP by RoleidSELECT Roleid from Tmptable GROUP by Roleid (COUNT (*) > 1) to get duplicate recordsSELECT DISTINCT * from tmptable filter Duplicate records
Chinese characters
According to the initials of Chinese characters, to find relevant records in the table, how to achieve? For example, enter "Zgyh", you can find all the "Bank of China" records.
if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ F_GETPY] and Xtype in (n ' FN ', n ' IF ', n ' TF '))
Drop function [dbo]. [F_getpy]
Go
--Create phonetic function
Create function f_getpy
Label:You may encounter two problems when you update large amounts of data:
If each update executes a SQL performance is low, it is also prone to blocking;
There may be problems with primary key duplication when you batch update
Use on DUPLICATE key to update a SQL to resolve bulk updates and primary key duplication issues (ID primary key) INSERT into MyTable (Id,pid,ele,anim)
VALUES (?,?,?,?), (?,?,?,?), (?,?,?,?)
On DUPLICATE KEY UPDATE pid=values (PID), Ele=values (ele)
//
Xcode comes with git usage records and xcode comes with git recordsI. Two Methods for creating. git files1. When creating a Project, if you select Create git repository, you can see the hidden. git file..How to view hidden files: (1) Enter defaults write com. apple. finder AppleShowAllFiles TRUE on the terminal;(2) Enter killall Finder.2. Download Command Line Tools in XcodeIn this way, even if you do not selectCreate git repository, or you can Create
Delete from bonus A where . rowid! = ( select max ( rowid ) from bonus B where . ename = B. ename and . job = B. job); use a pseudo column.
1,Oracle, Each record hasRowid,RowidIt is unique in the whole database,RowidIt is determined that each record is inOracleWhich data file, block, and row is in.2In duplicate records, all columns may have the same content,RowidWill not be the same, so as long as the duplicate record i
Insert 10000 records, insert 20000 records in 0 seconds, insert 30000 records in 2 seconds, insert 40000 records in 3 seconds, and insert 50000 records in 3 seconds, 60000 messages are inserted in 4 seconds, 70000 messages are inserted in 5 seconds, 80000 messages are insert
Problem description
In the production database, the data of one table is 1 billion level, and that of the other table is 10 billion level. The data of other tables is also quite large. I didn't know that these tables had such a large amount of data before I got started, so I used to use count (*) to calculate the number of records in the table. However, this execution was terrible. After running for more than 30 minutes, no results were returned. In
1. After testing, the following method is passed:
Select * from(Select Table name. *, rownum as con from table name where rownum )Where con> = N;
2. Refer to other online methods
SQL/Oracle Method for retrieving records from MB to n
Use an SQL statement to retrieve the m to N records
Use an SQL statement to retrieve the m to N records
Retr
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.