Please CC me, I am on digest.
What is an int(11) as in the following table creation statement? I
looked online at the documentation, and not only is the documentation
MUCH different than the last time I looked at it, (been awhile), but I
didn't see anything related to a parameter to the size of
Given the following table:
Name varchar(128),
CodePageEncoding varchar(32)
that a select like this could be done
select Name, CodePageEncoding
from table
group by CodePageEncoding
order by CODE_PAGE_SENSITIVE_FUNCTION(CodePageEncoding, Name);
This would produce a report/resultset like the
I just got done figuring out how to --100%-- normalize a database to
make it very flexible. Methinks that Oracle has done this in some
fashion, as they claim to be able to make an intersection from any row
in any table to any other.
A note: Objects, Actors, and Attributes use the names of the
Is it true no indexing on Nulls In the Innobase database tables and
MyIASM
tables?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
prelude:
- utf-8 is a 'string function friendly' version of UTF-32, a character
mapping for all known human languages (with room for more). UTF is 4
bytes (4 * 8 = 32). Any of those 4 bytes can be 0, i.e. ''/NULL. A
regular library string function will end the string at the first BYTE it
How do you guys uniquely identify companies within your mysql databases,
both foreign and domestic?
Tax ID numbers?
Name and State and City(US)
Other?
In the database I am designing
the PublicMembers are identified by email/login/person/member(num),
and only has financial capabilities with my
for
children)
The biggest problem seems to be structuring the tables to force the
requirement for at least ONE email address, but not having to create
lots of empty fields.
Sincerely,
Dennis Gearon
Are people using Mysql using foreign keys and how are they using them?
It seems that the way to use them is with the scripting language used to
access the database.
-
Before posting, please check:
I don't know if this list still gets read by the staff TcX or not, but I
have this suggestion:
1/ For those of us willing to code the glue logic to make triggers,
constraints, and foreign keys work, it would be VERY helpful if ALL the
commands that are exercised on a table at creation or
They didn't work 'onsite'/live, or when downloaded. They *used* to work
for both.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
The end of this quote is a link. When I loaded the whole manual in my
browser NS4.7x, I expected the link to move through the manual copy in
my browser's cache. Instead, it tried to link to a copy on the MySQL
site and gave a 404 error message from the MySQL site.
From manual (Section 5.1):
Use
11 matches
Mail list logo