Sorry, you can't prove uniqueness by running it against a hundred
thousand, million, or even a billion computers. (The billionth-and-first
computer could be the one with the non-unique ID.) You need a
mathematical proof to prove uniqueness.
-Original Message-
From: Velen [mailto:[EMAIL
Unable to find this in the manual ...
Yesterday morning we rebooted the server by accident, which crashed and
restarted MySQL 4.1. Late last night a scheduled job ran mysqlcheck and
found 4 open tables. When I next ran mysqlcheck it found nothing wrong.
mysqlcheck command:
CHECK TABLE $DBTABLES
It sounds like you want to easily create a new MySQL table that is a
copy of a table in a different DBMS.
The way I would do it is generate a DDL script from the other DBMS
(create table etc.) For example, SQL Server has a generate script
wizard that does it for you automatically. Then take the
believe he
is correct.
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Thufir
Sent: Wednesday, March 05, 2008 3:09 AM
To: mysql@lists.mysql.com
Subject: Re: FW: Re: what is a schema? what is a database?
On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote:
My
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS is different in this regard. Microsoft's SQL Server works like
this:
A SQL Server instance (server) can have many databases.
A database can have many schemas, schema simply being a grouping for
objects in a database. In a
I tend to think this blogger is correct:
Sun is directly competing with Red Hat to become the heart of the
open-source business community. And Oracle may be in for a fight ...
http://blogs.cnet.com/8301-13505_1-9851662-16.html
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Best practice: Don't use reserved words for object (table, column,
constraint, etc.) names.
Here's your complete reserved word list for MySQL 5:
http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-refe
rence-reservedwords-5-0.html
-Original Message-
From: Rolando Edwards
Is id a sequential number? And is it referenced by other tables? If so,
and if over time new products become old products, then CASE 2 is more
complex, because when moving a product (i.e., a row) from the new
product table to the old product table, the value of id needs to stay
the same. So for
I'm a new MySQL DBA taking over admin duties for an existing MySQL
nonclustered 4.1 installation. It has 6 small user databases. So in the
mysql database, I run the query
Select host, user, password from user;
Which returns the following:
10 matches
Mail list logo