I have a content management system. One of the methods I use to grant
access to various parts of the site is with Groups. I can link Pages,
Users, Modules, etc (objects) to any number of groups. So a Many to
Many relationship. I use the grouplink table to do this.
CREATE TABLE `grouplink`
Hello,
How to query the memory usage for mysql server?
for example, how much memory mysqld has used? and how much memory
available for mysqld?
The OS is Linux.
Thanks.
Young.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
You can do some trickery with auto increment fields and multiple-column
indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131
Beware that this is apparently a MyISAM-specific trick.
/ Carsten
On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan"
wrote:
> I am new to mysql a
For such strongly database related logic sometimes its handy to keep all the
update and insert queries inside the stored procedures. All the validation
you mention in that case should be also build in the procedure.
Regards,
m
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular database development tools:
" Database Workbench 3.4.4b "
This release includes the Pro and Lite Editions, release "b"
fixes a problem with the installer, if you experienced any
problems, remove this fol
Hi
I have a table that contains league standings type information for a soccer
league. For example
season_id
round_id
team_id
league_id
home_won
home_draw
home_lost
home_goals
home_conceded
away_won
away_draw
away_lost
away_goals
away_conceded
Basically each row contains each league's round res
I am new to mysql and am trying to develop a package in php using mysql as
backend database.
I have a table in mysql which has a customer code which is alpha numeric.
Eg: J0001 and name and address of the customer. The alphabet signifies the
first letter of the name of the customer viz. James.
On Mon, Apr 5, 2010 at 4:18 PM, Aveek Misra wrote:
> I have the following two tables
>
> CREATE TABLE `cfg_tags` (
> `cluster` varbinary(128) NOT NULL,
> `tag` varbinary(128) NOT NULL,
> `user` varchar(40) NOT NULL,
> PRIMARY KEY (`cluster`,`tag`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
>
>
