Sql Query

2002-07-09 Thread Jenny Christy
Hello all, I wud like to know one query by which i can copy/create the same table from existing table. Rgds, Jenny __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com

Re: Sql Query

2002-07-09 Thread Roger Baklund
* Jenny Christy I wud like to know one query by which i can copy/create the same table from existing table. CREATE TABLE newtable SELECT * FROM oldtable URL: http://www.mysql.com/doc/C/R/CREATE_TABLE.html -- Roger -

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-09 Thread Cams Ismael
Hello Sinisa, have you already found the origin of the problem ? How does the bugs get fixed - are they solved in patch releases or are they solved in a next release of the MySQL server ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent:

How to use teh FULLTEXT search?

2002-07-09 Thread jusob
Hello I have created a table: CREATE TABLE data (no int auto_increment, topic text, author text, date date, description text, file text, note longtext, name varchar(15), password (15), folder text, key(no), FULLTEXT(topic,author,description,file,note)); Then, I would like to a FULLTEXT SEARCH

Known bug or just me? Take II

2002-07-09 Thread Judy Simon
Hi all again, I've been experimenting and would like to know if there is a known bug in the std function when used with a group by clause? I'd like to know if others have found this problem or is it just me: I have a query without a groupby clause and the avg and std functions work fine. I add

Access a M$ Access 2000 db with MySql-front - could not open database error

2002-07-09 Thread Chuck Amadi
Hi all im aware this might not be the correct forum but i believe it's the same beast and it should be ansewered quite easily . I have been creating a M$ Access Front-end database with a MySql Back-end that im about to upload onto a ISP that supports Mysql/Php thus i have just downloaded

# Could not open database 'C:\My Documents\sps mini utility.mdb' with Mysql-frontI have been creating a M$ Access Front-end database with a MySql Back-end that im about to upload onto a ISP that supports Mysql/Php thus i have just downloaded MySql-Front . My problem is how does one connect to a previously created and complete M$ Access 2000 Database as i have a fullt functional Access thatis in my C:\My Documents So i have tried various notations in accessing ie Database (S); SEPARTED BY SEMICOLON (;)C:\My Documents\sps mini utility.mdb; 1st attempt error as below# Could not open database 'C:\My Documents\sps mini utility.mdb' - will be ignored.C;My Documents;sps mini utility.mdb; 2nd attempt error as below# Could not open database '# Could not open database 'C' - will be ignored.# Could not open database 'My Documents' - will be ignored.# Could not open database 'sps mini utility.mdb' - will be ignored.med Cheers

2002-07-09 Thread chuck amadi
Hi all im aware this might not be the correct forum but i believe it's the same beast and it should be ansewered quite easily . I have been creating a M$ Access Front-end database with a MySql Back-end that im about to upload onto a ISP that supports Mysql/Php thus i have just downloaded

SQL select rows conditional on same select

2002-07-09 Thread Carl Franks
Hi, I have 2 tables, X and Y. table X table Y ++---+ ++---+ | id | title | | id | assoc | ++---+ ++---+ | 1 | one | | 1 | 3 | | 2 | two | | 2 | 3 | | 3 | three | | 2 | 4 | | 4 | four | ++---+ | 5 | five |

RAID

2002-07-09 Thread Ismael Touama
Hi, This is my first post... I'm on redhat 7.2, using apache 1.3.23 (patched) on a PowerEdge 2500 in RAID 1 and I want to install MySQL 3.23.51... Must I set to configure the --with-raid ? Do you have good link for documentation ? I reach for in google...i'm late... thanx bbsc ism

rand() ... limit by .... my retrivals

