Description:
MySQL RDBMS technical discussions.
|
|
|
Accessing two databases with one username
|
| |
I have an existing website that uses a MySQL database with 60 tables.
I'm working on a new website that will also use a MySQL database, with about 40 tables. However, one of these tables (`users`) will need to be identical for both sites, and inserts/updates come from the public so it will change often.... more »
|
|
|
Using mysql tables could never be any easier
|
| |
So you've been reluctant to use a database right?
Thinking that the scripting is a hassle.
Well there is a solution to the problem that will have you using tables and
databases in no time with no script required.
[link]
Toad for Mysql solves all the problems of hassle free script writing.... more »
|
|
|
what port?
|
| |
[link]
I want to try out this program.
It asks for a port.
Which would be what?
My host is hostgatot.com and it will be an Mysql database.
|
|
|
Finding the Differences between tables
|
| |
Hello everyone,
I have two large tables a incremental stage_set and a incremental target_set with the same data structure.
My task is to a minus between target set and the stage set.
Based on the results I would then perform a delete on a production
table.
Any hints/pointers on how to do this?... more »
|
|
|
need help building an SQL Statement...
|
| |
I have a table like:
ImageID, SeriesID, StudyID
ImageID is unique Series and Study are not unique.
StudyID, SeriesID, ImageID
A, a, 1 A, b, 2
B, c, 3
B, c, 4
C, d, 5
C, d, 6... more »
|
|
|
COUNT with a condition for a GROUP SELECT
|
| |
I want to do a "COUNT" with a condition for a GROUP SELECT. Here is my example.
--------------
DESCRIBE Persons
--------------
+--------+-------------------- ---+------+-----+---------+--- ----+
...+--------+----------------- ------+------+-----+---------+ -------+
...+--------+----------------- ------+------+-----+---------+ -------+... more »
|
|
|
daily reports
|
| |
Hello there!!
im rebuilding google analytics (nahhh kidding..)
i have this table
clicks
- id
- date
- ip
i want to generate monthly reports
SELECT count(id) FROM clicks
GROUP BY MONTH(date), YEAR(date)
ORDER BY date ASC
and daily..
SELECT count(id) FROM clicks
GROUP BY MONTH(date), YEAR(date), DAY(date)... more »
|
|
|
Database Design | PHP-Mysql | JSON
|
| |
Hi,
I am developing an application using F3 in which report generation is a sub-app.
Now i have the reports in the form of json data which will be large.
Problem is that, JSON data is in multiple levels and difficult to define schema for it.
Now, any suggestion on how i should store the JSON, as file? or in mysql database as blob or text?... more »
|
|
|
help with memcached with mysql
|
| |
Hi,
I posted here the other day and I got some help with regard to memcached.
I am running Redhat w/s 6 and mysql cluster 7.2.12. I am trying to run on a
laptop, which is an i5 multicore with 4 GB of RAM and a 500Gb hard-disk.
I have configure memcache as follows (details of memcache) PORT=11211... more »
|
|
|
mem.cache problem on mysql rhel 6
|
| |
Hi,
I am not sure if this is the right posting group for a mysql installation of a mysql-cluster. Here are the details.
Linux kernel 2.6.32-358.2.1.el6.i686 and using '/usr/local/mysql-cluster-gpl- 7.2.12-linux2.6-i686. I am using a linux-generic download which I assume is okay for the case of a redhat RHEL 6 workstation.... more »
|
|
|
