Double indexes on one field

Hi all, Using PhpMyAdmin, I seldom get the warning message: PRIMARY and INDEX keys should not both be set for column `ID` I understand its meaning, but I was wondering to what extent having a field indexed AND being a primary key might slow down/speed up my queries. Is that gonna take twice the

Re: Double indexes on one field

Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : > > Using PhpMyAdmin, I seldom get the warning message: > > PRIMARY and INDEX keys should not both be set for column `ID` > > > > I understand its meaning, but I was wondering to what extent having a > > field indexed AND being a prim

Re: Double indexes on one field

Le lundi 03 octobre 2005 à 16:24 +0200, Bastian Balthazar Bux a écrit : > Yannick Warnier wrote: > > Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : > > > >>>Using PhpMyAdmin, I seldom get the warning message: > >>>PRIMARY and INDEX key

DBI and Mysql error 2006

Hi there, I'm having a problem with MySQL within a Perl::DBI usage. I've turned it upside-down and cannot find what it's related to. My Perl script creates multiple databases and populates them with tables. The problem appears when creating the second database (in the foreach statement): # # Get

Re: DBI and Mysql error 2006

Le ven 27/08/2004 à 00:37, Yannick Warnier a écrit : > Hi there, > > I'm having a problem with MySQL within a Perl::DBI usage. I've turned it > upside-down and cannot find what it's related to. > > My Perl script creates multiple databases and populates them w

Mysql and errno 13 on RedHat

Hi there, I need to install a database on a RedHat system. Although I'm pretty at ease with Debian, I feel a little unconfortable and cannot find why I get an Error: errno 13 (Permission Denied) when I try to create a new database. Is there some place to look at first? I cannot find any way to do

Re: Mysql and errno 13 on RedHat

Le mar 31/08/2004 à 16:21, Dobromir Velev a écrit : > Hi, > Make sure that the mysql user have permissions to write into the folder > /var/lib/mysql (or whatever your data folder is) . Thanks Eric and Dobromir. This was a problem of permissions on /var/lib/mysql indeed. Although it did not work i

Forcing case sensitivity in queries

Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE field = 'd'; I get all records containing 'd' or 'D'. How do I enable case-sensitivity? Thanks, Yannick -- MySQL General Mailing List For list

Re: Forcing case sensitivity in queries

Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit : > Hi, > > When I execute a query in MySQL client, it seems like I cannot get the > case-sensitivity to be activated. > > If I ask: > SELECT * FROM mytable WHERE field = 'd'; > > I get all records contai

Re: Bulk addition of users and databases

Le mar 07/09/2004 à 11:24, Rob Keeling a écrit : > Having googled extensively, I can`t seem to find a way to do the following. > > I have a mysql table, with around 1200 usernames in it. > > What I want to do is programmatically add each user, and create a database > of the same name > that that

Lots of databases...how wrong is it?

Hi there, I am using a mysql server at the moment which contains 2800 different databases. phpmyadmin is really slow listing them, but that's not really a big deal. The thing is my view on this set of databases (every database contains about 20 tables) is it is really bad, because actually there

Re: Lots of databases...how wrong is it?

Le sam 29/05/2004 à 15:28, Ryan Fox a écrit : > It depends on the table type, but I'll gear my answers toward myisam. > > MySQL uses the os's filesystem calls to list directories. Slowdowns / > limits to the number of myisam databases will be caused by the > filesystem. > > > - how many database