Re: MySQL client relicense?

it's own license, not GPL), but you still can build PHP with external libmysql. this fact can affect only Win32 users, because they don't build PHP themselves (in most cases). --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http:

Re: MySQL 4.1.1 Internationalization (ENUM)

t; > `a` enum('','???','???') default NULL > > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 firstly, upgrade you mysql to current stable version (4.0.16). and imho you need cp1251_ukrainian_ci to use ukrainian characters properly. --- WBR, Antony Dovgal a

Re: Access my mysql db remotely...

rewall allows other users to connect to your host using port 3306 (which is default for MySQL), then you should put there user's hostname. smthng like this: [EMAIL PROTECTED] --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: LIMITS

ELECT * FROM tablename LIMIT 50,15; but first read about it here: http://www.mysql.com/doc/en/SELECT.html --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PASSWORD() function problem

rom member where mem_pass = > PASSWORD('xyz') - then it is not getting selected > > I do not know why I am not getting the result. please help me. what's going wrong ? mem_pass field should be at least 16 characters lengthwise to store result of PASSWORD() check it, pl

Re: deleting rows which table1.row=table2.row

On Tue, 14 Oct 2003 11:55:18 +0200 (CEST) <[EMAIL PROTECTED]> wrote: > i have mysql version 3.22 perhaps you mean 3.23 ? but no matter, it's time to upgrade definitely. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list

Re: Missing library named 'z' ??

no z library? you need libz. run these commands to locate it: locate libz.so or ldconfig -p | grep libz.so --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't find file: 'XXX.MYI' (errno: 2)

On Thu, 2 Oct 2003 07:33:55 -0700 (PDT) shahanawaz lakhani <[EMAIL PROTECTED]> wrote: > Our MySql version : "mysql Ver 11.12 Distrib > 3.23.32, for pc-linux-gnu (i686)" upgrade first. 3.23.32 is _very_ old version. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECT

Re: Select statement to get the difference

e > attachment_id = atta_id > i receive all id wich are equals in both tables. > > I need to know which id is not present in the other table. SELECT attachment_id FROM tbl1 LEFT JOIN tbl2 ON tbl1.field = tbl2.field WHERE tbl2.field IS NULL; P.S. read about SELECT & L

Re: 'IF NOT EXISTS' ignored?

t; for execution. I don't think, that this queries should be sent at once (and there is no way to do it). They can be successfully executed one by one. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 'IF NOT EXISTS' ignored?

statement. > What is your view on this? For me this is not a bug, just poorly documented feature. So, Hassan can't do it using this statement, he needs to check if table exists and then INSERT, cause the statement he's trying to use is not intended for conditional INSERT, but fo

Re: 'IF NOT EXISTS' ignored?

ain aim of this query is to INSERT data into table. And before this it checks if the table already exists and creates it if not. So, there is no problem imho. > So, in that query, will the IF condition apply for table creation only? Yes. --- WBR, Antony Dovgal aka tony2001 [EMAIL P

Re: Table crashes after optimize

n denied check if it's allright with rights on this table ? --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql compile error.

On Thu, 25 Sep 2003 15:28:15 +0200 "Richard Pijnenburg" <[EMAIL PROTECTED]> wrote: > i'm trying to compile mysql-4.0.15a on my server and i'm getting the > folowing error: Richard, please, resend your letter one more time, we have real enjoy reading it again a

Re: Temporary tables

ry tables. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: phpMyAdmin request problem

gt; http://www.mysql.com/documentation/mysql/bychapter/manual_Charset.html#Charset-cyrillic-sets > . But I have a syntaxe error in > this part of code ! Which is it ? please, tell us what error message do you get and your version of MySQL server. --- WBR, Antony Dovgal aka tony2001 [EMAIL PR

Re: INSERT data into multiple tables

ER ', ' USERADDY ',' > USERPHONE') AND table2 (name) VALUES( ' USER '); No. Use 2 queries for that: INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' USERPHONE'); INSERT INTO table2 (name) VALUES( ' U

Re: MySQL connection with PHP

admin to do it. > PHP version: 4.0.4 > MySQL version: 3.23.36-1 and it's time to update your PHP & MySQL, definitely. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to import Paradox data to MySQL?

On Wed, 24 Sep 2003 18:19:30 +0400 <[EMAIL PROTECTED]> wrote: > Is there a painless way to import Paradox data and database structure to MySQL? try to follow this advice: http://dbforums.com/arch/51/2003/5/766832 --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQ

Re: Q: Moving a database

I get an > error 13 trying to access or repair them. > > Is it possible to move a database this way? #perror 13 Error code 13: Permission denied yes, it's possible. but you should not forget about proper rights on these files. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTEC

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

le - PHP. so, you have to use some third-party application if you need connection pooling. this can be for example SQLrelay (sqlrelay.sf.net) or SRM (www.vl-srm.net - this one is rather PHP-specific). --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archive

Re: passwords

e MD5 and queries like this: SELECT * FROM users WHERE MD5('password_entered_by_user')=hashed_password_field_from_database; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

nnection pooling. In your case MySQL probably says 'too many connections' and you can catch this error message if you'll turn on error_log in php.ini. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Handling Arrays

ally become the new $array[2]? > > Thanks in advance for your help. 1) this is MySQL-general list, not php-general. 2) of course it wouldn't. just try and you'll see. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://l

