I tried out all the answers. But this following code helped me. All the comments and answers were useful and valuable in one or other situation. Adam Fischer Adam Fischer 1, 10 10 silver badges 23 23 bronze badges. Backup You can generate a sql dump file with the shell command mysqldump.
Restore The restore from a sql file can be done by using the mysql shell command. Henrik Henrik 2, 1 1 gold badge 22 22 silver badges 32 32 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Who owns this outage? Building intelligent escalation chains for modern SRE.
Podcast Who is building clouds for the independent developer? Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer.
Linked Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback?
Submit feedback. Fetch supports pausing and resuming downloads using the request's id. A request's id is a unique identifier that maps a request to a Fetch Download.
A download returned by Fetch will have have an id that matches the request id that started the download. Add the following Gradle dependency to your application's build. You can create your custom downloaders if necessary.
See the Java docs for details. If you would like to take advantage of RxJava2 features when using Fetch, add the following gradle dependency to your application's build.
RxFetch makes it super easy to enqueue download requests and query downloads using rxJava2 functional methods. Introducing the FetchFileServer.
You can host file resources with the FetchFileServer on one device and have to Fetch download Files from the server on another device. See the sample app for more information. Wiki on FetchFileServer will be added in the coming days. Start using FetchFileServer by adding the gradle dependency to your application's build. Start a FetchFileServer instance and add resource files that it can serve to connected clients. Migrate downloads from Fetch1 to Fetch2 using the migration assistant.
Add the following gradle dependency to your application's build. Fetch can only get better if you make code contributions. And I hope that I posted my question to the right thread this time. A reader, February 07, - am UTC. Hi Sir, Just have a question regarding previous posted question on Feb. Is it really doable by just using SQL? Or have to use reporting tools? February 07, - am UTC. The contra id determined by the column MID. MID values' are same for each contra item.
February 09, - am UTC. Vapan, February 09, - am UTC. Tom, Sorry for not being clear with the test case I gave above. The requirement is : The query needs to do this: a. February 09, - pm UTC. If the username exists, the query must return the name of the database and the username. February 11, - pm UTC. February 12, - am UTC. Then, fix the grievous error by taqking these three maybe 6 fields and put them into one, the way they belong.
Not sure why I got the error from the shell script. I'll look further into it Thanks. February 12, - pm UTC. A reader, February 12, - pm UTC. Hi Tom, I have a requirment where I've to break all rows in table in 10 batches. For e. If I have rows in a table then first rows would in batch 1,next rows would be in batch 2 etc How can I do this?
Can I update this in a single udpdate statement? Hi Tom, We are using oracle 9i You told "in 9i, you'd need to have a "when not matched then insert nt values null " but it would basically be a big "no-operation" since all of the rows would in fact match Could you please explain? February 13, - am UTC. So, in 9i there would have to be a "when not matched", but since we are joining the entire table with itself by rowid -- the "when not matched" clause would in fact never "happen", so you can just put a "dummy" insert in there -- that'll never actually happen.
A reader, February 13, - am UTC. Hi Tom, I got it and implemented Merge statement to break the table into 10 batches.. Thanks a lot for the help. February 15, - pm UTC. Hi Tom, Please have a look at this query. Can this query be put in any other way??
I would like to eliminate union all from this query. But it is not working properly. Can you provide some other way?? February 17, - pm UTC. Tom, Excuse me for not replying immediately to your followup above with title "Efficient way to get counts" Your followup was: "need more info, is this table modified during the day or is this a warehouse.
Is this table modified during the day or is this a warehouse: This table is modified regularly during the day. But the query that I have asked for is run only for reporting purposes.
I went with the sum case.. March 14, - pm UTC. Thiru, March 14, - pm UTC. Having a very few values for the columns, that's what I thought of. Does this affect performance in the normal running of the application and in the queries for reporting purposes?
Thanks for the time. Thiru, March 15, - am UTC. March 15, - am UTC. Steve, March 29, - pm UTC. Tom, I am not sure if the folowing logic can be done by a single sql. Thanks in advanced!
March 29, - pm UTC. Joining three scripts and get values for three columns. Dawar, April 05, - pm UTC. Tom, I need to run below script which displays only three columns. April 05, - pm UTC.
Dear Tom, The following query takes around 45 seconds Indexes are in place. The view called in this query runs very fast and the response for the view is less than a second. Can you please give inputs to improve the performance?
Are joins bad here? Should we rewrite the query? April 06, - am UTC. I cannot tune every query.. Also, applying functions to database columns typically prevents the use of indexes on that column. Tom, Thanks for the inputs. Please clarify on the following: 1. This being the case how the index would be bad during select operations. But the consistent gets continue to be the same as shown below.
Is there any other part of the query to look at and modfiy? April 07, - am UTC. Alex, May 24, - pm UTC. Hi Tom, I have a quick question about my decode I'm trying to do but I don't know if what I'm doing is allowed or not. I'm doing: select a. May 24, - pm UTC. However a parent record can exist without any children. I wrote this but it does not work. Is there a way to join both tables and find the maximum followup number record to join and also find records in parent that do not have children.
For record 50 which does not have children I want to only check "date resolved" field. May 28, - am UTC. A reader, June 06, - am UTC. June 06, - am UTC. We have a lot of customers making the same orders, and want to select such customers's orders as a bulk, then create file and ship those orders thru fedx as a one set.
The number of orders in such bulk should be more than 3. Let's say, if more than 2 orders have 10 ordered item 1, 20 items 2, this is a bulk 1. And so on. A reader, June 06, - pm UTC. Sorry, I need it and will try again.
June 06, - pm UTC. If you don't know the number of items on an order How about this? I've been trying to think of a more effficient or at least more "elegant" way but so far this is the best I could come up with.
I hope it helps. Hi Tom, My requirement is "I would like to get grouped rows from EMP table where no individual makes more than " I tried this query but getting errors. June 10, - am UTC. Hi Tom, My requirement is: I want to exclude grouped rows when atleast one individual in each group gets a salary of more than June 10, - pm UTC.
Hi Tom I wanted to find a way to fetch from emp table where I pass deptno. And if deptno is not in emp then fetch all. And this is what I did.
June 14, - pm UTC. Hi Tom You are right and some time I want to figure out some way to work around possibility in shorter and correct way. Although I can have two blocks in if statements and either one will work. That's double coding and if I add just 'were' clause then will it work?
What I am trying to get is that if I pass deptno which exists then get me that dept and if not exists then from all deptno. June 15, - am UTC. Hi Tom Thanks and you showed one more way to do this. A reader, June 15, - pm UTC. Hi Tom, I have 2 tables like create table t1 id1 number, name varchar2 60 , id2 number ; create table t2 id2 number, xxx char 1 ; insert into t1 values 1, 'firstname', 1 ; insert into t1 values 2, 'secondname', 2 ; insert into t2 values 1, 'A' ; insert into t2 values 1, 'B' ; insert into t2 values 2, 'A' ; insert into t2 values 2, 'B' ; commit; I have a query select t1.
June 16, - am UTC. A reader, June 16, - am UTC. No firstname will always have only 2 rows and so will secondname. A reader, June 16, - pm UTC. Is there an easier way to do this in that case? Thanks a lot for your help Tom. I have a similar requirement but I am selecting around 20 fields and so my "group by" clause also has 20 columns. If I try a similar query with the 20 fields, it is taking a very long time, do I have to do anything special for that? Please let me know. A reader, June 17, - pm UTC.
Our database is 10g. I setup the session for trace level 12 and I am attaching below the last part of the tkprof output. Is this what I should be looking at for the wait times. Please let me know and if it is tell me what I should see to determine how to make my query faster. June 17, - pm UTC. Does that seem "fast or correct" given your hardware?
A reader, June 20, - am UTC. I am sorry but I am not able to understamd much from your response. Can you elaborate it a little please? June 20, - pm UTC. Regd the following query from previous followup select t1. I have an index on t2 xxx. But it is still doing a table scan and the query results are very slow. Should I create some sort of functional index or something? I would be seriously disappointed if it touched an index, if you want slow, make it use an index. A reader, June 21, - am UTC.
Ho Tom, Will you please help me with this. I have a table that looks like below: col1 col2 1 1 2 2 3 3 4 4 I would like a select statement that displays: col1 col2 1 1 2 1 3 1 4 1 In other words, I'd like the value in col2 to show the smallest value of all rows. Thank you very much. June 21, - pm UTC. A reader, June 21, - pm UTC. Hi Tom, I have the foll requirement: create table t1 datecol date, idcol1 number, idcol2 number, col1 varchar2 20 , charcol char 1 , opcol varchar2 10 ; I am doing the following queries in a single procedure all based on t1.
June 23, - pm UTC. I thank you for your suggestion but how can we do that on an non-enterprise version? I use Oracle 9i. Tom, I am running this query and every time getting different answer.
Is it a bug or feature mind you I am the only one logged in. Thank you in advance. Tom, Essentially query had to answer very simple question "show me all distinct loan ids and programs" but I started testing and could not understand why same query returns different number of rows. Why would Oracle select any random number of rows when I asked to show me all 29 or less?
June 24, - pm UTC. It is free to get any 29 rows it wanted to get, and distinct them. It could return anywhere between 0 and 29 rows at any time. Tom, 1. Would it be safe to say that Distinct is sort of Group By clause? If so how is it internally different or similar? If Oracle is free to give me any number of rows below 30 how would I find out exact count of unique Last Names of occupants in a stories building below 30th floor? June 27, - pm UTC. Hi Tom, My requirement is "Retrieve all employees from emp table who have joined before their manager".
I used this query. Is this correct?? Do you have a better way to put this query?? June 28, - pm UTC. Given the data, it might appear to work -- but there is no rule that says the manager has to work in the same deptno.
One organization can have multiple contacts. I am trying to get a query to get the organization record with the main contact.
How can you solve this problem? July 06, - pm UTC. Tom: My query did not give me what I wanted. Thanks a lot,. July 07, - am UTC. Tom, I am not sure whether my question fits this thread but if you could reply, shall greatly appreciate. Is there a way to do this without writing all the columns.
Thanks so much for your time. July 08, - pm UTC. Other alternative would be to create a one time view without the columns you don't want. Thiru, July 08, - pm UTC. The sql from the dictionary looks comfortable.
A different sql question!! Eray, July 12, - am UTC. Tom; I have question about sql- customizing the order-. Let me give you an example. I am selecting data starts with A,B,C I want to sort my data A to Z except K. I want my data which starts with K at the end? If I can how I can? July 12, - pm UTC. Here are some tips and examples of exporting and viewing the audit log before and after you use the JSON transform feature to split the AuditData column into multiple columns.
Filter the RecordType column to display only the records from a specific service or functional area. For example, to show events related to SharePoint sharing, you would select 14 the enum value for records triggered by SharePoint sharing activities. For a list of the services that correspond to the enum values displayed in the RecordType column, see Detailed properties in the audit log.
Filter the Operations column to display the records for specific activities. For a list of most operations that correspond to a searchable activity in the audit log search tool in the Microsoft compliance center, see the "Audited activities" section in Search the audit log. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No.
0コメント