Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
So is karma :) From: sol beach <[EMAIL PROTECTED]> Reply-To: sol beach <[EMAIL PROTECTED]> To: B Wiley Snyder <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sat, 16 Apr 2005 20:56:08 -0700 Incompetence is its own reward. Simply put, 360K is NOT a big number or DB give

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do that ! Sorry From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:21:36 - (UTC) Hello there, no offence bu

Re: MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
ly the main thing in the application is password authentication then when the user is authorized their homepage is but from a handfull of variables from the database. Sorry to offend if this steps into someones thread, let me know if it does. Best Regards and thanks for the reply From: [EMAIL P

MySQL bottleneck

2005-04-16 Thread B Wiley Snyder
Hello there, let's say I have 365,000 users I need to enter their data, pull from it and modify it regularly. Is MySql the way to go ? Or do I need to buy an oracle or ms server ? thanks in advance for a clue From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PRO

Re: How to retain "Key" order when Deleting a Row

2005-04-15 Thread B Wiley Snyder
Thanks, I don't know what I was thinking ?!? From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: How to retain "Key" order when Deleting a Row Date: Tue, 12 Apr 2005 14:48:54 -0400 "B Wiley Snyder" <[EM

How to retain "Key" order when Deleting a Row

2005-04-11 Thread B Wiley Snyder
Hello experts, I just need someone to please point me in the right direction on retaining my "key" or id order in my table when I delete a row. So for example I have 10 rows Id 1-10 that are created automatically when the record is inserted. So if I delete record with id 5 my id's are not 1,2,3,

weird syntax error

2005-01-07 Thread B Wiley Snyder
When I use 4.0 on windows I don't get this error but now that i'm using 4.1.x I'm getting error 1064 , is BLOB depricated or something ??? Please help ! thanks in advance === Your MySQL connection id is 97 to server version: 4.1.8-standard Type 'help;'

newbie green pea

2004-09-22 Thread B Wiley Snyder
help me create a file of a database and deploy it. I've got a mysql "BIBLE", if anything educate me on the terminology so I can look it up. Thanks for anyones generous and helpful response -Wiley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

another newb question for you help...

2004-08-26 Thread B Wiley Snyder
23", "modelxyz","../images/product1.jpg", 20.95,"Hi my name is frank and I'd like to say like WOW man.This is a lengthy description of this product. Can someone help me out here? Thanks in advance, -Wiley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mySQL beginner question

2004-08-25 Thread B Wiley Snyder
Hello, hope this is the right list I created a table with the following code CREATE TABLE jspCart_products ( ProductID int primary key, CategoryID int, ModelNumber varChar(75), ModelName varChar(250), ProductImage varchar(250), UnitCost decimal(9,2), Description BLOB, ); The CategoryID has dupl

beginner stuff; cant create database

2003-02-03 Thread wiley
Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\>mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... -

MySQL & Berkeley DB

2002-11-04 Thread Wiley Jacobs
! Wiley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail &