Need book, but have basic question ??
I have downloaded the ODBC driver and while I am fumbling [still reading] about that the reference it makes if for *.MDB similar extensions. I have cruised through the on-line manual and still have no idea how to create one of those type extensions with a MySql database. I am sure it is in there, but darned if I can find it Or am I doing something I shouldn't? Chuck = Incoming rounds always have the right of way - Rules of War - 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: Load local data infile problem
What I did was setup my file in mysql directory (i.e. fred.txt) LOAD DATA INFILE C:\\mysql\\fred.txt INTO TABLE data_table; Hope this helps, but only a workaround... Chuck http://68.43.100.7:81/aa8vs == Patriotism is the willingness to kill and be killed for trivial reasons. - Bertran Russell -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 3:59 PM To: Prathmesh J. Mahidharia; [EMAIL PROTECTED] Subject: Re: Load local data infile problem Prathmesh, I have just installed mysql and am facing problems with the Load data local infile problem. I went through the manual and did all that was said like including the command --enable-local-infile and --local-infile[=1], but it does not seem to work. I posted the same problem a couple of days ago. LOCAL will not work because of a security improvement the MySQL folks applied. As far as I could figure out, the only way to solve this issue is to grab a source distribution and compile MySQL with --enable-local-infile. All the command line options the manual describes do not work at all! I wonder if - finally and hopefully - someone from MySQL will reply to the LOCAL problem mails, and tell us what to do (maybe there's a workaround), or when the problem will be solved. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Prathmesh J. Mahidharia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 5:22 AM Subject: Load local data infile problem hello there, I have just installed mysql and am facing problems with the Load data local infile problem. I went through the manual and did all that was said like including the command --enable-local-infile and --local-infile[=1], but it does not seem to work. I have the version 4.0.6-gamma-max-nt. If u could plz, help me out with that, that would be very nice of u! I m developing a project at the moment and have got to make large entries into mysql tables, but this command is not working properly and i m stuck! Could u plz help me out with that..? Thank u in advance. Regards: Prathmesh Mahidharia PRATHMESH J. MAHIDHARIA B.E. (Electrical) M.Sc.Information Technology (Murdoch Uni, Australia) Phone no: (+61) 0421167375 - 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
RE: I'm new in Mysql
Please see last line comments text null, I do not believe you need the ',' between the End of statement and the ')' Try this: create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null ) ; Regards, Chuck http://68.43.100.7:81/aa8vs == Patriotism is the willingness to kill and be killed for trivial reasons. - Bertran Russell -Original Message- From: Beogradjanin [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:39 PM To: [EMAIL PROTECTED] Subject: I'm new in Mysql Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create table guestbook - ( - name varchar( 40 ) null, - location varchar( 40 ) null, - email varchar( 40 ) null, - url varchar( 40 ) null, - comments text null, - ) - ; ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql Whats wrong here -- Best regards, Beogradjanin mailto:[EMAIL PROTECTED] - 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
RE: SQL Lists comment
To the MySQL group!Happy 2003 and have a safe holiday season... Hopefully this got past the filter LOL Chuck - 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: Count and Selects
I am new at this, but if listings and agents are both tables I do not see a reference in the select statement: select name, count(*) as cnt from agents as p1, listings as p2 where p1.name = p2.agent; Or something like that Chuck http://68.43.100.7:81/aa8vs == Patriotism is the willingness to kill and be killed for trivial reasons. - Bertran Russell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 2:14 PM To: [EMAIL PROTECTED] Subject: Count and Selects I'm trying to get a count of records by combining a search from 2 seperate tables. I have both listings and agents as tables. What I need to do is get a agent, ad count for all the agents listed in agents even if they don't have any ads in listings. Here's the query: select name, count(*) as cnt from agents where name = listings.agent; I keep getting an error saying unknown table listings but it is definately there. TIA, 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
RE: Can not write to a file in /home/.....
Did you also check directory permissions? What system are you using? Chuck http://68.43.100.7:81/aa8vs == Patriotism is the willingness to kill and be killed for trivial reasons. - Bertran Russell -Original Message- From: sam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 5:51 PM To: MySQL List Subject: Re: Can not write to a file in /home/. I executed the following statement: SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM fool; I get the error meassge Can't create/write to file '/home/medic/outfile.txt' (Errcode:13) I followed the solutions from the manual A.3.3 Problems with File Permissions and still have a problem. I created a my.cnf and when I put in the line: set-varibale = UMASK=0777 in the {mysqld} section - the deamon will not start. I created a script as follows: UMASK=0777 export UMASK UMASK_DIR=0777 export UMASK_DIR etc/bin/safe_mysqld Can anyone help sam, - 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
RE: Access to MySQL
Yves, I am always open for cleaner method, but what I did was in MySQL created a table 'member' for data. In Access exported as .txt make sure tab sequential. Back in MySql I made database active that had 'member' And did a: mysql load data infile c:\\mysql\\tmp.txt into member; it actually went in quite cleanly. I am sure there are probably better ways, I am always willing to learn. But this is what worked for me today. Regards, Chuck -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:21 PM To: 1Mysql Subject: Access to MySQL Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault Carrefour Infotech 5,promenade Acadian Charlottetown, IPE C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 ICQ #117650823 - 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
RE: MySQLd-nt -3.23.53 Max
I have some Access pages hooked to web, but a newbe with this [mysql] on laptop. Running NT, windows office '98. I have found some stuff going through tutorial, which I am impressed at how much is really working right out of the book. I am sure has been found. but I was not able to get [following] to work: LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet; {tutorial} not supported LOAD DATA INFILE c:\\mysql\\pet.txt INTO TABLE pet; works fine and the '\' is a delimiter, so must be repeated. Regards, Chuck = People are more violently opposed to fur than leather because it's safer to harass rich women than motorcycle gangs. - D Raasch - 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