default-character-set problem
Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list --- sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to use comma instead dot in numeric values?
I had the same problem. No, in MySQL you can't. But you can use number_format() function of PHP. Check PHP Manual for How-to Nikos --- Putte Koivisto [EMAIL PROTECTED] : Is there a simple solution to define MySQL to use comma instead of dot in numeric fields? Sincerely, Putte koivisto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
float digit
How can i change the floating point '.' to ',' as a decimal separator in MySQL 3.23... in Linux RH 7.2? Nikos - sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my.ini in RH Linux 7,2
In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? Thanx Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL LOGS
Does anybody know how to make log files for each of my databases? Thanx sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Flash MySQL
For the one who need help about using Flush and Mysql, there is a tutorial in the phpbuilder.com, which is enough good. Nikos --- Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown MySQL Server Host 'localhost' (11001)
I've got apache in Win32 system and MySQL 3,32... intall also. As far as i know mysql admin needs a server (loclhost) to work. The ODBC@localhost apears to me when i havn't give permisions to a user to select a database. You should check mysql database where you choose permisions. Nikos --- Kevin Walker [EMAIL PROTECTED] : I did not have Apache installed at the time I reported this problem, but I do now. I was under the impression that the presence of Apache or any other server was not necessary, if all I am doing is creating a standalone database, not hooking up with a web page. Another member of the list suggested running WinMySQLAdmin to solve my problem. It worked. my.ini was created and now I can create and modify databases. My only problem now is that the user name for all processes is ODBC@localhost. I don't want this but don't know how to change it as yet. Thanks for responding. Kevin Kevin, have you got install Apache HTTP server? --- Kevin Walker [EMAIL PROTECTED] : Hi all I've recently downloaded and installed MySQL 3.23.52 for Windows. I'm running Win95 OSR2, and Winsock2 is installed. This is a standalone PC with no web server or PHP installed on it. As per the manual I started the server using c:\mysql\bin\mysqld. By pressed Ctrl-Alt-Del I can confirm that mysqld is in the task list. The mysql.err file states 'Waiting for connections'. I then tried to close the server, using mysqladmin -u root shutdown. This generated the message 'Unknown MySQL Server Host 'localhost' (11001). Check that mysqld is running on localhost and that the port is 3306'. If I type 'telnet localhost 3306' I get the message box titled 'Connect Failed'. Similarly, if I try to run mysql itself I get Error 2005: Unknown MySQL Server Host 'localhost' (11001). I don't have any my.ini or my.cnf files resident on this PC. None was created by the setup program. It seems I've overlooked something quite simple, but this is my very first attempt to work with MySQL. Can anybody suggest what I have done wrong, or what I have failed to do or set? Thanks if you can help. Rgds Kevin - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown MySQL Server Host 'localhost' (11001)
Kevin, have you got install Apache HTTP server? --- Kevin Walker [EMAIL PROTECTED] : Hi all I've recently downloaded and installed MySQL 3.23.52 for Windows. I'm running Win95 OSR2, and Winsock2 is installed. This is a standalone PC with no web server or PHP installed on it. As per the manual I started the server using c:\mysql\bin\mysqld. By pressed Ctrl-Alt-Del I can confirm that mysqld is in the task list. The mysql.err file states 'Waiting for connections'. I then tried to close the server, using mysqladmin -u root shutdown. This generated the message 'Unknown MySQL Server Host 'localhost' (11001). Check that mysqld is running on localhost and that the port is 3306'. If I type 'telnet localhost 3306' I get the message box titled 'Connect Failed'. Similarly, if I try to run mysql itself I get Error 2005: Unknown MySQL Server Host 'localhost' (11001). I don't have any my.ini or my.cnf files resident on this PC. None was created by the setup program. It seems I've overlooked something quite simple, but this is my very first attempt to work with MySQL. Can anybody suggest what I have done wrong, or what I have failed to do or set? Thanks if you can help. Rgds Kevin - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Euro sign mysql
The html symbol for euro sign is: euro; (without quots) if that helps. Is it neccecery to insert it in the database? --- Derk van der Harst [EMAIL PROTECTED] : Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: script for complete Database dump?
I suggest you to copy the database files. If you are the administrator in a Linux system make a cron once (for example) a week to copy this files to somwere else. --- Kai Vermehr [EMAIL PROTECTED] : is there any single MySQL script that would backup my complete database? thanks! Kai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Character set
I had the same problem with greek characters. I set field as binary and the problem corrected. --- National Theater of Greece [EMAIL PROTECTED] : Hi. I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with it. If anyone of you has done the same he must have realized that many of the files are quite different than the files of MySQL that came with the standard installation described in the maual. My problem is that I have to change the character set to greek because all the 'select' commands including 'order by' do not display the elements in the correct order. The MySQL manual doesn't help me because the SuSE MySQL deamon starts with 'rcmysql start' (instead 'mysql') and the '--default-character-set=greek' parameter isn't doing anything... Has anyone else faced the same problem (in any other language than english)? I'm quite new in Linux and I may have done some other mistakes when installing so I would be very greatfull to anyone who could help me... Achilles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can't use the table. What happen, please!!!!!!!!!!
Did you flush-privileges? --- Sandra [EMAIL PROTECTED] : Hi all, I am getting the error when trying to connect server from my client: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in . I had my tables in test database, but created a new database and passed my tables to there. Since then I receive that message when I execute my .php I used GRANT to assing the user privileges. any answer? thanks, Sandra - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to separate different domains on an e-mail database
Its a PHP function my friend. I'm using 3,23... --- DL Neil [EMAIL PROTECTED] : Nick, Explode: which version of the MySQL manual are you using? =dn - Original Message - From: nick gatsis [EMAIL PROTECTED] To: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 09, 2002 2:33 PM Subject: Re: How to separate different domains on an e-mail database You must create an extra field in your database to store the domain. Use the explode() to seperate the domain from ...@ (array explode (string separator, string string [, int limit]) Returns an array of strings, each of which is a substring of string formed by splitting it on boundaries formed by the string separator. If limit is set, the returned array will contain a maximum of limit elements with the last element containing the whole rest of string. If an empty string () is used as the separator argument, then explode() will return FALSE. If separator contains a value that is not contained in the string argument, thenexplode() will return the string argument. Note: The limit parameter was added in PHP 4.0.1 Example 1. explode() example $pizza = piece1 piece2 piece3 piece4 piece5 piece6; $pieces = explode( , $pizza); )Form PHP manual Cheers --- Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] : Hello all, I've got an e-mail database of our subscribers and I would like to have a SQL statement do select DISTINCT domains. Meaning, I want to know all domains. I whish I could query it so that it would show me just once each domain, or everything that is after the @ sign. Does anyone knows how to query it? The e-mail field has 50 chars long. Each user (whatever is before the @) has a different lenght off course. So I need to list just once each domain. Any ideas or suggestions? Thank you in advance, C.F. Do You Yahoo!? @yahoo.gr http://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP form to mySQL
Check some articles in http://www.devshed.com/Server_Side/MySQL, http://www.devshed.com/Server_Side/PHP --- JeRRy [EMAIL PROTECTED] : Hi, I am trying to setup a PHP form to send to mySQL database. I know how to connect to mySQL but need help getting the information in the form to update into the mySQL database. I have the following table called contacts, I'd like the form to have the following fields. firstName lastName email I have created the table in my database but now need the code(s) to put in my PHP page for the form than once submit is clicked the table in my database will be updated. I'm too familiar with ASP and just started using PHP not long ago, so if anyone can help please let me know. I have tried some online resources but I continue to get errors so think I am doing something wrong. So I thought I'd post here so my question can be answered. Thankyou! http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to separate different domains on an e-mail database
Hi DN. If there is a quisker solution is OK to me. But i dont know it. I believe that when a user (anybody) inserts data in a database, you can sereate the information you want that time. Then you just call the results from the table (you have them ready) and dont ask the server to work for it. If you know an other solution, i'll be happy to learn it. Cheeres --- DL Neil [EMAIL PROTECTED] : Nick, Understood - but did Carlos say that he is using PHP, and why use PHP when a more efficient/quicker MySQL solution is available? =dn - Original Message - From: nick gatsis [EMAIL PROTECTED] To: DL Neil [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 12, 2002 9:06 AM Subject: Re: How to separate different domains on an e-mail database Its a PHP function my friend. I'm using 3,23... --- DL Neil [EMAIL PROTECTED] : Nick, Explode: which version of the MySQL manual are you using? =dn - Original Message - From: nick gatsis [EMAIL PROTECTED] To: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 09, 2002 2:33 PM Subject: Re: How to separate different domains on an e-mail database You must create an extra field in your database to store the domain. Use the explode() to seperate the domain from ...@ (array explode (string separator, string string [, int limit]) Returns an array of strings, each of which is a substring of string formed by splitting it on boundaries formed by the string separator. If limit is set, the returned array will contain a maximum of limit elements with the last element containing the whole rest of string. If an empty string () is used as the separator argument, then explode() will return FALSE. If separator contains a value that is not contained in the string argument, thenexplode() will return the string argument. Note: The limit parameter was added in PHP 4.0.1 Example 1. explode() example $pizza = piece1 piece2 piece3 piece4 piece5 piece6; $pieces = explode( , $pizza); )Form PHP manual Cheers --- Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] : Hello all, I've got an e-mail database of our subscribers and I would like to have a SQL statement do select DISTINCT domains. Meaning, I want to know all domains. I whish I could query it so that it would show me just once each domain, or everything that is after the @ sign. Does anyone knows how to query it? The e-mail field has 50 chars long. Each user (whatever is before the @) has a different lenght off course. So I need to list just once each domain. Any ideas or suggestions? Thank you in advance, C.F. Do You Yahoo!? @yahoo.gr http://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.gr http://www.otenet.gr Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: Re: Importing into MySQL from Access
Did you try to make an .csv file and then import it with Mysql-Front? I believe that both tables have the same structure. --- Ian Zabel [EMAIL PROTECTED] : I already have my table structure in place in MySQL, and I just want to import the data from my Access 2000 database. (the .mdb is about 50 megs) The MySQL server is on a Linux system. I've been using DBTools to do the import, because it allows me to import just the data, and not create the tables. (I don't want it to create the tables, because it's creates them inccorectly. I used another tool to create the schema, and and fixed all the problems with it.) My problem is that when the import is done, all my varchar (text in access) and text (memo in access) field data leaves behind escape switches. All quotes look like this \' or \ and all linefeeds look like this \r\n. I also have other weird characters in the data. If I export the data using MySQL-Front, I get stuff like this: \\\ \\\' \\r\\n Also, some of my data has special characters like the ellipses characer, ., and when I view access the data through my code, it comes out like this ?. What is the best way to import data to a MySQL server on Linux and preserve the correct escaping? Ian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? @yahoo.gr http://www.otenet.gr Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to separate different domains on an e-mail database
You must create an extra field in your database to store the domain. Use the explode() to seperate the domain from ...@ (array explode (string separator, string string [, int limit]) Returns an array of strings, each of which is a substring of string formed by splitting it on boundaries formed by the string separator. If limit is set, the returned array will contain a maximum of limit elements with the last element containing the whole rest of string. If an empty string () is used as the separator argument, then explode() will return FALSE. If separator contains a value that is not contained in the string argument, thenexplode() will return the string argument. Note: The limit parameter was added in PHP 4.0.1 Example 1. explode() example $pizza = piece1 piece2 piece3 piece4 piece5 piece6; $pieces = explode( , $pizza); )Form PHP manual Cheers --- Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] : Hello all, I've got an e-mail database of our subscribers and I would like to have a SQL statement do select DISTINCT domains. Meaning, I want to know all domains. I whish I could query it so that it would show me just once each domain, or everything that is after the @ sign. Does anyone knows how to query it? The e-mail field has 50 chars long. Each user (whatever is before the @) has a different lenght off course. So I need to list just once each domain. Any ideas or suggestions? Thank you in advance, C.F. Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Adding super user
Try this: Use mysql tables, change or add record in user table. If you add password (and you must) use password('password'). Then flush-previleges from mysqladmin. Also, you must change host and db tables. Go to www.devshed.com and read access granted article. Cheers --- Marius Pana [EMAIL PROTECTED] : I have installed SuSE Linux 7.3 with Apache, MySQL and php. Everything is running fine but how come when I run mysql at the command line it doesnt ask me for a password? How do I set up a super user? Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php