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. The
regards 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 <[EM
> 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
-
se column.
BOOL
or
tinyint(1) unsigned
would probably be your best options for a boolean column need.
Sincerely,
Craig Vincent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
> 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 =
g of march first to the end of
march 3rd. You need to increment the final date by a day to get the fully
results you're seeking.
Sincerely,
Craig Vincent
-
Before posting, please check:
http://www.mysql.com/manual.php (t
ion 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
ay be ways of instasynching entire databases 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
tead to
'phase' out usage of the old style so one day it is no longer used at all.
Perhaps showing the segments of your code causing the errors would help us
suggest what may be improved upon.
Sincerely,
Craig Vincent
-
...basically remember it's 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 co
ySQL clientyour error probably lies with
directory permission problems.
Sincerely,
Craig Vincent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
identified
> by 'X'' at line 1
Try
grant Select, Insert, Update, Delete on X.* to 'X'@'X.f-tech.net'
identified by 'X';
Sincerely,
Craig Vincent
-
Before posting, please check:
http
es and encrypted passwords on MySQL,
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
es and encrypted passwords on MySQL,
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
900-01-01 00:00:00' WHERE created_date IS
NULL
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:
the procedure.
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 <[EMA
e value under the
userName column...
try this
SELECT userName, 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 shoul
that speed the fact
the tables are locked has never been 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
ou very much for the tip. It will be
definately something I look at when developing more interactive applications
online =)
Sincerely,
Craig Vincent
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
19 matches
Mail list logo
