Description:
MySQL RDBMS technical discussions.
|
|
|
trigger to update the same table different row
|
| |
Hi,
i have table:
id | data
1 | aa
2 | bb
1 | cc
If i will update data in first row to 1 - abc
i need to copy this value to 1 | cc
so after update table should looks like this:
1 | abc
2 | bb
1 | abc
So i tried trigger, but there is an error
...because it is already used by statement which invoked this stored... more »
|
|
help to guide how to access mysql through ruby
|
| |
Hi i have ruby 1.9.2
and have installed dbi 0.4.5
when i tried to run a sample ruby file to get mysql version i got following erros.i have referred many sites,cannt clear,Plz guide me.
------------------------------ ------------------------------ ---
mmp@mmp-Lenovo-G560:~$ ruby simple.rb
<internal:lib/rubygems/custom_ require>:29:in `require': no such file to load -- parsedate (LoadError)... more »
|
|
6 vital Business Intelligence user requirements to understand
|
| |
Full Article
[link]
Brief
Typically, users will fall into one of three categories in relation to the timeliness of data required:
* Report broadcasts and scheduling: Many BI users won’t require real-time data access. For example, the marketing department of BigBrands Co. might rely on weekly sales reports to gauge the effectiveness of brand strategies and specific marketing campaigns over a significant period of time. Daily, or real-time reports – such as transaction level reports – would provide too much detail. The strength of BI in this instance is in its ability to track and identifying trends over time, while simultaneously allowing users to connect shifts in the data to real-life events (marketing campaigns) to support strategy development.... more »
|
|
Table design for online book.
|
| |
I am trying to puzzle out the best way of doing this: Essentially I have an entity called 'book' which is split into 'chapters' each one of which is a massive chunk of text. (let's ignore illustrations and diagrams for now).
I want to serve that as 'pages' of fixed geometric size into a fixed... more »
|
|
Mysql as DB2 client
|
| |
Hi
Is it possible to virtualize DB2 database into Mysql ?
I mean, Mysql as DRDA DB2 client
Thanks in advance.
-- .
|
|
Modelling question with identifying relationship
|
| |
I want to create tables Parents and Children. I started with what I have below and then used MySQL Workbench.
CREATE TABLE Parents
(
ParentID INT NOT NULL,
Name VARCHAR(45) NOT NULL,
PRIMARY KEY (ParentID)
);
CREATE TABLE Children
(
ParentID INT NOT NULL,
Name VARCHAR(45) NULL,... more »
|
|
Stats comp.databases.mysql (last 7 days)
|
| |
"Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 14 May 2012 07:08:22 GMT
Stats Begin...............: Mon, 07 May 2012 07:17:50 GMT
Stats End.................: Sat, 12 May 2012 21:32:14 GMT
Days......................: 7... more »
|
|
remote access mysql can't connect when changed from localhost to IP#
|
| |
Hello
I get this error when starting mysql using MysqlAdmin application
service window
...But when I relaunch mysqladmin I get the error
...There is no error log I can find with May 13 date
What changed is I got a permanent IP address using dyndns pro account
I did bind-address: XX.XXX.XX.XX on the IP address given.... more »
|
|
MY SQL Queries are Slow
|
| |
Hi,
I am using Application in one Server and MySql DB in another
server(Both are Linux). I am using the InitialContext and Datasource
for connection using java.Here my problem is Slow in Query execution
while calling from the application server. While I deploying the
application and the MySql in the same server it is fast. Here I am... more »
|
|
|