Re: how to check if table exists?

> > 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 ta

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.my

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

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. >

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 M

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

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 +

Re: My JDBC does not work.

Jianping Zhu wrote: > Invalid authorization specification: Access denied for user: > 'jianping@chambleea' (Using password: YES) > I am just wondering, I do have a account 'jianping' which have all > privilege in global level. All priv at all hosts, including localhost or localhost.localdomain

Re: problem of installing mysql

try starting it with /usr/bin/safe_mysqld & Ken Jianping Zhu wrote: > > I installed the binary version of mysql on my linux system. After i > started the server, It seems the sysem get stuck. I can see the command > line sign and the cursor. > When I open another console I can find out that the

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 wo

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