Re: Output data to file

hi... pls try this... mysql \T c:\result.txt mysql select name, email from messages; after command executed... you can use this command to stop print result to file. mysql \t; mysql have a nice try :-) Ivan Paul MySQL, Query - Original Message - From: Scott Haneda [EMAIL

mysql and asp web hosting

dear all, i'm looking for a good service/performance for web hosting which support mysql for database and asp for web programming. would you give me some suggestions to choose the web hosting? thanks a lot cheers, Ivan Paul MySQL, Query

Re: another field type bigger then varchar

Dear Victoria n Bruce, thanks a lot, it is work better now :-) cheers... Ivan Paul SQL, Query - Original Message - From: Bruce Lee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 6:13 PM Subject: Re: another field type bigger then varchar Hi, text

another field type bigger then varchar

dear all, i want to change my field type from varchar(255) into varchar2(1024) --- (as i use in oracle) can i use this in mysql? anyway i don't wanna use tinyblob/mediumblob... TIA, Ivan Paul SQL, Query - Before posting

Re: storing image in the db ????

toby, to store image in mysql database, i usually use blob/mediumblob/longblob data type. what do u mean for images in text? Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: toby gibbson [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: storing image in the db ????

toby, to store image in mysql database, i usually use blob/mediumblob/longblob data type. what do u mean for images in text? Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: toby gibbson [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: connecting to mysql via ODBC from asp.net

/city/result_city_dele_ok.html end if cheers, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from

Re: connecting to mysql via ODBC from asp.net

:-) Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net I've installed the windows

Re: Updating blob from command line

into tblob - values('Test', load_file('c:/mysql/betasw.gif')); Query OK, 1 row affected (0.00 sec) mysql select * from tblob; +---+--+ | title | pic | +---+--+ | Test | NULL | +---+--+ 1 row in set (0.00 sec) mysql \t TIA, Ivan Paul sql, query

problem in mysql - blob data type using asp

, --- can u help me? TIA Ivan Paul sql,query,mysql - 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

problem between asp and mysql in blob

, --- can u help me? TIA Ivan Paul - 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

about set page size and set line size

hi all, is there any command in mysql prompt for set page size and set line size like SQL*Plus? TIA ivan paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

about set page size and set line size

hi all, is there any command in mysql prompt for set page size and set line size like SQL*Plus? TIA ivan paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

list some records combo-box in my ASP's script

ivan paul sql,query - 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

problem when try to insert into mysql db using ASP

' The request properties can not be supported by this ODBC Driver. /mediateonline/scripts/asp/iclientdatabank_process.asp, line 33 TIA Ivan Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual

find record using MYSQL command in ASP

dear all, when i want to find some records in mysql table using ASP script language, i found an error on it. this is error message in my script: Microsoft OLE DB Provider for ODBC Drivers error '80040e29' The rowset cannot scroll backwards /find_record.asp, line 16 and this is my ASP

Re: find record using MYSQL command in ASP

Beste Defrin... thank u very much my friend. it is work! :D Cheers... - Original Message - From: Defryn, Guy [EMAIL PROTECTED] To: 'Ivan Paul' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 10:38 Subject: RE: find record using MYSQL command in ASP Hi

login root problem

and user_1. should i give grant privilege to root with all privileges or not? anybody can help me? Sorry for my bad English and thanks for advance Ivan Paul - Before posting, please check: http://www.mysql.com/manual.php