Re: Show database problem

y it from mysql> > and also after I run mysqld > > Any ideas what is wrong here? > Thanks you should enter this in mysql console, not in shell. run .../mysql/bin/mysql binary (--help option will show you all possible keys) and then enter MySQL commands. --- WBR, Antony Dovgal aka tony20

Re: Abt Mysqldump

On Tue, 2 Sep 2003 17:02:37 +0530 (IST) "Uma Shankari T." <[EMAIL PROTECTED]> wrote: > but while redumping back to mysql it is giving some errors in the > textfile..is there any possibility to redump the contents without any > error.. what exactly does it say ? -

Re: Got a warning!

nt is not a valid MySQL result > resource in /srv/www/htdocs...". In all reference books I found this syntax. > Has anyone an idea what wrong? you should use mysql_free_result(); only with resources you get from mysql_query(); --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED]

Re: listing all people who have the same firstname and lastname

> 2, Cody, Edwards SELECT fname,lname, COUNT(*) as cnt FROM table GROUP BY CONCAT(fname,lname); --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: NFS and MySQL

than one server in the same data directory. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Show database problem

On Mon, 1 Sep 2003 17:19:52 +0200 "Joris Beckers" <[EMAIL PROTECTED]> wrote: > I've got a user, admFrederic > He got the grants shown below. > Those are correct and I configured them that way. don't forget about FLUSH PRIVILEGES; --- WBR, Antony Dovgal aka to

Re: Cannot Connect to Server

27;t blocked him yet. These robots are autoresponding on each message to the list with senseless messages: [EMAIL PROTECTED] [EMAIL PROTECTED] --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot Connect to Server

> Unable to select database" is MySQL socket really placed in /var/tmp? if not, than you need to specify path to it in mysql.default_socket directive in php.ini or your MySQL server isn't running on localhost at all? --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL Gene

Re: TABLE - OR

1.* FROM table1 ->LEFT JOIN table2 ON table1.id=table2.id ->WHERE table2.id IS NULL; *** --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie Question: how to set field a lookup field from another table?

Server only parses the FOREIGN KEY syntax in CREATE TABLE commands, but does not use/store this info. " http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Querying a Linux machine

On Fri, 29 Aug 2003 09:15:48 +1000 Michael Piko <[EMAIL PROTECTED]> wrote: > I should have mentioned the error: > [kryten2] ERROR 2013: Lost connection to MySQL server during query check your MySQLd log to see what happends. usually you can find it in /var/log/ --- WBR, Anton

Re: Possible: Update query within another query's loop?

On Thu, 28 Aug 2003 16:37:41 +0200 Fred van Engen <[EMAIL PROTECTED]> wrote: > Please elaborate. I've already answered: On Thu, 28 Aug 2003 17:07:19 +0400 Antony Dovgal <[EMAIL PROTECTED]> wrote: > You don't need execute UPDATE's in the loop in th

