RE: transaction support

2004-01-05 Thread Craig Vincent
Bryan, Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that.

MySQL/InnoDB question

2002-05-16 Thread Craig Vincent
to this. Sincerely, Craig Vincent - 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

RE: transaction with MySQL

2002-04-17 Thread Craig Vincent
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports transaction. If I remember correctly, BDB has transaction support and was released during 3.23 development. Sincerely, Craig Vincent - Before posting

RE: Boolean!

2002-04-15 Thread Craig Vincent
options for a boolean column need. Sincerely, Craig Vincent - 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

RE: row totals

2002-04-09 Thread Craig Vincent
I need to know how many total reviews are in my table for each category name, im using this query and it doesn't work: SELECT SUM(name) AS articletotal WHERE category = 'Processors' Try SELECT count(name) AS articletotal FROM tablename WHERE category = 'Processors' Sincerely, Craig

Re: between

2002-03-07 Thread Craig Vincent
, Craig Vincent - 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

Re: question about duration of connection

2002-02-18 Thread Craig Vincent
runs a query at least once every 8 hours (assuming you keep the timeout at the default value) you won't have a problem. Sincerely, Craig Vincent - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Warning: mysql is deprecated???

2002-02-17 Thread Craig Vincent
showing the segments of your code causing the errors would help us suggest what may be improved upon. Sincerely, Craig Vincent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: How to load data?

2002-02-17 Thread Craig Vincent
however you'd need to check the MySQL docs). You must drop the tables from the slave that you want to reload from the master, otherwise you will get an error. Sincerely, Craig Vincent - Before posting, please check: http

Re: beginner question: how many queries via PHP are...

2002-02-16 Thread Craig Vincent
not size but speed that determines efficiency...so if it takes 2 seconds to complete 5 queries you'd be better off doing that than a single query for the same information that thats 5 seconds to complete =) Sincerely, Craig Vincent

Re: domain name bug

2002-02-13 Thread Craig Vincent
, Update, Delete on X.* to 'X'@'X.f-tech.net' identified by 'X'; Sincerely, Craig Vincent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: opposite of PASSWORD('mypasswd').

2002-02-11 Thread Craig Vincent
, they can't simply run a DEPASSWORD or something similar to instantly find out what the passwords are (which would then make encrypting the passwords in the first place meaningless). Sincerely, Craig Vincent - Before posting, please

Re: opposite of PASSWORD('mypasswd').

2002-02-07 Thread Craig Vincent
, they can't simply run a DEPASSWORD or something similar to instantly find out what the passwords are (which would then make encrypting the passwords in the first place meaningless). Sincerely, Craig Vincent - Before posting, please

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Craig Vincent
. Sincerely, Craig Vincent - 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

Re: datetime column altered to not null

2001-12-20 Thread Craig Vincent
should update the records so they are set the way you want. Sincerely, Craig Vincent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: MySQL Glitch?

2001-12-16 Thread Craig Vincent
noticable with the very extreme exception. There's also the option of using the DELAYED options with inserts/updates provided you don't require those inserts/updates changes to be instantaneous for other use. Sincerely, Craig Vincent

Re: alter table add primary key error.

2001-12-16 Thread Craig Vincent
, count(userName) FROM user GROUP BY userName HAVING cnt 1; This will display all the 'userName's that are in more than one record. Simply remove the duplicates and then you should have no problem adding the primary key Sincerely, Craig Vincent

Re: Some amazing query numbers from MySQL 4.0

2001-11-27 Thread Craig Vincent
=) Sincerely, Craig Vincent - 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