stored procedures, functions:Grant execute on procedure testdb.pr_add to ' dba ' @ ' localhost 'Grant execute on function testdb.fn_add to ' dba ' @ ' localhost 'Vi. Viewing MySQL user rightsTo view the current user (own) permissions:Show grants;To view additional MySQL user rights:Show grants for [email protected];Vii. revoke permissions that have been given to MySQL users.Revoke is similar to Grant's syntax, just replace the keyword "to" with "from":Grant all on * * to [email protected];Revok
Tags: mysqld window title MySQL modify use cannot condition directory forget root passwordmysql--4 ways to change the root password (take windows as an example)From: http://www.jb51.net/article/39454.htmThis article takes windows as an example for you to introduce the 4 ways to change the root password of MySQL, you can choose according to their own circumstances, hope to help everyoneMethod 1: Use the Set password commandFirst log in to MySQL.Format:
test_join_1 UNION All SELECT from test_join_2 UNION All SELECT from Test_join_3 ORDER by ID;6. Append StreamsA> getting data from two data sourcesB> take out all the data in the first streamC> Append data from the second stream to the first streamSimilar to SQL (Kettle execution results are consistent with SQL) are as follows:SELECT from test_join_1 UNION All SELECT from test_join_2;7. Prioritize streamsA> getting data from multiple data sour
Resigned in early June, in late June (number 20th) into the new company, began to take over the company's web site show when the optimization of the promotion, so far just 25 days, in this nearly one months time the site or some changes, personally feel that the whole is in the direction of good development, today to summarize the one months of the optimization process and results, Veteran look at the past, novice can pay attention to, may be helpful
;ORDERNBSP;BYNBSP;NONBSP;DESC) agroup bya.name;Query 3 This SQL is what we need to discuss and also the SQL used by the line of business to achieve the maximum value for the sort within the group. Standard Programmer feedback Problem mode:xxx point in time before the normal query, which suddenly is not normal, your DBA did what changes? I restored the data to my test machine, and the return value was normal. For the moment , whether the posture is correct, the analysis of this SQL, we can actual
Everything has a way, don't take it for granted, don't give up
Breaking the frame of mind, the vast majority of our lives will be eliminated, we can make ourselves fast and easy to achieve the goal of life. A summary of the ways to break the three barriers to the ideological framework is:
1. The "should be" approach: we do not know everything in the world, what has happened is supposed to happen. We should not sit there complaining, but accept and d
in fact, not to manage the time, but themselves . Manage yourself by exercising your mind. The mind refers to the sum of all the thinking abilities of a person. The mind contains three aspects of competence, access to knowledge, applied knowledge, and abstract reasoning.
the dilemma for all is that they are reluctant to take time to think . Socrates reveals that the so-called thinking process is "asking and answering", and Bacon says that reading mak
Select ranked. Wait Time from(SELECT *, Row_number () over (partition by TB. PATIENT_ID ORDER by TB. Wait time ASC) as RowNumFrom (select a.patient_id as patient_id, DATEDIFF (Hour,b.admission_date, a.oper_start_date) as wait timeFrom Pat_operation as a,pat_in_visit as Bwhere operation_code= ' Setmi_op01 ' and a.patient_id=b.patient_id and discharge_date>= ' 2014-04-01 'and discharge_date) rankedwhere Ranked.rownum Because each ID corresponds to two wait times I
Source: http://www.2cto.com/database/201208/145611.html Today, just take the month and the number of days, if 0 in front of the month to get rid of 0. For example, 2010-01-08, the required result is 1-8. Leads to a series of SQL statements first: using To_number function conversion Auto-intercept 0 Select To_number (to_char (sysdate, ' mm ')) | | ' -' | |To_number (To_char (sysdate, ' DD ')) from dual; Second: Remove 0 Select LTrim (to_char (sysdate,
Label: Author: Iamlasong 1. Demand two tables, delivery record table and sealing open the record table, now want to know the delivery date distance from the last date of the distribution of the number of days. for this demand, you need to check out the delivery details, the same time to know the corresponding mail last closure. such as institutions, dates and so on. 2. Detailed Inquiry consider that a day may be marshaled multiple times, so take the
Oracle execution plan-processing a situation where parallel hint does not take effectOn itpub, we can see that someone is asking the question that parallel hint does not take effect. I encountered the same problem after doing the experiment, as shown below:The reason is that this is a small table. When the table is joined, it is indexed. With the full hint, parallel execution plans can be started.You can al
The camera function of the Android system has been implemented in 2 ways, which can be used for reference:1. Call the system camera to take a pictureFirst, find the Androidmanifest.xml file to add user rightsSecond, add 2 controls (button and ImageView) to the main class Java file, which is used to trigger the button event and display the picture, which is purely a personal hobby.Final int take_picture = 1;//The camera that identifies your program in
Let's take you to know WebSocket in HTML5 and html5websocket.This article mainly introduces WebSocket in HTML5. This article explains what WebSocket API in HTML5 is, how to use WebSocket API in HTML5, and how to use WebSocket with Socket. IO WebSocket, NodeJS, and Socket. i/O joint development and other content. For more information, see
Understand HTML5 WebSocket
In HTML5 specifications, my favorite Web technology is the rapidly becoming popular WebS
the Android crop image, take a picture :All optional data for Intent ("Com.android.camera.action.CROP") is at a glance. After understanding the meaning of each of the above options, we look at three extremely important options:Data, Mediastore.extra_output, and Return-data.Both data and mediastore.extra_output are optional incoming data options, you can choose to set data to bitmap, or you can choose whether to return Data (return-data:true) by assoc
Comparison of Take, TakeWhile, Skip, and SkipWhile in Linq (convert), takewhileskipwhile
Reference: http://blog.csdn.net/lxfzgg/article/details/20534281
Take ()
Int [] numbers = {5, 4, 1, 3, 9, 8, 6, 7, 2, 0}; var first3Numbers = numbers. take (3); // starting from the first element, the previous number Console is used to obtain the three return statements. writ
Demo Source Location: Http://git.oschina.net/zj2012zy/Android-Demo/tree/master/AndroidDemo/headsetGenerally need user information of a lot of also need to set up the user picture, usually set the user's avatar manipulation either from the phone to choose a picture, or directly from the phone to take pictures to set up. As follows:In addition: the production of mobile phone dynamic screenshot, you can use the app Bao's dynamic screenshot function, very
Why design patterns? Let's take a look at the six principles and use the design pattern principles.
Introduction
I don't like reading books very much, because I forgot to read ten lines of books, so I read the left teacher and copied it to improve my memory.
This is the http://www.cnblogs.com/zuoxiaolong/p/pattern1.html of old brother left
Directly go to the topic, I believe everyone has entered this line, almost
thread state and java.lang.IllegalThreadStateException exceptions for Javaarticle structure:1 clarifying the six states of the Java Declaration cycle2 because of its own operation error, the same thread instance is called at the same time two times the start method to throw java.lang.IllegalThreadStateException this exception3 Super Brother take you to analyze why throw this anomaly4 Super brother want to see praise haha1 clarifying the six states of
Take notes on how to understand the magic methods of _ new _ and _ init _ in Python, __new ___ init _
I like Python very much. After reading the syntax, I learned about the Django Web development framework. I am familiar with Python. However, I still don't know a lot about it, because it is rarely used. Today I learned two magic methods: __new _ and _ init __.
Attack:
If you have a brief understanding of Python, you should know that it includes the co
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.