Join vs. Where (help)

2003-06-25 Thread tlr7425
This: SELECT * FROM machines INNER JOIN people ON machines.machinesID=people.peopleID; Is not producing the same results as this: SELECT lastname, model FROM people, machines WHERE machines.peopleID = people.peopleID; Can someone please tell why, what's wrong? (What happens is that the wrong

Initializing primary key values for existing table

2003-06-25 Thread John Hicks
I needed to add a new, autoincrementing, primary key column to a table and have been struggling to figure out how to assign an initial, unique value to each row. I finally accomplished my task, but feel sure there's an easier way. Here is my solution: 1. Add the column: alter table mytable

Re: Join vs. Where (help) -(I got it!)

2003-06-25 Thread tlr7425
Ok, should be this: SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Ted This: SELECT * FROM machines INNER JOIN people ON machines.machinesID=people.peopleID; Is not producing the same results as this: SELECT lastname, model FROM people, machines WHERE

Problem setting/activating password

2003-06-25 Thread Riaan Oberholzer
Hi, I am created a user by using: GRANT ALL ON *.* TO username@% IDENTIFIED BY password I did this from the mysql command line tool, logged in as root. The command succeeds and the new user is created in the mysql.user table, but the password does not work. I can only use this new user if I use

Re: Join vs. Where (help)

2003-06-25 Thread George Christoforakis
Erm, the first sql as i can see doesn't connect on the same field as the second one that produces the correct result. George Christoforakis - Original Message - From: [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:01 AM Subject: Join vs. Where (help)

Re: Join vs. Where (help)

2003-06-25 Thread Nils Valentin
2003 6 25 15:[EMAIL PROTECTED] : This: SELECT * FROM machines INNER JOIN people ON machines.machinesID=people.peopleID; Inludes NULL records Is not producing the same results as this: SELECT lastname, model FROM people, machines WHERE machines.peopleID = people.peopleID; Dosent

Re: Join vs. Where (help)

2003-06-25 Thread Nils Valentin
Hi tlr7425, Besides what I said in my last e-mail I completely overlooked that SELECT * FROM machines INNER JOIN people ON machines.machinesID=people.peopleID; should be SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Even though my first statement should

Setting default auto_increment start int

2003-06-25 Thread Javan B.
Hi All, Just a quick question: How do I set the auto increment for a field to start from an integer other than 1. For example, I would like to be able to have the auto increment counter start from 1000. Thanks, Javan.

InnoDB file...

2003-06-25 Thread I-A.Kotopoulos
When should I use the autoextend option for the InnoDB file...Even after emptying the tables the files keeps its size and for new insertions it gets even bigger instead of using the already allocated space(which I suppose should be available after emptyibg the tables). thank you friends aik_b

Subselect functionality

2003-06-25 Thread Nils Valentin
Hi MySQL Fans ;-), I have a question regarding the MySQL feaures. From Version 4.1 Full subselect support was/is announced. However if I understood correctly then already from Version3.23-41 (or earlier) there are some subselect functions already included. For xample if I try this: CREATE

RE: Problem setting/activating password

2003-06-25 Thread csebe
I don't know if this apply when using GRANT but have you tried afterwards: flush privileges; HTH, Lian -Original Message- From: Riaan Oberholzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:19 AM To: [EMAIL PROTECTED] Subject: Problem setting/activating password

Re: Anyone had a chance to try an Opteron yet?

2003-06-25 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 24 Jun 2003, David Griffiths wrote: I'm surprised there is not more interest in this; is it that not many work with large-ish (10+ gig) databases that need high-end performance? Many of our customers do. A 64-bit CPU won't have the

Dumping data

2003-06-25 Thread Rob
Hi all, Is there any way to do a mysql dump in which each table is dumped into a separate file. I know I can use the --tables option to specify a table, but this means I have to type out each table name (and there are a lot of them). Is there any way to get mysql to automatically iterate

Re: InnoDB file...

