I'm learning about stored procedures in mysql (5.5), and have hit a bit of a mental block here about what can be done using sprocs.
The base data looks like this:
select * from fruit;
name | variety | price | quantity
---------------------------------
Pear Comice - 15 - 2
Pear Barlett - 20 -...
@LewsTherin ok, so, going to the basics. Imagine you have the sales data of some store. It's all on one big table, with every transaction that gets made. How do you calculate fast the sales amount for this month?, imagine you have many stores and millions of transactions per week
The network admin here uses 3rd party software to back up our SQL database using the VSS writer service, which breaks the backup chain. He's very much against changing that policy, but I feel strongly that it would be better to let SQL manage the backup process, and to backup the backups with the 3rd party software. I'm not sure if this is reasonable or not, and would be looking for strong arguments to demonstrate the reasoning behind this, along with documentation, preferably from Microsoft
@JNK @Lamak maybe it would be better if he just downloaded the Microsoft example cube and played around with it in excel. That should pretty quickly give him an "aha" moment.
@JNK I don't think so... one is ArcServ and the other is LiveVault/Iron Mountain (don't know if you've heard of either). Both appear to break the backup chain when they run, and I don't see any settings for changing it to copy-only
i just can't find where's the error in the php file. Its still showing the error:
"Parse error: syntax error, unexpected $end in /var/www/html/admin/maker/plan_informeinfo.php on line 897"
Please! Help, i don't know how to figure that out
This is the code:
<?php
// Global variable for ta...
But seriously, it's a bad question and already voted down far enough to kick it off the front page and make the user feel bad. Why bring it up here for more downvotes? :p
@FreshPrinceOfSO I do?, don't remember that. I do remember having downvoted Aaron, though I still swear that I don't know how did that vote got there in the first place
I have a list of items in a table that have ids, and I want to put them into a item_to_group table, all with a specific group number.
My MySQL code is:
INSERT INTO `item_to_item_group` (`items`.`id`, 3476)
SELECT `id`
FROM `items`
But I'm getting the old "You have an error in your SQL syntax"...
Please; stop adding unnecessary tags to questions. This just makes it look like you're doing it to get the badges. Myself and others will continue to remove them and roll them back if need be. — FreshPrinceOfSO4 secs ago
@Lamak I don't think there is anything wrong with sql-update. It is the same thing as using the sql-like but the issue is he is adding them to EVERYTHING
There are plenty of times that I will VtC a question as too localized but will add an answer to help the user, especially if the answer will be too long for a comment
@FreshPrinceOfSO I don't think he ever closes anything
Like this one, I Voted to Close it but gave the user an answer.
You have a few issues with your query.
First, you are attempting to create an alias using a reserved word group. You will have to escape the reserved word using backticks. Also, you should have separate sets of backticks around the table and columns name, they should not be enclosed in a single...
@JNK I still don't understand why on your meta question, you got the "only on emergencys" comment, and then we have this one on a previous question today:
Public Service Announcement: There are only two ways to remove a tag without involving a Stack Exchange Developer: synonymizing the tag with another tag, or removing each tag instance individually. Developers are only involved when it's an emergency. — Robert Harvey5 hours ago
In 2009 I've made a machine with a working MySQL database and a copy of the HD with dd.
The machine has worked fine until some days ago.
Now, when I enter in the database I obtain:
Didn't find any fields in table 'CoBi'
Didn't find any fields in table 'diam'
Database changed
When I query thes...
@LewsTherin You first want to define what group of measures you want to analyze, so let's say "Sales". This means that I want to see amount, costs, revenue, number of items, etc
@LewsTherin I don't know if you are talking about a star schema on a relational database level or about the hierarchy relations on the multidimensional level
And in the example you gave here, if there is an index on the four columns mentioned, it will likely be used as opposed to the clustered index, since it is skinnier but still has to scan. DO NOT RELY ON ORDERING WITHOUT A WELL-DEFINED ORDER BY. — Aaron Bertrand39 secs ago
@LewsTherin Some people use the same name when talking about a schema of a fact table (on a relational database) surrounded by dimension tables (star schema), and when they talk about how the attributes on hierarchies are assigned on the dimensions on the multidimensional databse
@LewsTherin that's basically it. You have this "attributes" that you can use to slice your "measures", always thinking about performing some aggregation on them
so you can easily see the sales by city and year and month and not waiting hours to get those results
@LewsTherin nope, you could think that the data from that the multidimensional database use as a source are tables, but the result is a cube with dimensions :-)
@LewsTherin try not to give it a physical interpretation, at least not literally
I'm learning about stored procedures in mysql (5.5), and have hit a bit of a mental block here about what can be done using sprocs.
The base data looks like this:
select * from fruit;
name | variety | price | quantity
---------------------------------
Pear Comice - 15 - 2
Pear Barlett - 20 -...
i just can't find where's the error in the php file. Its still showing the error:
"Parse error: syntax error, unexpected $end in /var/www/html/admin/maker/plan_informeinfo.php on line 897"
Please! Help, i don't know how to figure that out
This is the code:
<?php
// Global variable for ta...
I have a list of items in a table that have ids, and I want to put them into a item_to_group table, all with a specific group number.
My MySQL code is:
INSERT INTO `item_to_item_group` (`items`.`id`, 3476)
SELECT `id`
FROM `items`
But I'm getting the old "You have an error in your SQL syntax"...
You have a few issues with your query.
First, you are attempting to create an alias using a reserved word group. You will have to escape the reserved word using backticks. Also, you should have separate sets of backticks around the table and columns name, they should not be enclosed in a single...
In 2009 I've made a machine with a working MySQL database and a copy of the HD with dd.
The machine has worked fine until some days ago.
Now, when I enter in the database I obtain:
Didn't find any fields in table 'CoBi'
Didn't find any fields in table 'diam'
Database changed
When I query thes...
