Tag:not
-
Time:2020-8-11
Some time ago, when I was doing a small function in the company, I counted the number of data in a certain situation and then modified the problem. At that time, I thought it was very simple. I wrote the following SQL: SELECT COUNT(*) FROM t1 where tl.c1 not IN (SELECT t2.c1 FROM t2); The […]
-
Time:2020-4-18
Preface Recently, my colleagues found a problem: the buffer get in 12C is very high, but the buffer get in 10g is very low. Doubt there is a problem with the optimizer of 12C. In this 10g environment and 12C environment, the amount of data is roughly the same, but there are only a few […]
-
Time:2020-4-13
Command not found solution for Linux timed tasks The first step is to view / etc / Profile: The second step is to modify / root /. Bash “profile: Add command path at the end Step 3: modify the shell script: #!/bin/bash . /etc/profile . /root/.bash_profile The following is added to the script: Thank you […]
-
Time:2020-3-18
: not pseudo class selectors can filter elements that do not conform to expressions Example table tbody tr:not(:first-child):not(:last-child) td { text-align: right; } In the above code, you can select tr that is not the first and last in the tbody part of the table table, and set its sub element TD text style to […]
-
Time:2020-1-17
Node.js prompt error: Error: EXDEV: cross-device link not permitted, rename ‘C:\Users\THEDIS~1\AppData\Local\Temp\upload_9b46f1afc2f9ade074037c3fb707d271’ -> ‘E:/node-rumen/tmp/test.png’ Error calling fs.renamesync method when uploading files This prompt is about the permission problem of cross region rename file. Resolvent First copy from the source file to the target file of another partition, and then unlink. form.parse(request, function(error, fields, files) { console.log(“parsing […]
-
Time:2019-11-20
1. Function and grammar description Function: a regular expression uses a specified string to describe and match a series of strings that conform to a syntax rule. Many programming languages support string manipulation with regular expressions. Mongodb uses the $regex operator to set a regular expression that matches a string. Grammar 1 { <field>: { […]
-
Time:2019-6-18
Often, colleagues ask how to deal with the operation not permitted error when deleting files/directories. This is generally a matter of authority, such as: 1. Ordinary users with sufficient privileges may use this folder by other services/processes. lsof +D /Dir/Your/Want/To/Delete/ First execute the above command, query the process IDs that call the folder, and then […]
-
Time:2019-6-12
A colleague asked me to help him locate, why his LINUX server many commands can not be used, prompts (command not found), and more importantly, many system services, scripts can not run. What have you done before? He said what to do, but added export PATH in the / etc / profile file, and asked, […]
-
Time:2019-3-23
When using mongodb, there is a “not master and slaveok = false” error because secondary does not allow reading and writing. Because mongodb is the master and backup in the system, switching between the master and backup may also lead to this problem. Replace the IP in the command Mongo — username = root — […]
-
Time:2019-3-22
In today’s project optimization process, MySQL has a problem: The user specified as a definer (‘wx_root’@’%’) does not exist Check it. It means execution.sqlNo permission. Look at the following database users arequoters SQL has no ownership. That’s why. It was found that during SQL execution, a stored procedure was invoked And the creator of this […]
Tags:
(''[email protected]''%''),
a,
Access view has no permission,
as,
definer,
does,
Executing SQL without permission,
Exist Solution,
mysql:the,
not,
specified,
user