add is a row, delete is also a row,Format: Delete from table name where qualification, such as delete from blog where uid=1;Be sure to add the where condition, without the Where condition will delete the data.Select queryFormat: Select column 1, column 2, column 3 where qualification1. Query all rows of the table for all columns select * from blog; In development, try not to write as much as the data in the table, so that the query will add to the burden of the server, need a few data, just a f
ParadigmElimination of dependencies on the master code subset on a 3NF basisSuppose the Warehouse Management Relationship table is storehousemanage (warehouse ID, store item ID, Administrator ID, number), and an administrator works only in one warehouse, and a warehouse can store multiple items. The following decision relationships exist in this database table:( Warehouse ID, store item ID) → ( administrator id, quantity)( Admin ID, store item ID) → ( warehouse ID, quantity)So it came up:(wareh
=pymysql.cursors.dictcursoR) #这样返回的就是字典def ex_sql (Self,sql):TrySelf.cur.execute (SQL)Except Exception as E:Print (' SQL statement problematic,%s '%sql)ElseSelf.res = Self.cur. Fetchall ()Return Self.res###Destructors Def __del__ (): Pass Executed when the instance is destroyed.######my = MyDb (' 118.24.3.40 ', ' jxz ', ' 123456 ', ' jxz ')My.ex_sql (' select * from Stu; ')Print (My.res)Print (' I'm the last line of code ...') #这里才会执行析构函数. The destructor is executed when the instance
. The GSD coordinates with the cluster Manager-to-receive requests from clients such as the DBCA, EM, and the SRVCTL utility To execute administrative job tasks such as instance startup or shutdown. The GSD is not a Oracle instance background process and is therefore no started with the Oracle instance.. ONS, which refers to the release and subscription services of the ONS (Oracle Notification service), the Fast application notification (fan:fast application Notification) event for communication
Label:
int: An int type of 4 bytes in SQL with a length of 1 represents the length of an int type
Symbol-Differentiated range: 2147483647~-2147483648
VARCHAR: A varchar type can contain a number, letter, kanji, such as a field of length 15 can hold 15 characters, numbers, letters
Tinytext: The default length is 255, numbers, letters, Chinese characters are all one length
All of these are pro-measured data, tested only a few, there are other types after the repair, the code is UT
Label:Pk:primary Key (column is part of a PK) primary keyNn:not Null (column is nullable) non-nullUq:unique (column is part of a unique key) uniqueAi:auto Increment (the column is auto incremented when rows are inserted) self-incrementBin:binary (if DT is a blob or similar, this indicates, which is binary data, rather than text) binary (larger binary than text)un:unsigned (for-integer types, see docs: "10.2.) Numeric Types ") integerZf:zero Fill (rather a display related flag, see docs: "10.2. T
downloads self-installed software (software provided by default from the Ubuntu distribution) in this directory. This directory also has BIN,ETC, include, Lib and other subdirectories./usr/sbin: System commands that are required for non-system normal operation. The most common is the daemon command for some Web server software, such as Nginx, NTPD, mysqld/var: if/usr is a directory that occupies a larger hard disk capacity during installation,/var is the directory that gradually consumes the ha
Tags: GPO tmp must be System OCM data scheduled task pop messagesLinux system logs:
/var/log/secure:Record log in system Access data files, such as Pop3,ssh, Telnet, FTP, etc. will be recorded in this file;
/var/log/wtmp:Record the information of the logged-in person, as this file has been encoded, so you must use the last command to remove the contents of the file;
/var/log/messages:This file is quite important, and almost all the error messages (or important information) that
Tags: com quick share pictures other tar Lin Alt first technology-rwxr-xr-x 1 root root 1904 Apr startup.shThe first character,-Represents file D for folder L for: Soft connection file (similar to a shortcut under Windows)From the second character, each character represents a permission,In turn (read r=4) (write w=2) (run x=1), each three characters represents a class of usersRWX: Indicates that the file owner (root) has read and write run permissionsR-x: Indicates that other users of the same g
${variable name: num:num1}: Character ${variable name from num to NUM1 #word}: Remove the shortest matching word substring ${variable name from the beginning of the variable # #word} : delete longest matching word substring ${variable name from the beginning of the variable%word}: percent of percent removed from the right: delete the matching longest match from the right of the variable Word,word can be (A*c represents yes A to c,[0-9]) ${parameter/pattern/ String}: Use the first instead of the
It's The section, the man, page for the command was assigned to.These is split as
General commands
System calls
C Library functions
Special files (usually devices, those found In/dev) and drivers
File Formats and conventions
Games and Screensavers
Miscellanea
System administration Commands and Daemons
Original descriptions of each of the can is seen in the Unix Programmer ' s Manual (Page II).The meaning of numbers in pare
combination with cp -u ("Copy if the SOURCE file is newer than the destination file or when The destination file is missing ") or for the creation of the empty marker files.The field st_atime is changed by file accesses, for example, by Execve (2), Mknod (2), pipe (2),Utime (2) and read (2) (of more than zero bytes). Other routines, like Mmap (2), may or could not updateSt_atime.The field st_mtime is changed by file modifications, for example, by Mknod (2), truncate (2), Utime (2)and write (2)
, command 1>a 2>1 and command 1>a 2>a still have a difference, the difference is that the former only open a file A, the latter will open the file two times, and cause stdout to be stderr covered. 1 can be understood as a reference to a standard output, and the reference is to redirect the standard output to produce an open a. Higher command 1>a 2>1 efficiency than IO efficiency command 1>a 2>aThink again.Why did 2>1 put it behind? My understanding is that because 2 (that is, the error output)
Python: The Meaning of self and __init__ + why have self and __init__ backgroundsReply:I wrote some python tutorials that need to be able to seeQuestions from Songshoujiong:What is the meaning of self,__init__ in python?Why do you have to have self,__init these things?Before you explain, let's say a few words.1. So far, although I have written not very little Python code, but there is really not too much co
We all know that Chinese characters are hieroglyphs, but if English is also hieroglyphics, you will think pure nonsense. In fact, the origins of the 26 letters of English do come from hieroglyphs. The 26 letters originally originated from Egyptian hieroglyphics, and the Phoenician alphabet was later modified by the Phoenicians, and the Greeks reformed the Phoenician alphabet to create the Greek alphabet, in which the ancient Romans reformed the Greek alphabet and invented the Latin alphabet, whi
The meaning of life, a very large and broad question, there is no definite answer. Everyone has a different view and understanding, 1000 readers there are 1000 of Hamlet. When you see this book, you must also be thinking about what is the meaning of life, how to live out the meaning of life."Life is meaningless, but you have to define a
After reading the book, "living out the meaning of life," a lot of feeling, "what is the meaning of life?" "This is a very hard question to answer. Many of the sentences in the book are thought provoking, prompting me to think about my life and my own meaning.The author of "Living out the meaning of life" is the famous psychologist Frankel. He was a marvel of the
Meaning of "modal verb +have+ done"1, must has the meaning of done. "Must have+ past participle" means speculation in the past, meaning "must have been, presumably already, must have been ...", only used in affirmative sentences. For example:The streets is wet. It must has rained. The street is wet, it must be raining.He must has been drinking beer. He must have
CharactersMeaning: For a character, it is usually expressed as literal meaning that the next character is a special character and is not interpreted.For example:/b/matches the character ' B ', by adding a backslash in front of B, which is/b/, the character becomes a special character, indicatingMatch the dividing line of a word.Or:For several characters, the usual description is special, which indicates that the characters immediately followed are not
8th: The meaning of the pursuit of lifeThe author of the Quest for life is a psychiatrist who comes out of a concentration camp, with the energy of a concentration camp, creating a sense of treatment (legotherapy), which is less retrospective and less introspective, and its focus is on the future, In the work and meaning that the patient is going to accomplish in the future. People who know how to live, alm
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.