RE: Help needed
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 PROTECTED] Sent: Monday, May 12, 2008 8:32 AM To: Arthur Fuller Cc: mysql@lists.mysql.com Subject: Re: Help needed Hi Arthur, Could you please tell this guy that it was not a virus and you tested it without any problem? Thanks. Velen On Sat, 2008-05-10 at 20:59 +0400, Velen wrote: > Hi, > > I'm testing a program and I need you assistance. > > Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. Please supply a Linux version of your virus so I can test. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au - Original Message - From: Arthur Fuller To: Velen Sent: Saturday, May 10, 2008 10:44 PM Subject: Re: Help needed On my main machine the PCID is 135184-45-4-10-1513-1. Hope it helps. Arthur On Sat, May 10, 2008 at 12:59 PM, Velen <[EMAIL PROTECTED]> wrote: Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. It will display an ID, please mail me back the ID. If you can use it on several computers, it will be even better for me, I need to have as much results as possible. The program i'm testing is supposed to create a unique ID for each PC, this is why I need to test if it is really unique. This file is virus free and cannot do any harm to your PC. It is however a voluntary testing. Thanks for your help in advance. Velen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does version 4 mysqlcheck close MyISAM tables left open?
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 $TYPE1 $TYPE2" | mysql --host=$DBHOST -t -u$USER -p$PASSWORD $i where $TYPE1 and $TYPE2 are empty. warning message from the mysqlcheck command: expressionengine_dof_public.exp_stats check warning 2 clients are using or haven't closed the table properly
RE: Importing - Adding Fields Into MySql From A List
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 DDL and modify it to meet your MySQL needs. Then you can run the script in MySQL Query Browser (make sure you're pointed at the right database, or put a USE command at the beginning of your script). Presto, you have the table you want. -Original Message- From: revDAVE [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 8:25 AM To: mysql@lists.mysql.com Subject: Importing - Adding Fields Into MySql From A List Newbie question! I have a list of field names from another database (not mysql) - like: name phone1 phone2 street city state zip info etc (a bunch more fields) Q: Is there a way I can add these to an existing empty/blank table? Maybe I can use: - phpMyAdmin ? - sql commands with php - loop thru a list of these names? - import field names from CSV? - some other method? I tried a test with php and got NO errors - but no result either ( looked with phpMyAdmin after - the table didn't add or drop the fields... Nothing changed) I have phpMyAdmin and If there's a way add tables w / php - maybe that would work also If I can just get all the field names in the table as text fields - that would be ok for now - then I can individually change the field type by hand w phpMyAdmin... -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4 Grant command
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';
Re: what is a schema? what is a database?
Sorry. An example of a fully qualified SQL Server object name is:
SELECT * FROM Server123.Database456.Sales.Product
The object Server123.Database456.Manufacture.Product is a different
table from Server123.Database456.Sales.Product.
Joerg Bruehe in his post called a "schema" a "namespace", I 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 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 SQL Server 2005 database, there can be two
> tables named "Product" if one is in the schema Sales and the other is
> in the schema Manufacture. The two tables are Sales.Product and
> Manufacture.Product.
>
> A fully qualified SQL Server object name is
> server.database.schema.object.
In your two examples:
SELECT * FROM server.sales.schema.product; SELECT * FROM
server.product.schema.product;
I'm a bit tired, so maybe I'm not seeing it, but what goes in the schema
place holder?
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Re: what is a schema? what is a database?
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 SQL Server 2005 database, there can be two
tables named "Product" if one is in the schema Sales and the other is in
the schema Manufacture. The two tables are Sales.Product and
Manufacture.Product.
A fully qualified SQL Server object name is
server.database.schema.object.
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Thufir
Sent: Tuesday, March 04, 2008 12:58 AM
To: mysql@lists.mysql.com
Subject: Re: what is a schema? what is a database?
On Mon, 03 Mar 2008 14:20:58 -0500, Martin Gainty wrote:
> http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According
> to MYSQL doc:
> A schema is a database
That contradicts the following claim (to my reading):
"A true fully (database, schema, and table) qualified query is
exemplified as such: select * from database.schema.table"
http://en.wikipedia.org/wiki/
Comparison_of_relational_database_management_systems#Databases_vs_Schema
s_.28terminology.29
What' I'm familiar with is:
SELECT * FROM database.table;
That's ok, that makes sense, this is how MySQL does it and is how I've
been doing it. Some databases do it differently, apparently.
Apparently MySQL lacks this feature, but what feature is it lacking?
There's no equivalent to:
SELECT * FROM database.schema.table;
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Sun to buy Mysql
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 PROTECTED] Sent: Wednesday, January 16, 2008 7:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: >> Will this bring good things to MySQL? > > $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and "power" will help of course ... -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error
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 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 15, 2008 1:17 PM
To: Pastor Steve; MySQL List
Subject: RE: Error
ORDER is a reserved word in standard SQL
Example : SELECT FirstName,LastName FROM Names ORDER BY
LastName,FirstName;
If the column name in the table is ORDER, then put backquotes (`) around
the word ORDER when using it as a column name
INSERT INTO sections (`order`,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
-Original Message-
From: Pastor Steve [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 15, 2008 4:02 PM
To: MySQL List
Subject: Error
Greetings,
I am trying to enter this information into a database called cms_md,
with a table called sections.
INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.
--
Steve M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Indexing one byte flags - what implementattion is better
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 CASE 2 you'll need a third object to keep track of the highest value for id. -Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 27, 2007 1:19 PM To: mysql@lists.mysql.com Subject: Indexing one byte flags - what implementattion is better Maybe someone could provide a good resonable input on this issue. Let's say i have a table products CASE 1: table: products id int unsigned not null, name char(128) not null, f_new tinyint not null id - is basically the id of a product name - is the name of a product f_new - is a one byte flag. If it is 1 the product is condireed new. In this case to select all new products including name i need to do: select id, name from products wher f_new=1 CASE 2: The above can be done another way - via two table, one products table and another one - listing all ids for new products create table products ( id int unsigned not null, name char(128) not null, primay key (id) ); create table newproducts ( product_id int unsigned not null, primay key (id) ); If product is is in newproducts table that it is a new product. To choose all new products including name i need to do: SELECT id,name FROM newproducts INNER JOIN products ON products.id=newproducts.product_id The questions are: 1) which way is FASTER? 2) which way eats less memory? 3) which way eats less cpu? 4) which way eats less hdd io? There are several cases for each question: 1) <1000 products - i think both methods are pretty much the same in this case because all of the data woul be cached in memory 2) 10 products, 3 new products - interesting to know which method is better here and how each of the method performs. 3) 10 products, 50 new products - interesting to know which method is better here and how each of the method performs. I will greately appriciate input on this issue. -- Artem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Blank users/passwords
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: +-+-+--- + | host| user | password | +-+-+--- + | localhost | root| (long hex string) | | localhost network name | root | | | localhost network name | | | | localhost | | (long hex string) | | localhost | one_user| (long hex string) | | %| one_user | (long hex string) | | % | root | (long hex string) | | localhost| two_user | (long hex string) | | IP address x | one_user | (long hex string) | | IP address y | one_user| | +-+-+--- + Does this mean that: 1. Line 2 above: root can log in with a blank password from (localhost network name)? 2. Line 3 above: A blank user/password can be used to log in from (localhost network name)? 3. Line 4 above: A blank user can be used to log in from localhost, but a password has been specified? 4. Line 10 above: User "one-user" can be used to log in from IP address y with a blank password? Or am I reading this incorrectly?