2003-06-25 Thread Heikki Tuuri
I.-A., - Original Message - From: I-A.Kotopoulos [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, June 25, 2003 10:05 AM Subject: InnoDB file... --=_NextPart_000_00B5_01C33B01.642AD2C0 Content-Type: text/plain; charset=Windows-1252

MyISAM

2003-06-25 Thread Cedric Gavage
Hi all, I have a question about MyISAM, during an UPDATE for a row, is it a row locking or a table locking? -- Cedric Gavage [EMAIL PROTECTED] http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Join vs. Where (help)

2003-06-25 Thread tlr7425
What do you mean when you say, in this case, "does not return the NULL (Brecord"? (B (BI have no records that are completely "NULL" though some records do (Bhave a NULL field or two? (B (BThanks, (BTed (B (B (BOn Wednesday, June 25, 2003, at 02:42 AM, Nils Valentin wrote: (B (B Hi

Large file : InnoDB or MyISAM

2003-06-25 Thread JOUANNET, Rodolphe
Hi to all, I will have to do with a very big file (approx 600 millions of records). Which is the best table handler for this king of table : InnoDB or MyISAM (many INSERT and MANY SELECT, no UPDATE - statistics file). Best regards. -- MySQL General Mailing List For list archives:

Re: about desc command

2003-06-25 Thread Don Read
On 25-Jun-2003 MaFai wrote: Hello, mysql, After create a table,it can use desc tablename to describe the table scheme. But it can not demonstrate that the column is unique or not.It just simplely show the column is MUL type. How can I get more information from the table by

Re: Sorting Countries

2003-06-25 Thread Don Read
On 25-Jun-2003 Ralph wrote: I am getting a list of all countries from database, and then I am sorting by country name. However since most orders will be from US I want the US to appear first over the rest of the countries. How can I go about doing this? Currently, this is my query:

re: Conection to MySQL

2003-06-25 Thread Jon Miller
Installed MySQL v4.0.13 on RH8, with phpMyAdmin-2.5.1 and PHP v4. The phpMyadmin is installed on another server (gateway) while MySQL and PHP is installed on a separate server. When the programmer tries to access MySQL he gets the following message: Error 2003 Cannot connect to MySQL server

Re: Bug in last CVS

2003-06-25 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 24 Jun 2003, Dyego Souza do Carmo wrote: try to bk pull the mysql 4.0 from CVS tree... after I run: aclocal; autoheader; autoconf; automake inside dir... the error is: autoconf: Undefined macros:

Re: datetime column dummy question

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 12:05:49 +0800: //Wrong sql statement alter table p_asset add mydate datetime default now(); alter table p_asset add mydate datetime default time(); alter table p_asset add mydate datetime default now; alter table p_asset add mydate

Re: datetime column dummy question

2003-06-25 Thread Janice Wright
alter table p_asset add mydate datetime default 'now()'; - you need the '' around now(); apparently http://www.mysql.com/doc/en/DATETIME.html and scroll down to the comment made by Lazy Soul on Tuesday May 27 2003, @8:15am Jan Janice Wright Ingenta plc [EMAIL PROTECTED]

SCO UnixWare porting of MYSQL

2003-06-25 Thread Sudhipan Sharma
Hi ! Just wanted to know if there is any installation procedure available on = UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which = I have downloaded but Iam not able to initialize ./Configure script. = Any help/support will be appreciated. Thanks In Advance Regards Sudhipan

Re: default value does not set using LOAD DATA INFILE ...

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000: From: Roman Neuhauser [EMAIL PROTECTED] please don't piggyback on other people's threads. you can start your own for free. Although it was the first time for me to send the post on this list, I was sure that I did not follow other

Re: Join vs. Where (help)

2003-06-25 Thread Nils Valentin
SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Inludes NULL records I meant the first statement returns also empty record fields or should I say incomplete data records ? Is not producing the same results as this: SELECT lastname, model FROM

RE: Sorting Countries

2003-06-25 Thread artem
insert one space before US ;) in recieving do trim if not HTML output -Original Message- From: Ralph [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 7:32 AM To: mySQL Mailing List Subject: Sorting Countries I am getting a list of all countries from database, and then I am

RE: AES 256-Bit Encryption and /etc/my.cnf

2003-06-25 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 24 Jun 2003, Daevid Vincent wrote: It would be really nice if ANY of these kinds of configuration options were settable via the /etc/my.cnf file. I use RPM's almost exclusively for their ease of maintenance, compatibility and

Re: datetime column dummy question

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: Sometime recently MaFai said: A table contains a column named mydate. //Wrong sql statement alter table p_asset add mydate datetime default now(); alter table p_asset add mydate datetime default time(); alter

Re: datetime column dummy question

2003-06-25 Thread Janice Wright
You're right, just tested it myself on 3.23.41; and I get exactly the same result as you. We should post an amendment to the docs on the website. However, (still with 3.23.41): mysql create table autotime2 (foo int, bar timestamp default now()); ERROR 1064: You have an error in your SQL syntax

Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Victoria Reznichenko
Nils Valentin [EMAIL PROTECTED] wrote: I have some questions about temporary tables. I would appreciate any replies: I created a temporary table f.e. like this: mysql create temporary table temp SELECT * FROM relations; Query OK, 4 rows affected (2.35 sec) Records: 4 Duplicates: 0

mysql_pconnect

2003-06-25 Thread Paco Martinez
Hi My server www has Suse 8.2, apache-1.3.27, mod_php4-4.3.1, and my server mysql has Suse 8.2, and mysql.4.0.12-Max-log Sometimes, not always, it appears an error in www. Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost, unable to reconnect in db_mysql.inc on line 73

Re: datetime column dummy question

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 07:10:46 +0100: Sometime recently Roman Neuhauser said: # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: alter table p_asset add mydate datetime default 'now()'; - you need the '' around now(); apparently

can you tell me how

2003-06-25 Thread Mhd Zaher Ghaibeh
any one can tell me how can i use the MySQL ++ function in CBuilder 6?? i include it in my project but i got linker error

Re: Setting default auto_increment start int

2003-06-25 Thread Egor Egorov
Javan B. [EMAIL PROTECTED] wrote: Just a quick question: How do I set the auto increment for a field to start from an integer other than 1. For example, I would like to be able to have the auto increment counter start from 1000. Use AUTO_INCREMENT option of CREATE TABLE statement:

comp-err.exe

2003-06-25 Thread Morten Gulbrandsen
Compiler errormessage ver 1.3 C:\mysql\bincomp-err.exe -I comp-err.exe (Compile errormessage) Ver 1.3 This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Usage: comp-err.exe [-?] [-I] [-V]

Re: Initializing primary key values for existing table

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 02:11:05 -0400: I needed to add a new, autoincrementing, primary key column to a table and have been struggling to figure out how to assign an initial, unique value to each row. I finally accomplished my task, but feel sure there's an easier way. Here

Re: MyISAM

2003-06-25 Thread Victoria Reznichenko
Cedric Gavage [EMAIL PROTECTED] wrote: I have a question about MyISAM, during an UPDATE for a row, is it a row locking or a table locking? MySQL locks the whole MyISAM table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net

Re: comp-err.exe

2003-06-25 Thread Victoria Reznichenko
Morten Gulbrandsen [EMAIL PROTECTED] wrote: Compiler errormessage ver 1.3 C:\mysql\bincomp-err.exe -I comp-err.exe (Compile errormessage) Ver 1.3 This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the

Re: Subselect functionality

2003-06-25 Thread Egor Egorov
Nils Valentin [EMAIL PROTECTED] wrote: I have a question regarding the MySQL feaures. From Version 4.1 Full subselect support was/is announced. However if I understood correctly then already from Version3.23-41 (or earlier) there are some subselect functions already included. For xample

Re: datetime column dummy question

2003-06-25 Thread Nils Valentin
Also doesnt work in 4.1 alpha. Best regards Nils Valentin Tokyo/Japan (As requested I took Roman of , as he doesnt like direct e-mails ;-) 2003 6 25 19:12Roman Neuhauser : # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: Sometime recently MaFai said: A table contains a column named

Re: comp-err.exe

2003-06-25 Thread miguel solórzano
At 12:54 25/6/2003 +0200, Morten Gulbrandsen wrote: Hi, for which purpose is this file included in the file C:\mysql\bin directory ? For to build the errmsg.sys files: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. c:\mysql\bincomp-err

problems with farsi sorting!!

2003-06-25 Thread mohammad kh.tajer
I use unicode to store farsi data in mysql database but I have problems sorting it using ORDERBY command...(ORDER BY does'nt work properly) I don't know what to do . 1---)pleases help me if there is any solution for me to define a charset in the order that I want . 2---) how can I replace

Re: mysql.sock doesn't exist

2003-06-25 Thread Kevin H. Phillips
Yes, I installed by RPM. I have now found the error file as you mentioned. The output for the last few days is: 030621 06:49:27 mysqld started 030621 6:49:28 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on

Re: Subselect functionality

2003-06-25 Thread Nils Valentin
Hi Egor, Thank you for the reply. Do you mind to go abit mor into details ? It seems that I got domething wrong here. If nested queries are not only subselects, which other nested queries exist there ? Do you mind just writing a few samples, please ? Sorry if this seems a simple question -

Re: Dumping data

2003-06-25 Thread Diana Soares
Hi, Try mysqldump -T: -T| --tab=... Creates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysql dump is run on the same machine as the mysqld daemon. This was taken from the man page. On Wed, 2003-06-25 at 08:56, Rob

Re: Replication Performance

2003-06-25 Thread Marc Prewitt
Todd Burke wrote: Hello 1/ I have a search engine which crawls auction sites and returns information which is inserted into a mysql database. This activity represents on average about 3 inserts per second with a combined payload of 450 bytes per second added to the database. This updating

user@% vs user@localhost question

2003-06-25 Thread Riaan Oberholzer
This follows on a previous mail from me: When using GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY “password” I could not get the password authentication to kick in. Only supplying no password (empty string) succeeded. Even after doing “SET PASSWORD…” and “FLUSH PRIVILEGES”. Then I tried

Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Nils Valentin
WOW Victoria, thats a good explanation. That makes many things clearer now. Thank you very much. However, when not having the set the tmpdir variable were are the temporary tables stored ? (I searched the whole harddisc) I assume in this case that they must be stored in the memory, is that

Fwd: problems with farsi sorting!!

2003-06-25 Thread mohammad kh.tajer
Note: forwarded message attached. Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!---BeginMessage--- I use unicode to store farsi data in mysql database but I have problems sorting it using ORDERBY command...(ORDER BY does'nt work properly) I don't know what to do . 1---)pleases

type casting help!!!

2003-06-25 Thread Prem Soman
hi!! i wrote a simple function that returns a string in C the function fetches values from a table and stores all the value in a string variable and then returns it ...This is small part inside the function i wrote! while((row = mysql_fetch_row(res))) { unsigned long

Gant permission problems with domains and full hostnames for same user

2003-06-25 Thread De Leuze Peter
Hello, I currently am struggling to get the permissions and table restrictions to work. Description of the case: -- For a database "examp", where table "foobar" which contains colums "A", "B" and C ,only a restricted access is allowed. Lets say that user

Re: Query Execution Time in mysql

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700: insert into table1 select * from table2; Table2 has some 10,000 records while table1 has around 11,00,000 records. The time reqd. to execute the above query is round about 80- 90 secs. The table1 has 7 columns out of which 5 are composite

Re: type casting help!!!

2003-06-25 Thread Peter Burden
Prem Soman wrote: hi!! i wrote a simple function that returns a string in C the function fetches values from a table and stores all the value in a string variable and then returns it ...This is small part inside the function i wrote! while((row = mysql_fetch_row(res))) {

Re: Sorting Countries

2003-06-25 Thread Patrick Sherrill
Alternatively you can create a priority column defaulting to one number (99) this will allow you to easily change the country sequence as needed. SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY priority,countries_name; I hope this helps... Pat... [EMAIL PROTECTED] CocoNet

CREATE TEMPORARY TABLE

2003-06-25 Thread Phil Dowson
Hi, I am running two identical systems, the only difference between the two are the database name and username. The problem I am getting only occurs on one of the systems. I am running -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

KEYS error 1216

2003-06-25 Thread Terry Spencer
Hi All, Im altering a number of table from MyISAM to innoDb and adding foreign keys. The alteration of the table type works. Adding the row as an index works. Adding the foreign key fails, generating the error: alter table project add FOREIGN KEY (company_id) references company (id) [mySQL]

Re: Join vs. Where (help)

2003-06-25 Thread Bruce Feist
Nils Valentin wrote: SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Inludes NULL records I meant the first statement returns also empty record fields or should I say incomplete data records ? Is not producing the same results as

RE: Re: Query Execution Time in mysql

2003-06-25 Thread [EMAIL PROTECTED]
I think we need more info: Table definition, MySQL version etc.. Med venlig hilsen Lars Geisler -Original Message- From: Roman Neuhauser [EMAIL PROTECTED] To: Amit Lonkar [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Query Execution Time in mysql Sent:

Re: KEYS error 1216

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100: Im altering a number of table from MyISAM to innoDb and adding foreign keys. The alteration of the table type works. Adding the row as an index works. Adding the foreign key fails, generating the error: alter table project add FOREIGN KEY

Re: user@% vs user@localhost question

2003-06-25 Thread Roman Neuhauser
your MUA doesn't properly represent quotation marks, breaking them in other MUAs. # [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700: This follows on a previous mail from me: When using GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY ?password? I could not get the password

Re: Join vs. Where (help) -(I got it!)

2003-06-25 Thread gerald_clark
In the second query, the server may switch the order of the join, producing the same output in different order. Try adding an ORDER BY to both and see what happens. [EMAIL PROTECTED] wrote: Ok, should be this: SELECT * FROM machines INNER JOIN people ON machines.peopleID=people.peopleID; Ted

Re: Problem setting/activating password

2003-06-25 Thread gerald_clark
To also add priviliges on the local machine GRANT ALL ON *.* TO username@localhost IDENTIFIED BY password Riaan Oberholzer wrote: Hi, I am created a user by using: GRANT ALL ON *.* TO username@% IDENTIFIED BY password I did this from the mysql command line tool, logged in as root. The

Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Victoria Reznichenko
Nils Valentin [EMAIL PROTECTED] wrote: WOW Victoria, thats a good explanation. That makes many things clearer now. Thank you very much. However, when not having the set the tmpdir variable were are the temporary tables stored ? (I searched the whole harddisc) I assume in this case

Re: problems with farsi sorting!!

2003-06-25 Thread Egor Egorov
mohammad kh.tajer [EMAIL PROTECTED] wrote: I use unicode to store farsi data in mysql database but I have problems sorting it using ORDERBY command...(ORDER BY does'nt work properly) I don't know what to do . 1---)pleases help me if there is any solution for me to define a charset in

Re: [MYSQL] Question about 'SHOW PROCESSLIST' output columns

2003-06-25 Thread Egor Egorov
PAUL MENARD [EMAIL PROTECTED] wrote: I'm having an intermittent problem with a MySQL server that I have running on a Windows 2000 Advance server systems. This issue occurs every few days depending on the load of the system. Here are the details. MySQL version 3.23.42-nt (I know I

RE: user@% vs user@localhost question

2003-06-25 Thread Mike Hillyer
I believe % doesn't include localhost, but I could be wrong. % Does indeed include localhost. At least it does on 4.0.13. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: user@% vs user@localhost question

2003-06-25 Thread Andy Stubbs
Maybe it does, or maybe it doesn't; but if you're connecting to your server on the localhost, you're probably connecting through a pipe/UNIX type socket instead of over the network. This might be the distinction that matters in this case; does @localhost in this context mean through a non-network

Re: SCO UnixWare porting of MYSQL

2003-06-25 Thread Boyd Lynn Gerber
On Wed, 25 Jun 2003, Sudhipan Sharma wrote: Hi ! Just wanted to know if there is any installation procedure available on = UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which = I have downloaded but Iam not able to initialize ./Configure script. = Any help/support will

RE: SCO UnixWare porting of MYSQL

2003-06-25 Thread Mike Hillyer
I simply followed the directions listed here: http://www.mysql.com/doc/en/SCO_UnixWare.html And I had no problems. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Sudhipan Sharma [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 3:08 AM To: [EMAIL PROTECTED]

Re: CREATE TEMPORARY TABLE

2003-06-25 Thread gerald_clark
And what would that be? Phil Dowson wrote: Hi, I am running two identical systems, the only difference between the two are the database name and username. The problem I am getting only occurs on one of the systems. I am running -- MySQL General Mailing List For list archives:

RE: Large file : InnoDB or MyISAM

2003-06-25 Thread Mike Hillyer
In a situation with many concurrent reads and writes an InnoDB table would be preferable. See http://www.mysql.com/doc/en/Table_types.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 2:30

Re: user@% vs user@localhost question

2003-06-25 Thread Victoria Reznichenko
Riaan Oberholzer [EMAIL PROTECTED] wrote: This follows on a previous mail from me: When using GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY ?password? I could not get the password authentication to kick in. Only supplying no password (empty string) succeeded. Even after doing

Re: CREATE TEMPORARY TABLE

2003-06-25 Thread Egor Egorov
Phil Dowson [EMAIL PROTECTED] wrote: I am running two identical systems, the only difference between the two are the database name and username. The problem I am getting only occurs on one of the systems. I am running What exactly problem do you have? -- For technical support contracts,

RE: MyISAM

2003-06-25 Thread Mike Hillyer
MyISAM tables do not support row-level locking, only table locking. See http://www.mysql.com/doc/en/Table_locking.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Cedric Gavage [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 2:14 AM To: [EMAIL

MySQL 4.0.13 GRANT syntax

2003-06-25 Thread Adam Lawrence
I am attempting to modify the GRANT table using the syntax specified in the MySQL 4.0.13 documentation, and am getting error messages claiming the syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used mysqlc with root access. mysql USE mysql; Database changed mysql GRANT

RE: user@% vs user@localhost question

2003-06-25 Thread artem
yesterday i had same problem on 4.0.13 for win added [EMAIL PROTECTED] - and was rejected added [EMAIL PROTECTED] - then accepted -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 4:54 PM To: Roman Neuhauser; Riaan Oberholzer Cc: [EMAIL

RE: Dumping data

2003-06-25 Thread Mike Hillyer
I think you need the -T option, which will break out table data to separate files. Here's a description from the manual: QUOTE -T, --tab=path-to-some-directory Creates a table_name.sql file, that contains the SQL CREATE commands, and a table_name.txt file, that contains the data, for each give

RE: Subselect functionality

2003-06-25 Thread Mike Hillyer
I am not sure that could be viewed as a subselect, as it in not a SELECT within an SELECT, but is instead a SELECT within a CREATE. I would imagine that the SELECT within the CREATE is easier to implement that the actual SELECT within a SELECT. Regards, Mike Hillyer www.vbmysql.com

Re: mysql ended error

2003-06-25 Thread Pushpinder Singh Garcha
Thanks you Nils . (B (B I truly appreciate how helpful you have been !! I have now got the (Berror sorted out now. (B (BI re-installed MySQL on my Mac OS Jaguar 3 times. Finally the third (Btime I got it to run. Somehow I had corrupted my User.MYI file (BI did have to delete the

RE: Initializing primary key values for existing table

2003-06-25 Thread Mike Hillyer
You need simply add the column predefined as AUTO_INCREMENT and PRIMARY KEY: CREATE TABLE incrtest ( name varchar(100) NOT NULL ) TYPE=MyISAM; INSERT INTO incrtest VALUES(ben); INSERT INTO incrtest VALUES(bob); INSERT INTO incrtest VALUES(bom); INSERT INTO incrtest VALUES(gddo); INSERT INTO

RE: Problem setting/activating password

2003-06-25 Thread csebe
What about using the username only instead of username@% ? According to manual (section 7.34) it should be identic in behaviour: [...] The simple form user is a synonym for user@%. [...] Does it do the same? Lian P.S. Andy, sorry for posting by mistake to you. ;-| -Original Message-

RE: datetime column dummy question

2003-06-25 Thread Mike Hillyer
The TIMESTAMP column type does this for you: See: http://www.mysql.com/doc/en/DATETIME.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: MaFai [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: datetime column dummy

Re: problems with farsi sorting!!

2003-06-25 Thread Veysel Harun Sahin
You can change your charset by adding a line in your mysql configuration file like this. default-character-set = cp1256 Here cp1256 means that mysql will use Windows Arabic character set. I don't know the difference between farsi and arabic charsets. And also I don't know if mysql has a

RE: Query Execution Time in mysql

2003-06-25 Thread Mike Hillyer
You may want to try disabling the index during the insert: ALTER TABLE table1 DISABLE KEYS; insert into table1 select * from table2; ALTER TABLE table1 ENABLE KEYS; And see what that does. See: http://www.mysql.com/doc/en/ALTER_TABLE.html Regards, Mike Hillyer www.vbmysql.com -Original

RE: Anyone had a chance to try an Opteron yet?

2003-06-25 Thread David Brodbeck
-Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED] Actually, you can create larger files on 32bit Linux systems as well. It's just that the file system and the C library must have support for LFS (Large File Support): http://www.suse.de/~aj/linux_lfs.html I can

RE: Problem setting/activating password

2003-06-25 Thread Riaan Oberholzer
The problem is that when I only define the % host, then no password is required to log in... (not a wanted feature!). I CAN log in, i just have to specify no password. The password checking is only done for localhost --- [EMAIL PROTECTED] wrote: What about using the username only instead

Re: MySQL 4.0.13 GRANT syntax

2003-06-25 Thread Fred van Engen
On Wed, Jun 25, 2003 at 10:09:58AM -0400, Adam Lawrence wrote: I am attempting to modify the GRANT table using the syntax specified in the MySQL 4.0.13 documentation, and am getting error messages claiming the syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used mysqlc

RE: MySQL 4.0.13 GRANT syntax

2003-06-25 Thread Mike Hillyer
Does enclosing the username and host in single quotes help? I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update'; Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Adam Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 8:10 AM To:

Re: CREATE TEMPORARY TABLE

2003-06-25 Thread Phil Dowson
Sorry the problem fixed itself, and I mistakenly sent this email - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Phil Dowson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:01 am Subject: Re: CREATE TEMPORARY TABLE And what would that be? Phil

Re: Strange Mull in show fields and table keeps crashing

2003-06-25 Thread Karl J. Stubsjoen
I'm not sure what errors are being reported to the server. I'm not sure how to get those. I am not local to the box. Is there a way to look at the log files without being at the box? Karl - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'Karl J. Stubsjoen' [EMAIL

RedHat 9.0 - Mysql 3.23.56

2003-06-25 Thread Luc Foisy
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0 When it installed, it started up mysql, no problems, I could do all mysql functions I recently rebooted the box, and mysql did not start automatically. I can start it if I run /etc/rc.d/init.d/mysql start Is there any know problems why

RE: MySQL 4.0.13 GRANT syntax

2003-06-25 Thread csebe
update is a reserved word in MySQL. Choose another username. Lian Sebe Freelance Analyst-Programmer www.programEz.net -Original Message- From: Adam Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 5:10 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0.13 GRANT syntax I

RedHat 9 - MySQL 3.23.56

2003-06-25 Thread Luc Foisy
Something interesting that may be my problem This is a known working install # mysql --version mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686) # find /etc/rc.d -name *mysql /etc/rc.d/init.d/mysql /etc/rc.d/rc0.d/K90mysql /etc/rc.d/rc1.d/K90mysql /etc/rc.d/rc2.d/S90mysql

MySQL 4.1 and PHP/Perl Clients

2003-06-25 Thread PAUL MENARD
Hi All, I’m a member of a similar PHP email list and posed the question to community about issues anyone has experienced with being able to connect to MySQL 4.1. Below are my email and a response. Is this reply statement correct? Why would MySQL ‘break’ an interface to clients? Read his

Re: RedHat 9.0 - Mysql 3.23.56

2003-06-25 Thread Paul DuBois
At 10:55 -0400 6/25/03, Luc Foisy wrote: I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0 When it installed, it started up mysql, no problems, I could do all mysql functions I recently rebooted the box, and mysql did not start automatically. I can start it if I run

SHOW DATABASES user rights

2003-06-25 Thread nospam
Hello, I have a MySQL server running with some users besides root, that I want to grant all privileges for their own databases, but no rights for anything else. So to say, I have a user web01 that shall be able to do whatever he wants with the database db01. There are more databases, like db02

Re: Dumping data

2003-06-25 Thread Don Read
On 25-Jun-2003 Rob wrote: Hi all, Is there any way to do a mysql dump in which each table is dumped into a separate file. I know I can use the --tables option to specify a table, but this means I have to type out each table name (and there are a lot of them). Is there any way to get

RE: Strange Mull in show fields and table keeps crashing

2003-06-25 Thread Victor Pendleton
Do you have any sort of `shell` access to the box? SSH? Telnet? -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: Re: Strange Mull in show fields and table keeps crashing I'm not sure what errors

RE: RedHat 9.0 - Mysql 3.23.56

2003-06-25 Thread Luc Foisy
Yes, I turned those runlevels on already and now it works. The problem is that it was a practically default install, that is the way the runlevels were set out of the box 3.23.56 was this way after install mysql 0:off 1:off 2:on3:off4:on5:off6:off 3.23.52 was this

  1   2   >