More tables or more joins

I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to contro

Re: More tables or more joins

id > Cont_id > col_id > qty > > This should be a good start... > > Regards, > Jake Johnson > [EMAIL PROTECTED] > > __ > Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on > Rims, Ca

Getting table comments

I have a short and simple question that I can't find an answer to. Is there a way to return table comments with a query? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Upgrading to MySQL 4

I need to migrate a 3.23.52 MySQL server to a version with InnoDB (and row level locking). The catch is, I need to do it in a hurry (by the end of the week). It is a production system with over 300 users. Some tables have over 2,000,000 rows. The main question I have is should I take this op

Re: How do I show column names in php?

Try: $result = mysql_query("SHOW COLUMNS FROM table_name"); while ($row = mysql_fetch_array($result)) { foreach ($row as $key=>value) { echo "$key = $value"; } } -Jackson On Wednesday 23 July 2003 9:32, Jake Johnson wrote: > I am using php and mysql and I want to show the column

Re: How to export db or table structure?

mysqldump --opt -Jackson On Friday 25 July 2003 10:39, Jim McAtee wrote: > > We have a very large MySQL database, and the designer of the database no > > longer works for us. I need to re-create the same table structure, but > > without the content, on a separate machine. > > > > I know I can d

Re: speeding up lookups on a table

This could be caused by table locking. If another Mysql process ha a lock on the table then other processes start to queue up. Maybe this query is getting stuck behind other queries or a single slow query. Just a thought. -Jackson On Saturday 26 July 2003 11:00, Bennett Haselton wrote: > I

mysqlcc LIMIT

mysqlcc has a limit of 1000 on all queries I run. I can understand this for SELECT queries, but it makes no sense for INSERT... SELECT queries. Is there a way to override this limit? -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Hardware recommendation

I am going to have to put MySQL on it's own box, and I am wondering what makes the biggest difference with hardware. I am hoping to set max_connections to 1000 at least (and I will probably use at least 500 several times a day). There are a few tables that are almost constantly running inserts,

Re: Temporary Table Problem - Help

> > $sql = "CREATE temporary TABLE tmpInventory "; > $sql .= " SELECT * FROM inventory WHERE 1=0;"; > $create_tmp = mysql_query($sql) or $err=("temp table not created"); > > > Any ideas why this might be happening? > > > > Anya Miretsky &

Optimizing imports

rows at a time? If so, is there a magic number or range? The same would also go for updates. Thanks, -Jackson -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemm

Re: Optimizing imports

0MHz/ for me. Is there a need for CONCURRENT when using InnoDB? Isn't that the default for InnoDB? If not, does it lock the entire InnoDB table while the insert is running? -Jackson > > HansH -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED]

Re: PHP or Perl?

ealey > > [EMAIL PROTECTED] > > > > This account is only for lists to which I've subscribed. > > Any spammers invite the worst revenge I think I can get away with. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://l

Re: Import from Excel to MySQL

t; > Export the Excel to csv, then import the csv to MySQL. There are classes > for PHP that will read the binary data directly from Excel, but they are > costly...i.e. http://www.web-aware.com/biff/ > > HTH! -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL

RAID or not?

: 723.720 Thanks, -Jackson -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Raw partition with InnoDB on Windows 2000

Phone : +55 041 296-2311 > look: cannot open my eyes Fax : +55 041 296-6640 > --------- >Reply: [EMAIL PROTECTED] -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED]

Re: RAID or not?

how I set up the RAID? -Jackson jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com