Re: how to check if table exists?
What is the fastest way to check if a table exists? Do a select and catch the error? Try to create the table, and catch the error? Other options? Thanks, Ken 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-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to check if table exists?
java. 'show tables like' is what I needed. Thanks, Ken Steven Hajducko wrote: You can do a couple of things.. Are you using any other language besides SQL? ( perl, PHP? ) If you're just looking for a way to do it with sql.. you can try - show tables like tablename; It'll either give an empty set, or return the tablename. -- sh On Wed, 2002-03-27 at 14:29, Ken Anderson wrote: What is the fastest way to check if a table exists? Do a select and catch the error? Try to create the table, and catch the error? Other options? Thanks, Ken 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-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: problem
Just get the same version src rpm from any redhat mirror. Ken [EMAIL PROTECTED] wrote: hi, i have install mysql using binary installation on linux redhat 7.2. but due to some software which require access to source files of mysql, i guess i have to reinstall through source distribution. how shud i go abt it..do i have to uninstall and then install. in that case how shud i uninstall...?? reply soon. gaurav - 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: mysql/php on linux
/sbin/service httpd restart Then tail /var/log/httpd/error_log should show [notice] Apache/1.3.22 (Unix) (Red-Hat/Linux) mod_ssl/2.8.5 OpenSSL/0.9.6b PHP/4.0.6 mod_perl/1.26 configured -- resuming normal operations or something like that Ken Andy Cheng wrote: Hi all, I am using RH linux 7.2. I do have these lines: AddType application/x-httpd-php .php IfDefine HAVE_PHP LoadModule php_module modules/mod_php.so IfDefine HAVE_PHP AddModule mod_php.c IfDefine HAVE_PHP4 AddModule mod_php4.c in my httpd.conf. I think Windows version's of http.conf is different. How do I check if the module is load or installed? From: Dustin Rabe [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Sat, 23 Mar 2002 11:57:53 -0800 (PST) Try adding this to your http.conf file in apache. ScriptAlias /php/ c:/php/ AddType application/x-httpd-php .php Action application/x-httpd-php /php/php.exe My Best, Dustin Rabe --- Andy Cheng [EMAIL PROTECTED] wrote: Hello all, Thanks for the help. I move my php test script to \var\www\html When I call the php script from my browser, It shows me: ?php phpinfo(); ? and not result of the phpinfo() function. When I run php phpinfo() at the shell command, it out puts the html result. What is problem, my Apache not understand the php script? Thanks _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Re: Remote connection to MySQL Server using MS Access 2002
There are other windows front ends to mysql, but this one is the best: http://ems-hitech.com/mymanager/ Are you sure the server allows remote connections? Ken Charles McGrotty wrote: Hi, Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I can connect to a remote MySQL database. I have tried putting an IP address in that I found by lookup of the domain name, and I entered the database name and password, but I get an error saying connection from ~db_name~@~whatever_ISP~ was refused, what am I doing wrong. I do not know the actual servr name that the MySQL database lives on, so what options do I have, this must be possible so how do I do it. Alternativly, if anyone knows of any alternative tools (not phpMyAdmin (ie: not browser based)) that will allow me to look at, and work with the data, even if only in a read only enviroment at this time, though full access is desired. I would mych appreciate it. Thnx - 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: JSP or PHP?
Klym wrote: I have built a MySQL database for a web based survey. I am trying to decide between JSP and PHP for my programming interface. The reason I am considering Java is because I have some Java experience. What would you recommend for someone like me who is starting out? If you know java and like java, then use java. Check out the velocity template engine. http://jakarta.apache.org/velocity Cool stuff. I doubt you'll find a host for it though. Best to build your own server. If you are in a shared server environment, you'll probably have to use php or perl. Full Java/Servlet/JSP support is still a few years away for most hosting companies, though some do support it at additional cost. The setup and security considerations using java are a lot more complex than with perl or php. Ken Also, my two current hosting companies don't support JSP. Is this common? Is it more expensive for JSP support? Yes. Yes. thanks - 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: Java to MySQL connection
This is a servlet code example for jdbc using the mm driver. String DB_NAME = database; String DB_HOST = localhost; String DB_USER = username; String DB_PASS = password; String DB_DRIVER = org.gjt.mm.mysql.Driver; String DB_CONNECTION = jdbc:mysql:// + DB_HOST + / + DB_NAME + ?user= + DB_USER + password= + DB_PASS; try { Class.forName(DB_DRIVER); conn = DriverManager.getConnection(DB_CONNECTION); out.println(BRBRJDBC Connection succeeded.); } catch (Exception e) { out.println(e.getMessage()); } Ken Chris Stewart wrote: I'm trying to make a connection from a java app to a MySQL database I've created on my local PC. How can I tell the app where to look for the existing database? Code I'm working with: Class.forName(sun.jdbc.odbc.JdbcOdbcDriver).newInstance(); Connection con = DriverManager.getConnection(jdbc:odbc:Testing@localhost:3306, my username , my pass ); System.out.println(Connection Made.); As you can tell from this, my database is named Testing. All I'm trying to do right now is get a connection. Right now when I run this code I get Error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. I'm not sure I have the odbc driver setup correctly either. I downloaded mm.mysql-2.0.11 but I'm not really sure how to bring it into the mix as far as the driver goes. Thanks for any direction. Chris Stewart [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: error starting mysql
If you are on RedHat, you might need to do mysql grant all on books.* to [EMAIL PROTECTED] identified by 'bookorama123'; Ken Norman Zhang wrote: Hi, I assigned rights to a user in mysql, mysql grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error message, ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES) Would someone please help me how to troubleshoot this? Thanks, Norman - 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: hosting
Got an old PII sitting around? Install RedHat 7.2 w/mysql, apache, php, etc... You'll learn much more than just php and mysql, but no free service is going to really give you the access you need to learn mysql and php very well. Ken Marnix Vandegehuchte wrote: Hello, I am starting to work with mysql and php. Does anyone know where to get a hosting that is free and that supports MySql and PHP. I would like to try out first before purchase a parking space on the internet. Thanks in advance Marnix - 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