Storing the IP addresses as integers requires less memory but incurrs the
cost of a call to these functions for every IP address. If you are going
to use these addresses in string comparisons it's best to store them as
varchars.
- Asad
On Thu, 2 Feb 2006, Brian Dunning wrote:
I'm logging I
Are there any statistics that I can use to determine how high or low I
should set max_connections? I am using MySQL as the backend for a Java web
application that will need to accommodate a moderate amount of traffic.
Also, if max_connections is set too high relative to the needs of the
applica
Hi. If you place these documents in the appropriate directory on the
remote machine, a directory in which they can be served over the internet,
then you should be able to link to them using a hyperlink reference (i.e.
http://). The other option is to have PHP grab these documents for you
using
Hello. I posted a similar question a while back and received a bunch of
responses. It depends on how you plan to use the numbers. If you plan to
use them in calculations, then storing them as INTs is best. Also,
breaking a number into separate components makes sense if you plan to use
these compone
Is it better to store phone numbers as strings or as integers? Offcourse,
storing them as integers saves space but this requires extra processing of
the user's input (i.e. CPU time). Are there any other
advantages/disadvantages of doing it one way or the other?
- Asad
--
MySQL General Mailing Li
I need in depth information on the character set used by MySQL including
invisible/escape characters/codes. Is there online documentation that I
can read on this? Thanks.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
ld be one table. Only with a one-to-many relation two
> tables make sense, but then your FK can't be unique.
> Stefan
>
> Am Wednesday 15 June 2005 12:41 schrieb Asad Habib:
> > As a follow up to my question, I did want to mention that the foreign key
> > I am using i
As a follow up to my question, I did want to mention that the foreign key
I am using is unique.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it good practice to have a primary key for a table even though the
table has a foreign key that is the primary key of another table? If so,
why is this the case? I would appreciate if you point me to some resources
that point out the advantages and disadvantages of both approaches. Thank
you.
-
For purposes of comparison, is data of type Year treated the same as
integers? I think this is the case because a year is represented using
either 2 or 4 digits, but I am not absolutely certain. Any help would be
appreciated. Thank you.
- Asad
--
MySQL General Mailing List
For list archives: htt
Hello. Yes, there are. In fact, other records have more data for this
field in them and inserts for those records never threw an error.
- Asad
On Tue, 10 May 2005, Jay Blanchard wrote:
> [snip]
> Hello. I am receiving the following error when trying to insert into a
> field of type text:
>
> #1
Hello. I am receiving the following error when trying to insert into a
field of type text:
#1030 - Got error 139 from storage engine
The data to be inserted should fit easily into a text field. In fact, this
error only occurs for a particular record and other records with much
larger data sets ar
One table should be sufficient to handle this with one record for each
product.
- Asad
On Mon, 4 Apr 2005, Dave Shariff Yadallee - System Administrator a.k.a. The
Root of the Problem wrote:
> I have a customer who has sent my close to 300 chemical products
> in word format? How do I translat
Sorry for the confusion. In this case I am using the * to denote a field
name instead of the wild card character.
- Asad
On Wed, 30 Mar 2005 [EMAIL PROTECTED] wrote:
> Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
>
> > Does MySQL 4.1 support the use of GRO
Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
conjunction with one another? I have tried to execute several queries
with both these clauses but the result set I get is different from what I
expect. My queries read as follows:
SELECT *, *, * FROM *
WHERE *
GROUP BY * ORDER BY *
A
I just installed phpMyAdmin, made the appropriate changes in the
config.inc.php file, and got the following error when accessing it via
both IE and Safari on Mac OS X Panther client.
#1251 - Client does not support authentication protocol requested by
server; consider upgrading MySQL client
I am
I just installed MySQL 4.1 on Mac OS X Panther Client. I am now having
trouble authenticating users(root, admin) to MySQL. I am able to start
MySQL but not using a specific user name and password.
When I type ./mysql in /usr/local/mysql/bin, I am able to access MySQL.
However, I have no privileges
I am trying to use GROUP BY with a field of type text that is set to NOT
NULL by default. However, in practice this field does not always contain a
string for every record and defaults to the empty string in this case.
When I try to use GROUP BY with this field in a SELECT statement, only 1
record
Does anyone know where I can find in-depth, precise instructions to
install MySQL on Mac OS X Panther client?
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are foreign key and other constraints enforced by the db server in this
version or is this something that the programmer has to ensure via
application logic?
- Asad
On Tue, 15 Feb 2005, Heikki Tuuri wrote:
> Hi!
>
> InnoDB is the MySQL table type that supports foreign keys, transactions,
> non-
Does anyone know where I can find a list of characters that cannot be
inserted into a MySQL database as part of a string? I know that MySQL does
not accept single and double quotes and that these have to replaced by
their name code equivalents. Are there any other characters that are
unacceptable?
21 matches
Mail list logo