2002-07-09 Thread toby -
hi guys im trying to retrieve 5 record each page from my db my code iz : $query_nme = SELECT firstName, lastName, title, summary FROM ctnt_inf where ctnt_id ORDER BY RAND() LIMIT 5; $query_result_handle_nme = mysql_query ($query_nme) or die ('qry failed ! DA tbl

RE: RAID

2002-07-09 Thread Simon Green
RAID --with-raid splits tables up to stop size problems or put one table on more than one disk. So is not required for hardware raid. Simon -Original Message- From: Ismael Touama [mailto:[EMAIL PROTECTED]] Sent: 09 July 2002 10:26 To: [EMAIL PROTECTED] Subject: RAID Hi, This is my

RE: RAID

2002-07-09 Thread Ismael Touama
Ok so it's to emulate it following you explanation. That's OK, I enter the line (without this option). thx bbsc ism -Message d'origine- De : Simon Green [mailto:[EMAIL PROTECTED]] Envoyé : mardi 9 juillet 2002 11:42 À : 'Ismael Touama'; [EMAIL PROTECTED] Objet : RE: RAID RAID

Drop keys does not stop indexes being created

2002-07-09 Thread Archer Barrie
Description Having followed the instructions in section 5.2.8 to create a table using LOAD DATA INFILE *without* its indexes, the indexes are *still* created at the end of the LOAD DATA INFILE statement How-To-Repeat: The following shell script demonstrates the problem. There are two directory

Re: RAID

2002-07-09 Thread Roger Baklund
* Ismael Touama This is my first post... I'm on redhat 7.2, using apache 1.3.23 (patched) on a PowerEdge 2500 in RAID 1 and I want to install MySQL 3.23.51... Must I set to configure the --with-raid ? No, this is only if you need support for tables with file size bigger than your OS can

Re: RAID

2002-07-09 Thread toby -
ismaeel Do you have good link for documentation ? http://www.mysql.com/doc/C/o/Configuring_MySQL.html good luck toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com

mySQL help

2002-07-09 Thread Yung Nguyen
Hi, I am a student, I am due to return for my final year where I must complete a final year project. I have decided to develop a JSP website connected to a database. I have installed TomCat and have been recommended to use MySQL. I have downloaded MySQL but I would like help on how I would

RE: mysql primary key question!

2002-07-09 Thread Erick Papadakis
if this interests you at all, i found this yesterday on the evolt.org mailing list. the gentleman who has put this very useful code basically suggested that i could base36 my auto_increment IDs. i will leave this here for those of you who are intersted:

Re:rand() ... limit by .... my retrivals

2002-07-09 Thread Oliver Six
toby - [EMAIL PROTECTED] wrote on 09.07.2002 11:35:40: Hi Toby, hi guys im trying to retrieve 5 record each page from my db my code iz : $query_nme = SELECT firstName, lastName, title, summary FROM ctnt_inf ^^ I think you should include id, to get the row id where

Read-Only MySQL

2002-07-09 Thread Kristian Koehntopp
I want to create a CD-ROM which contains a copy of MySQL (for Windows) and a set of MySQL databases. Is it possible to set up a read-only MySQL, that is, a MySQL running from a r/o media? Kristian - Before posting, please

A bug in BDB ALTER TABLE

2002-07-09 Thread Sinisa Milivojevic
Hi! Thank you for your test case, thanks to which this bug was solved. Full fix will appear in the next 3.23 and 4.0 releases. This is a patch : = sql_table.cc 1.101 vs edited = *** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002 --- edited/sql_table.cc Mon Jul 8 22:05:06

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-09 Thread Sinisa Milivojevic
Cams Ismael writes: Hello Sinisa, have you already found the origin of the problem ? How does the bugs get fixed - are they solved in patch releases or are they solved in a next release of the MySQL server ? Kind regards, Ismaël Sorry to have lost your e-mail. If that is about BDB

General query log option in my.cnf?

2002-07-09 Thread Håkon Eriksen
Is there a way of turning on the general query log in the my.cnf file or do I have to edit the init-script? Personally, I would very much like to have only one place to set all the configuration options (preferrably my.cnf). Setting datadir and other options both in the my.cnf file and the

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-09 Thread Cams Ismael
Hello Sinisa, the problem I had was that after I restarted mysqld (after have dropped/added a column) my data was dissapeared. So if you meant this problem I am indeed the right person. How do I apply this patch ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic

Re: Drop keys does not stop indexes being created

2002-07-09 Thread Gerald Clark
You check index files, not table names. myisamchk -k 0 -rq $MYSQLDIR/test/BestGuess.MYI Archer Barrie wrote: Description Having followed the instructions in section 5.2.8 to create a table using LOAD DATA INFILE *without* its indexes, the indexes are *still* created at the end of the LOAD

choice of field types and performance

2002-07-09 Thread Marko Djukic
what is generally better to use: - one field of type 'set' (eg.: 'apples','cherries','pears','bananas') - or multiple fields of type true/false for each value above? just to make sure, mysql doesn't store each value selected in the set in each record? or does it? thanks, marko

MySQL installation problem

2002-07-09 Thread Tang, Lianhong
Hi guys, I am trying to install MySql on Linux (Mandrake 8). And everytime when I try to start the server. like this [mysql@127 support-files]# ./mysql.server start I get the message like: ./mysql.server: @hostname@ command not found ./mysql.server: my_print_defaults command not found

Re: possible bug: alter table trashed foreign key constraints in innodb

2002-07-09 Thread Heikki Tuuri
Chuck, - Original Message - From: Chuck Simmons [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 09, 2002 4:29 AM Subject: possible bug: alter table trashed foreign key constraints in innodb sql query In version 3.23.49a when using an innodb table, alter

Re: minor enhancement request -- adding files to innodb

2002-07-09 Thread Heikki Tuuri
Chuck, - Original Message - From: Chuck Simmons [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 09, 2002 5:24 AM Subject: minor enhancement request -- adding files to innodb As a minor enhancement, the innodb database could look at improving its handling of

Re: choice of field types and performance

2002-07-09 Thread Roger Baklund
* Marko Djukic what is generally better to use: - one field of type 'set' (eg.: 'apples','cherries','pears','bananas') - or multiple fields of type true/false for each value above? Field type SET, because the field types BIT and BOOL are 'fake' (synonyms for TINYINT), occupying a full byte

Re: hundreds of undefined references from innobase when linking mysql

2002-07-09 Thread Heikki Tuuri
William, I assume you are compiling with the -O3 gcc flag? Otherwise gcc does not handle 'extern inline' functions right. The problem is probably that your gcc/libtool/linker is configured in a way that it does not do inlining as instructed by the 'extern inline' directive, or it removes the

Binding Timestamp Columns with myODBC

2002-07-09 Thread Mateus Begossi
Hi, I´ve emailed the list but my problem doesnt seem to have catch much attention. I guess a re-phrasing might help.. It´s pretty simple (I´m using myODBC 3.51 and VC++ 6.0 ) : how do I declare and bind variables/parameters for a TIMESTAMP column? Here´s what I´ve done so far: I declare my

Grants UGGH! Not working for some reason ...

2002-07-09 Thread Jay Blanchard
Hi all! I have a user that I am specifying for one database within the system. I have granted, reloaded, deleted, re-done, and screamed at the server. None the less, it still will not allow this user to do mysqlimport, as follows; mysqlimport --user=rcr_user --password=thepassword -f

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Don Vu
if you don't restart MySQL after changing the grants priviliges, you have to issue the flush privileges command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect. not sure if when you said reloaded you meant flush privileges but if not try it and

FW: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Jay Blanchard
[snip] if you don't restart MySQL after changing the grants priviliges, you have to issue the flush privileges command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect. not sure if when you said reloaded you meant flush privileges but if not try it

Re: possible bug: alter table trashed foreign key constraints in innodb

2002-07-09 Thread Victoria Reznichenko
Chuck, Tuesday, July 09, 2002, 4:26:31 AM, you wrote: CS In version 3.23.49a when using an innodb table, alter table appears to CS corrupt foreign key constraints. Try the following test case: It's described in the MySQL manual: http://www.mysql.com/doc/S/E/SEC446.html and fixed since

Re: How to use teh FULLTEXT search?

2002-07-09 Thread Egor Egorov
jusob, Tuesday, July 09, 2002, 10:20:36 AM, you wrote: j I have created a table: j CREATE TABLE data (no int auto_increment, topic text, author text, date date, j description text, file text, note longtext, name varchar(15), password (15), j folder text, key(no),

Re: Is this a bug?

2002-07-09 Thread Victoria Reznichenko
Rafal, Monday, July 08, 2002, 4:44:32 PM, you wrote: RJ mysql version 3.23.50 RJ Field kwData_wydania is of type date. As you can see, dates are different that RJ expected. Is this a bug? Nope. Check the manual: You should never have any conditions in the ON part that are used to

Re: minor enhancement request - multiple servers

2002-07-09 Thread Egor Egorov
Chuck, Tuesday, July 09, 2002, 5:17:49 AM, you wrote: CS The current mysql interfaces don't support multiple servers in a CS fantastic fashion -- either multiple servers on a single machine or CS multiple servers on multiple machines. It may be there is no great way CS to do this, but...

Re: NEWBIE - trouble creating Databases Acess Denied...

2002-07-09 Thread Victoria Reznichenko
David, Tuesday, July 09, 2002, 12:04:52 AM, you wrote: DK I keep getting Access Denied Errors when I try to login to MySql after DK running mysql_install_db script. I ran the mysql_install_db script, made DK suer the mysql process is running(checked it using netstat -a), changed the DK

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Johnny Withers
The user might need the FILE permission, I'm not sure. Also might need the LOCK TABLES permission. http://www.mysql.com/doc/G/R/GRANT.html - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Jay Blanchard [mailto:[EMAIL

Re: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Gelu Gogancea
Hi, - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 7:01 PM Subject: Grants UGGH! Not working for some reason ... Hi all! I have a user that I am specifying for one database within the system. I have granted, reloaded,

Re: Setting up hostname

2002-07-09 Thread Desmond Lee
Hi Thanks for all your help, much appreciated. I edited my both the /etc/resolv.conf and /etc/hosts to include the line 'hostname 142.135.134.154' of course, that's not my real ip addy. Am i suppose to edit these files? or did you mean to edit the /etc/sysconfig/network file. THe

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Luc Foisy
[snip] if you don't restart MySQL after changing the grants priviliges, you have to issue the flush privileges command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect. not sure if when you said reloaded you meant flush privileges but

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Jay Blanchard
[snip] I have a user that I am specifying for one database within the system. I have granted, reloaded, deleted, re-done, and screamed at the server. None the less, it still will not allow this user to do mysqlimport, ... [/snip] Figured it out. The user must have FILE privileges in order to

Error at compilation...can I ingore ?

2002-07-09 Thread Ismael Touama
Oï, I just configure my Makefile (is that the good one ?), and I obtain the following errors... make[2]: *** [libmysql.lo] Error 1 make[2]: Quit the '/root/MySQL/mysql-3.23.51/libmysql' directory make[1]: *** [all-recursive] Erreur 1 make[1]: Quit the '/root/MySQL/mysql-3.23.51' directory make:

NEWBIE: Access Denied Errors after Rebooting

2002-07-09 Thread David Kramer
I was able to login and generate a database instance, but then got a little crazy and tried to automate the starting and stopping of the mysql service. I copied the mysql.server file to my /etc/init.d directory and then created the necessary links to the rc0.d and rc3.d directories. When I

AUTO_INCREMENT problem even worse!

2002-07-09 Thread Steve Hay
Hi, I've continued trying to solve the problem that I emailed yesterday regarding AUTO_INCREMENT, and I just seem to be going backwards. The sample database/software that I sent yesterday had a UNIQUE constraint and a couple of SELECT statements. I thought that removing them bizarrely made

RE: NEWBIE - trouble creating Databases Acess Denied...

2002-07-09 Thread David Kramer
Victoria thanks for the response but I was able to solve my issue already. Yes I needed to run mysql_install_db then I started the safe_mysql --skip-grant, logged on as root without password and updated the root user's password on the user table. Thanks for the help!!! DK David -Original

Re: BLOB insert problem used ' '

2002-07-09 Thread Mark Worsdall
Hi all, Sorry should have got my mind around the LOAD_FILE('./image.tiff') method. M. In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi, After a good old slurp of an image I am trying to stick it into my table. # Slurp file foreach (@image_list) { my $image =

Re: General query log option in my.cnf?

2002-07-09 Thread Myk Melez
Håkon Eriksen wrote: Is there a way of turning on the general query log in the my.cnf file or do I have to edit the init-script? Yes, all command-line options can be specified in my.cnf. Read the following page for more info: http://www.mysql.com/doc/O/p/Option_files.html -myk

Database documentation

2002-07-09 Thread Gigi Di Leo
Hello list. At the end of a db programming job (using php) I have been asked for a document describing in details the structure of a MySQL database. The purpose of the document is to make other DB people able to manage and interface the database (I can figure out that there is also the intent

C API: mysql_data_seek

2002-07-09 Thread Chan WieVia ICM N MC MI E3 Extern
Hi, I'm using the MySQL built-in C function, mysql_data_seek, for accessing a particular row from the Result (MYSQL_RES) returned by mysql_store_result. int sql_result; MYSQL_RES *MResult; MYSQL_ROW row; MYSQL

RE: Access a M$ Access 2000 db with MySql-front - could not open database error

2002-07-09 Thread Wouter van Vliet
I'm not very sure of myself ... but maybe you'd try to use quotes around the file path? -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens

job spam

2002-07-09 Thread Jeffrey Lomas
List, I'm looking for a developer in eastern Massachusetts with the following skills to work on some ongoing projects: MySQL Oracle CGI Perl PHP Java JSP C++ This is a contract position. Resumes can be sent to [EMAIL PROTECTED]

Basic Q's: Numerical Sorting

2002-07-09 Thread CVIOG at UGA
I have a fairly basic question: How do I sort numerically? Normally when I query using ORDER BY (field), it orders by the first digit (i.e. 1, 10, 2, 21, 3, 32) rather than by number (1, 2, 3, 10, 21, 32). Thanks for any help Dave __ Do You

Lost connection to MySQL server during query

2002-07-09 Thread Steve Mertz
Hi. I keep getting Lost connection to MySQL server during query marcos:mysql-3.23.51 {117} mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Lost connection to MySQL server during query' Server timeout is set for 8 hours (default) and I have been trying to hit the

Re: Basic Q's: Numerical Sorting

2002-07-09 Thread Serge Paquin
It looks like your field is a text field rather than BIGINT or some numerical field. Changing the field type should solve your problem. Serge. - Original Message - From: CVIOG at UGA [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 4:22 PM Subject: Basic Q's:

RE: Basic Q's: Numerical Sorting

2002-07-09 Thread Luc Foisy
Here is the solution I posted about t months ago. I would also add, this solution can handle both text and numbers in the same field...: my boss figured out a nice solution to this ORDER BY IF(ABS(Item) 0,LPAD(Item,9,'0'),Item) This will pad numbers ( ok it might not do so hot with DECIMAL,

Re: Basic Q's: Numerical Sorting

2002-07-09 Thread Dan Nelson
In the last episode (Jul 09), CVIOG at UGA said: I have a fairly basic question: How do I sort numerically? Normally when I query using ORDER BY (field), it orders by the first digit (i.e. 1, 10, 2, 21, 3, 32) rather than by number (1, 2, 3, 10, 21, 32). Either alter the table to make that

Re: Lost connection to MySQL server during query

2002-07-09 Thread Michael Bacarella
Is there anything in the error log? See mysql/data/hostname.err -M On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote: I keep getting Lost connection to MySQL server during query marcos:mysql-3.23.51 {117} mysqladmin version mysqladmin: connect to server at 'localhost' failed

Re: Lost connection to MySQL server during query

2002-07-09 Thread Steve Mertz
No, nothing other than the startup and shutdown messages. And every once and a while: 020708 21:00:46 Error in accept: Bad file descriptor But this doesn't happen all the time after restarting the database and I still have problems so I don't think that this is related. Thanks! -- Steve

New tool

2002-07-09 Thread Alexander Burbello
People, there is a new tool on the site: http://geocities.yahoo.com.br/burbello/ it's worthwhile. sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/

Re: C API: mysql_data_seek

2002-07-09 Thread Gelu Gogancea
Hi, It's ok but you must retrieve data from row. int sql_result;x,i; MYSQL_RES *MResult; MYSQL_ROW *row; MYSQL *MQuery; char SQLQuery[]; sprintf( SQLQuery, SELECT * FROM Profile ); sql_result = mysql_query(SQLQuery); MResult = mysql_store_result(MQuery);//mysql_store_result return in

RE: UDF, Can anyone please help?

2002-07-09 Thread Miles Roper
This returns mysql Select Field1, Field2, MAX(IDField) From amain Group by Field1; +++--+ | Field1 | Field2 | MAX(IDField) | +++--+ | A | 1 |4 | | B | 7 |8 | | C | 1 | 12 |

RE: UDF, Can anyone please help?

2002-07-09 Thread Miles Roper
Hi Francico, yes that would work. Thanks. The only thing I don't like is created a 200,000 record temporary table. I may have a different solution, will post it soon. -Original Message- From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 10 July 2002 02:22 To: Miles

undocumented change in behavior?

2002-07-09 Thread Chuck Simmons
There appears to be an undocumented change from 3.23.49 to 3.23.51, possibly for the worse. Consider two sessions executing the following sequence of commands on an innodb table (assume maximum ACID properties): session 1 begin; session 1 update table set field = field + 1 where

Re: Lost connection to MySQL server during query

2002-07-09 Thread Gelu Gogancea
Hi, My opinion: This can be a very good reason to kill the socket(is a file too) which is open during query. This error show you that you have too many open files in the system.I tested something like this(Linux - Red Hat 7.2) some time ago and after 2000 (this mean sockets) clients connected

UDF Last Solution

2002-07-09 Thread Miles Roper
Hi All, Well I think I actually managed to fumble my way to a solution to this. I took the example avg_cost UDF function and modified it somewhat (well, hacked it to pieces). I've tried this before but I actually tried to rewrite it, bad mistake. This time I just deleted all the bits I didn't

Re: Database documentation

2002-07-09 Thread Francisco Reinaldo
Hi, These tools are not open source: http://www.thekompany.com/products/dataarchitect/ You can download the evaluation. It supports MySQL directly: http://www.datanamic.com/download/download_dezign.html If you are not familiar with database methodology and relation entity diagrams, I

COMMENT For tables

2002-07-09 Thread Tam, Michael
Hi all, I would like to confirm that MySQL only allows putting COMMENT in TABLE LEVEL but not in COLUMN LEVEL. Am I right? Regards, Michael --- Michael Tam - NFI

Re: undocumented change in behavior?

2002-07-09 Thread Heikki Tuuri
Chuck, - Original Message - From: Chuck Simmons [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 10, 2002 1:08 AM Subject: undocumented change in behavior? There appears to be an undocumented change from 3.23.49 to 3.23.51, possibly for the worse. Consider

bug with like, latin1 and umlaut ü/y

2002-07-09 Thread oliver
Description: I was trying to find every row in a table which contains the umlaut ü (ue). MySQL listed every row which contained the umlaut and rows which contained the letter y, but no umlaut... Client and server characterset is latin1. How-To-Repeat:

Bug in drop database mysql 4.0.1-2

2002-07-09 Thread Scott Olson
I posted a couple of days ago on what appears to be a bug in drop database of mysql-max-4.0.1-2. Here is a recipe to see if others are seeing the same problem. This is on Red Hat Linux 7.2 and is extremely repeatable nor is it limited to a single linux box (ie. not likely hardware problem).

Re: Read-Only MySQL

2002-07-09 Thread Gerald R. Jensen
Kristian: Possible? I suppose, but not very practical. It would be ssllooww, you'd need to supply an application to permit access to the data, and how would you handle licensing? Gerald Jensen - Original Message - From: Kristian Koehntopp [EMAIL PROTECTED] To: MySQL

Re: Read-Only MySQL

2002-07-09 Thread Colin Faber
Like Kristian says, I don't see why you couldn't do something like that, Though you may want to setup mysql to have a very large amount of cache to pool from this way you can speed performance of it. Gerald R. Jensen wrote: Kristian: Possible? I suppose, but not very practical. It would

query to update record by the position of row

2002-07-09 Thread Pichan M.
Is there a query to update record by specify the position of record or row? update tableA set col_name = somthing ...( at row number 123) thanks for help! Regards, _ MSN Photos is the easiest way to share and print your photos:

Re: query to update record by the position of row

2002-07-09 Thread Dan Nelson
In the last episode (Jul 09), Pichan M. said: Is there a query to update record by specify the position of record or row? update tableA set col_name = somthing ...( at row number 123) SQL tables do not have row numbers. The only way to absolutely identify a record is by a unique ID in the

mysql replication

2002-07-09 Thread sinu
Hi All, I have 3 mysql servers with Red Hat 7.2 as the OS (Mysql-3.23.49). I am naming the 3 PCS as A,B and C. I have a table named files-info in all the 3 mysql servers. My requiremnet is I want two way replication between A to B and A to C. Now I have two way replication between A to B. I want

Char type changes to Varchar type

2002-07-09 Thread Michael Ivanyo
I am using MySql with InnoDB and have just discovered that tables created using char types show up as varchars when I type, describe tableName. Previously, I was using MyIsam tables and did not see char types being changed to varchars so I am a bit puzzled. This is true for almost all of the

Token parsing incorrect behavior

2002-07-09 Thread robbat2
Description: I have been writing an SQL tokenizer for the phpMyAdmin project, on which I am a core developer. I used this page (Manual 6.1.2 Database, Table, Index, Column, and Alias Names) for reference as to what a valid token was. As well as this reference on SQL User Variables

Re: Char type changes to Varchar type

2002-07-09 Thread Dan Nelson
In the last episode (Jul 09), Michael Ivanyo said: I am using MySql with InnoDB and have just discovered that tables created using char types show up as varchars when I type, describe tableName. Previously, I was using MyIsam tables and did not see char types being changed to varchars so I

Significance of /*!32312 IF NOT EXISTS*/;

2002-07-09 Thread Todd Cary
In my mysql dump of a DB using the -B switch, I get CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc; What is the significance of /*!32312 IF NOT EXISTS*/ - the /*!32312? Isn't the statement commented out? With the CREATE TABLE, what happens if the table already exists? Todd -- Todd Cary

Re: Database documentation

2002-07-09 Thread mos
At 01:15 PM 7/9/2002, you wrote: Hello list. At the end of a db programming job (using php) I have been asked for a document describing in details the structure of a MySQL database. The purpose of the document is to make other DB people able to manage and interface the database (I can figure

Re: Char type changes to Varchar type

2002-07-09 Thread mos
At 10:19 PM 7/9/2002, you wrote: I am using MySql with InnoDB and have just discovered that tables created using char types show up as varchars when I type, describe tableName. Previously, I was using MyIsam tables and did not see char types being changed to varchars so I am a bit puzzled. This

Re: Significance of /*!32312 IF NOT EXISTS*/;

2002-07-09 Thread Jeremy Zawodny
On Tue, Jul 09, 2002 at 08:51:05PM -0700, Todd Cary wrote: In my mysql dump of a DB using the -B switch, I get CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc; What is the significance of /*!32312 IF NOT EXISTS*/ - the /*!32312? Isn't the statement commented out? That's a hint to MySQL

Mysql++

2002-07-09 Thread Hari Dass Khalsa
I downloaded mySql++ for mac OS X. It didn't give me any header files but the examples required them. Where can I get those or do I not need them? === Hari Dass S. Khalsa [EMAIL PROTECTED] - Before posting, please

Connectiing mySQL db on Localhost to mySQL DB on Server

2002-07-09 Thread Thomas Edison Jr.
Hi, I would like to export Table Data which is on my localhost mySQL Server, to a Table in mySQL on the Internet Web Server. How can i do that? Basically it's just moving mySQL Table Data from localhost to web server on the internet! Is it possible? if so, how? Thanks, T. Edison Jr.