R: [PHP-DB] Delete problem
Yes i review manual many times without success -Messaggio originale- Da: Rick Emery [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 13 marzo 2002 16.52 A: 'Riccardi Moreno'; Php List; Mysql List Oggetto: RE: [PHP-DB] Delete problem MySQL does not currently support sub-selects. The manual says: DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE where_definition] [ORDER BY ...] [LIMIT rows] Did you review the manual first? -Original Message----- From: Riccardi Moreno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 9:48 AM To: Php List; Mysql List Subject: [PHP-DB] Delete problem Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all - Moreno Riccardi - www.webtrade.it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - 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
Delete problem
Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all - Moreno Riccardi - www.webtrade.it - 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
R: mysql web-based admin tool?
You could find a useful tool at http://www.phpwizard.net/projects/phpMyAdmin/ Hy Moreno -Messaggio originale- Da: Ed Lazor [mailto:[EMAIL PROTECTED]] Inviato: martedi 29 gennaio 2002 16.54 A: [EMAIL PROTECTED] Oggetto: mysql web-based admin tool? I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - 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 - 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
R: Access denied for the new created user!
Before login with new account you must reload server with this command: mysqladmin -u root -ppass reload and then you could login with new account -Messaggio originale- Da: wei song [mailto:[EMAIL PROTECTED]] Inviato: venerdi 16 novembre 2001 17.41 A: [EMAIL PROTECTED] Oggetto: Access denied for the new created user! Hi, I am a very beginner of mysql and studying the manul. I tried "set password for user1=PASSWORD('paasw'); " after logging in as root user. Then I quit, try to login as 'user1': C:\>mysql -u user1 -p and then entered the password "paasw". There always an error: Access denied for user:'user1@localhost'." Please help!!! Thanks! wei __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com - 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 - 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
FREEBSD4.4
Hi all, I install mysql-client-3.23.42 on FreeBSD4.4 from FreeBSD boot disk but I'm not able to start the server. Anyone have any ideas how to start server?? Moreno - Moreno Riccardi - 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
Migrate from mssql7 to Mysql
How can i migrate a database from mssql7 to Mysql? - Moreno Riccardi - 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.sock ???
Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me "can't connect to localhost /tmp/mysql.sock not found". How can i repair this error? Thanks Moreno - Moreno Riccardi - 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.sock ????
Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me "can't connect to localhost /tmp/mysql.sock not found". How can i repair this error? Thanks Moreno - Moreno Riccardi - 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
Image
How can i insert image in a database. - Moreno Riccardi - 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
Import Data
I want to import data from text file that contains decimal number (occasionaly with 9 decimal) but mysql import only 2 decimal. My columns is set to DECIMAL(6,9) Hi, Moreno - 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
R: InnoDB
Thanks Heikki --- - Moreno --- -Messaggio originale- Da: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 ottobre 2001 15.08 A: [EMAIL PROTECTED]; [EMAIL PROTECTED] Oggetto: Re:InnoDB Riccardi, your innodb_log_arch_dir is C:\InnoDB\iblogs but innodb_log_group_home_dir is C:\iblogs These should be the same. Your MySQL error log should contain an error message of this: C:\trybuild\client_debug>mysqld --console InnoDB: Error: you must set the log group home dir in my.cnf the InnoDB: same as log arch dir. 011005 16:00:07 Can't init databases Note that you must create the directories yourself: InnoDB does not create directories. When you install MySQL -Max, maybe it is best to start it the first time from the MS-DOS prompt like you see above. Then you see what it is doing. When you start as a service, there is less touch to the whole process. Regards, Heikki http://www.innodb.com >-Messaggio originale- >Hi All, >I want to install Mysql and InnoDb on a W2K machine. >I configure mi.ini file as it follows: > >[WinMySQLAdmin] >Server=C:/mysql/bin/mysqld.exe > >[mysqld] >port=3306 >socket=/tmp/mysql.sock >set-variable = key_buffer_size=16M >set-variable = max_allowed_packet=1M >innodb_data_file_path = ibdata1:2000M;ibdata2:2000M >innodb_data_home_dir = c:\InnoDB\ibdata >set-variable = innodb_mirrored_log_groups=1 >innodb_log_group_home_dir = c:\iblogs >set-variable = innodb_log_files_in_group=3 >set-variable = innodb_log_file_size=30M >set-variable = innodb_log_buffer_size=8M >innodb_flush_log_at_trx_commit=1 >innodb_log_arch_dir = c:\InnoDB\iblogs >innodb_log_archive=0 >set-variable = innodb_buffer_pool_size=80M >set-variable = innodb_additional_mem_pool_size=10M >set-variable = innodb_file_io_threads=4 >set-variable = innodb_lock_wait_timeout=50 > >but when i try to start mysql service (net start mysql) he return me an >error: >System error N°1067 > >Where' s the error? >- >- Moreno Riccardi >-- > > >--- - > - 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
InnoDB
-Messaggio originale- Hi All, I want to install Mysql and InnoDb on a W2K machine. I configure mi.ini file as it follows: [WinMySQLAdmin] Server=C:/mysql/bin/mysqld.exe [mysqld] port=3306 socket=/tmp/mysql.sock set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\InnoDB\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\InnoDB\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 but when i try to start mysql service (net start mysql) he return me an error: System error N°1067 Where' s the error? - - Moreno Riccardi -- - 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
R: Party!!!
It's a great idea Free your Mind -Messaggio originale- Da: Andrew Murphy [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 ottobre 2001 10.37 A: 'Deryck Henson'; MySQL Oggetto: RE: Party!!! Sounds good, as the (altered) saying goes: Life begins at 4.0! -Original Message- From: Deryck Henson [mailto:[EMAIL PROTECTED]] Sent: 04 October 2001 4:00 pm To: MySQL Subject: Party!!! Hey everyone! As most of you know the official (as in, not using a BASH shell) release of MySQL 4.0 will be out very soon. So, let's throw a party! Not like something at someone's house (although I wish we could). Just a get - together online in a chat room with games, music (mp3s), and more! Me and whoever else wants to will plan it, we just need you people to come. It is a pretty long-shot but we could probaly do it. My Web Server. ** - Deryck Henson - http://www.comp-u-exchange.com ** - 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 - 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 - 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