Re: Possible: Update query within another query's loop?

#x27;s from mysql_connect > and using them with other mysql functions. ouch! it's a kinda bad advice. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Possible: Update query within another query's loop?

or the row we are on. > $recid = $row["id"]; > // construct a new query > $q2 ="UPDATE `table` SET `review` = 1 where id = > '".$recid."';"; > $result2 = mysql_query($q2) > } You don't need execute UPDATE's

Re: auto_increment fields

's talking about... it's a some kind of telepathy =)) --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie Question

a mysql_*;function as I said I am > completely new to this and don't know how to set this up. visit http://php.net/mysql - you will see. I'm talking about mysql_connect();, mysql_query(); etc. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For

Re: auto_increment fields

r table, you'll destroy the correspondence. imho, he's talking about resetting auto_increment to 0, not about gaps in ID: >When I --> delete all <-- the records ... --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: auto_increment fields

table, which is much faster than deleting rows one by one." (c) I suppose TRUNCATE is more efficient way to get the same result =) --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: auto_increment fields

> Can I restart this sequence? Start from 0 again? yes, use TRUNCATE TABLE table; to restart sequence. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie Question

lem > and how do I get the driver? you don't need ODBC driver to work in PHP with MySQL. PHP has native builtin extension for MySQL. just use mysql_*(); functions and be happy =) --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://l

Re: Telemobile auto-reply

On Tue, 26 Aug 2003 02:54:13 -0700 Scott Haneda <[EMAIL PROTECTED]> wrote: > Anyone else get one of these for every post to this list? yes, every time I post an answer. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.

Re: newbie > mysql table size?

ly by your filesystem (as you understand, limits of your filesystem is not the topic to be discussed on this list). In case of win32, I suppose, the best place to search info about filesystem limits would be microsoft.com. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL Genera

Re: How many records can a single MySql Table Hold.

he performance of that table is very poor, > comparing to other tables in the same database. > Can somebody help me out. > Thanks, > Rupak Banerjee. read about query optimization and table indexes. use EXPLAIN SELECT .. to see what happends with your query. --- WBR, Antony Dovga

Re: tellme Timestamp

On Fri, 22 Aug 2003 17:14:38 -0500 "Dan J. Rychlik" <[EMAIL PROTECTED]> wrote: > Hello All, > > I am trying to find out how I can change my timestamp(14) to timestamp(8). use DATE fields instead. or use DATE_FORMAT() with TIMESTAMP to get only date. --- WBR, A

Re: My SQL Search

7;; of course, you should use LIKE only when you're seeking for partial match. in other cases use "company_name='Bla'." and don't forget about indexes. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP API Question.

On Thu, 21 Aug 2003 17:56:55 -0400 Rajesh Kumar <[EMAIL PROTECTED]> wrote: > But does anyone know of a way to find out the number of seconds it took > to execute a particular query using PHP? use microtime(); - http://php.net/microtime --- WBR, Antony Dovgal aka tony2001 [EMA

Re: PHP mysql_connect randomly failing

and to see what happends. maybe error logging will help you to solve your trouble. I don't beleive in such bugs, it's a problem of your code imho. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: PHP mysql_connect randomly failing

ysql_error() will tell something like "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)". --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: apache/mysql errors....

/assitance/pointers to resolve this would be greatle appreciated... http://www.mysql.com/doc/en/GRANT.html --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP mysql_connect randomly failing

east this function does not depend on configuration settings. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Limiting output of Text when retriving data via PHP

; > I'm using PHP with $row=mysql_fetch_row function and then printing out that > row as one of of the fields. > > Can someone aid me with this? don't retreive all this text. get some string from it using SUBSTRING() in MySQL. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED]

Re: Help with SELECT statement for date range

t; I need to > know which records are currently active. Can anyone > help with a quick SELECT statement? I suppose you need this: SELECT * FROM table WHERE NOW() BETWEEN StartDate AND EndDate; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: