Correct date query syntax

2004-08-26 Thread Yong Wang
Hi, All: I have a database which contains date attribute in string format (like 2004-08-12). I want to genearte a report based on period time. I use the syntax: date1 ='2004-08-12' date2='2004-08-18' SELECT * FROM account WHERE (TO_DAYS(date) >= TODAYS(date1)) and (TO_DAYS(date) <= TO_DAYS(date

Add new database into existing MYSQL database

2004-08-24 Thread Yong Wang
Hi, all: I use root login to create a new databse in the existing server. Then I use the existing user name in the mysql user table as user name, add the database and username .. info into mysql db table. Then mysqladmin to load the table. When I login the database using the existing user name

.my.cnf

2004-08-18 Thread Yong Wang
Hi, all: In my solaris account, there is a .my.cnf file for me to access mysql in remote machine. In the current file, it is configured as: host=sg1p.net.tamu.edu socket=/tmp/mysql.socka If I want to add other remote machine name as netinfo.tamu.edu with mysql in the .my.cnf file, How can i

Compiled c++ and mysql codes run in python cgi script

2004-08-04 Thread Yong Wang
Hi, All: We have a network management system written in C++, MysQL, and Hp SNMP. It works in Solaris command line. When I wrote a similar python codes which call compiled C++ and mysql codes in solaris command line, the comipled codes work fine in wraped python file. When I change the python