@RichardTheKiwi I have a script that does a backup on each db in the instance, except the 4 core. That's easily found on a google search. What's an easy way to restore all those files, or generate a restore script? I manually made one and generated it and have it in my source editor, but I don't know how to gen one
@RichardTheKiwi I still think you've missed my point, and I'm sorry if you didn't like the phrasing of my comment. I'm not sure how else to help you.
@RichardTheKiwi a one-line query means a simple query, not necessarily literally on exactly one line - though in this case, an update, it probably would be one line. But I'll be careful to use more literal and simpler phrases for you in the future.
@SQLkiwi I guess New Zealand has all sorts too, huh?
So why call me out in here about a phrase you didn't get?
And why tell someone you're tempted to flag their answer as not an answer? If it's not an answer, flag it. If you don't like the quality, down-vote it. Just saying you don't like the answer is not very friendly.
If words are not to be taken literally* (on a technical forum), especially around an i18n site, how should they be taken? Some users struggle to even communicate clearly in English, let alone master the skills of reading between the lines or deducing higher-level meanings. * most of the time
Once again, did my comments above not lay out exactly why I said what I said?
It's a simple update that could be written on one line. I didn't tell anyone they had to write it on one-line.
I also didn't say you were harassing me, and picking on is not the same as picking at. If you want to nit pick for being literal, then right back at you.
And we wonder why people abandon sites like StackOverflow.
@AaronBertrand So you're in the camp of "silent downvoting"? I prefer to let them know why, when I hit them. If I came across an older answer, I would have flagged it. But the answer was young and could be evolving, so I left a comment instead.
And yes I am in the camp of silent down-voting. You know why? Because there are more immature idiots on this site who thrive on vengeful behavior than there are people who appreciate constructive criticism.
I didn't feel that way for a long time but now I see exactly why if that were my answer I would have appreciated a down-vote more than your "I'm tempted to show you up" comment.
@AaronBertrand Fine. I can see that we don't see eye to eye. "And we wonder why people abandon sites like StackOverflow." and "abstaining from answering on SO" sounds a lot like attitude to me too.
@AaronBertrand "I'm tempted to show you up" comment." Don't know how you arrived at that, but ok.
Is there a quick way to draw tables on this site? I see ASCII tables a fair bit, but I'm not sure if the people that draw them do it manually or not...?
@RichardTheKiwi, @AaronBertrand, I don't really want to wade into your discussion as I might just as easily make things worse as better. For the record though, Richard, we appreciate your contributions on the site and in the chat room. Aaron can be oversensitive, and may or may not be currently sleep-deprived, and in this case I think he is being oversensitive, certainly not giving your comment that started this the benefit of the doubt.
On the other hand, Aaron is a great guy (who I've met personally), and talks a huge amount of sense–a tremendous asset to dba.se, and generous with his time and effort in many ways. We like him, and if that sometimes means putting up with him in minor, forgivable ways, so be it. I think you have conducted yourself in the discussion here with dignity and decorum.
We will never build a community here of people who think and communicate in exactly the same way, because no two people do that, but we can all get along despite that if we are willing to be occasionally forgiving.
Perhaps both of you would prefer if I minded my own business and kept my thoughts to myself–if that's the case I hope you'll forgive me and move on ;-)
I found a similar pattern in my tests as well with typical results below.
+--------+--------+---------+-------------------+
| @table | #table | ##table | [permanent_table] |
+--------+--------+---------+-------------------+
| 2670 | 2683 | 9603 | 9703 |
| 6823 | 6840 | ...
@SQLkiwi Jake has promised to add something similar to SQL Fiddle to you can cut'n'paste markdown straight from there to dba.se–I'm looking forward to that
@ypercube Ah ok, thanks. Must have been timing. I clicked, it turned black, clicked again and again, and I saw it toggle black, yellow... you get the picture
Can anyone help me understand this query? The mktpgmvhclxref.mktpgmvhclxrefId.mktgPgm part mostly. Generally it is table_name.columnName but here the format seems to be different
SELECT mktpgmvhclxref.mktpgmvhclxrefid.mktgpgm,
mktpgm.mktgpgm,
mktpgmvhclxref.cmpgn,
campai...
You don't have to break it up into multiple databases, so your foreign keys would be fine. We have run multiple publications for years, putting our lookup tables into one, and our transactional tables into another.
In the review queue for first posts by a new user
The 'answer' is no more than a response to a previous answer
But users < 50 can't comment, so should it be left as-is?
I created this sql DEMO :
I have #tbl1 :
___cola__
1
2
3
4
and #tbl2 :
_colb_
a
b
c
d
I want this :
_colb____|__cola____
a 1
b 2
c 3
d 4
I have found a solution ( bad IMHO)
SELECT table1.cola, table2.colb FROM
(SELEC...
Christ, there are some wankers on here today. Think I'm going to get my 100 days consecutive badge and not come back. The other days nonsense pissed me off enough as it is
Any data modellers here? If you're modeling a relationship, is there a convention that the parent table goes to the right of the child? Basically reading right-to-left, top-to-bottom..
Me: "I think that {{ in-house developer }} should run the tests because of the constantly demonstrated incompetence of the vendor support team" PM: "Let's leave out the editorial comments." Me: "I wasn't editorializing, I was justifying my position."
ok... My tool has an 'autolayout' functionality and it kept putting the parent to the top right and I was wondering why (while manually moving it to the left :) )
I have a problem like this (Error: Cannot load from mysql.proc. The table is probably corrupted): stackoverflow.com/questions/6789373/… and was wondering if running mysql_upgrade in a production system has any side effects I should consider.
My advise to save time: don´t use it or be deeply relaxed.
In my eyes this tool is absolutely shiX. Service is not available for me for the most time, server are not responding, unhelfpuf error messages like "MOS service not available, watch dashboard" - but dashbord shows nothing, problems down...
I'm using SQLite.
I need an help for an easy issue.
Here's my three tables:
--------------
problem
--------------
id (primary key)
question_id (foreign key)
--------------
question
--------------
id (primary key)
answer_id (foreign key)
--------------
answer
--------------
id (primary key)
I...
I was wondering who you guys were talking about earlier... dba.stackexchange.com/a/27647/13073 Looks like an extended comment that doesn't answer the question, and a link to SQL Injection prevention??
I found a similar pattern in my tests as well with typical results below.
+--------+--------+---------+-------------------+
| @table | #table | ##table | [permanent_table] |
+--------+--------+---------+-------------------+
| 2670 | 2683 | 9603 | 9703 |
| 6823 | 6840 | ...
Can anyone help me understand this query? The mktpgmvhclxref.mktpgmvhclxrefId.mktgPgm part mostly. Generally it is table_name.columnName but here the format seems to be different
SELECT mktpgmvhclxref.mktpgmvhclxrefid.mktgpgm,
mktpgm.mktgpgm,
mktpgmvhclxref.cmpgn,
campai...
You don't have to break it up into multiple databases, so your foreign keys would be fine. We have run multiple publications for years, putting our lookup tables into one, and our transactional tables into another.
I created this sql DEMO :
I have #tbl1 :
___cola__
1
2
3
4
and #tbl2 :
_colb_
a
b
c
d
I want this :
_colb____|__cola____
a 1
b 2
c 3
d 4
I have found a solution ( bad IMHO)
SELECT table1.cola, table2.colb FROM
(SELEC...
i also saved it
is there any way to recover it?
I'm using SQLite.
I need an help for an easy issue.
Here's my three tables:
--------------
problem
--------------
id (primary key)
question_id (foreign key)
--------------
question
--------------
id (primary key)
answer_id (foreign key)
--------------
answer
--------------
id (primary key)
I...
