create table

2001-02-23 Thread Joe and Nancy M
What is wrong with this syntax, it looks like what chapter 7.7 says. mysql CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7)); I get a parse error. Thanks, Joe.

create table - NEVER MIND

2001-02-23 Thread Joe and Nancy M
Sorry, I tried it several times and kept getting the parse error. It must have been butterfingers, worked ok now. Thanks, Joe.

Honest, my last question..... for a while. MYSQLIMPORT

2001-02-23 Thread Joe and Nancy M
I have my database created on my ISP's server. I can telnet to it and log in. I have created my table. I inserted 4 test records. I have written my .php3 pages and pull the data and get the results I want. Now I need to populate the table with hundreds of records exported out of

need mysql sample to accomplish existing asp function

2001-02-19 Thread Joe and Nancy
I am in a time crunch to get mysql working on my site. I export inventory records out of my Peachtree software into Excel and planned to use that .xls table to show product pricing and availability on my web pages. Below is sample asp code that works. My ISP had told me they support asp, but