importing simple 9 records into mysql 3.23.41

2002-03-30 Thread Barbara Ferrell
mysql version 3.23.41 ...i am having a problem importing simple date and text data ( 6 fields) (from access 97). this is what i have tried: load data local infile 'client.txt' into table client fields terminated by '\t'; all 9 records imports correctly except that the quotes are still around

conceptual problem with ODBC and mysql

2001-12-26 Thread Barbara Ferrell
i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual problem with how i am going to get the data from my microsoft Access database and insert it into mysql tables. i thought i was going to use ODBC but after reading lots of pages it looks like you use this program if you

mysql and printing my tables

2001-12-13 Thread Barbara Ferrell
i am creating a database in linux redhat 7.2. i cannot figure out how to print my tables..or anything in mysql for that matter...i did not find anything in the documentation..have i overlooked something.. - Before posting,

a simple GUI to retrieve and enter MySQL data?

2001-11-27 Thread Barbara Ferrell
any favorites for a simple gui to retrieve and enter data using MYSQL. i am using redhat linux 7.2 and a beginner - Original Message - From: [EMAIL PROTECTED] To: Barbara Ferrell [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 8:59 AM Subject: Re: a simple GUI to retrieve and enter

Re: how to add NOT NULL to a column in my table

2001-11-24 Thread Barbara Ferrell
it is a primary key..i did not assign either NULL or NOT NULL when i created it. i tried all kinds of commands in the MYSQL books.. i am in Linux... - Original Message - From: [EMAIL PROTECTED] To: Barbara Ferrell [EMAIL PROTECTED] Sent: Saturday, November 24, 2001 2:02 PM Subject: Re

read only message

2001-11-18 Thread Barbara Ferrell
i am using linux redhat 7.2. on my home computer.. i am logged on as root@localhost. i get a message that my table is read only. i thought the root user had all privileges and i cannot figure out how to give myself the privilege to change and alter my database and tables after i just created

how to get a script to run/work

2001-11-10 Thread Barbara Ferrell
i want to convert my access database to mysql. and then it will run on a linux server if i ever figure out how to run these darn scripts though i downloaded mysql for windows 98. i have tried for a week to run these scripts and even reinstalled mysql and even tried it on another computer

how to run sql script in NT

2001-10-26 Thread Barbara Ferrell
i am extremely new at this: i am on NT4.0 i am in a DOS screen at the mysql prompt (mysql) the path that is described in the top of the window is: =3D c:\apache\mysql\bin\mysql.exe i wrote a script to create and load a database exactly as it said in the = =3D book.. i saved the file as

Re: where can find a lisy of keystroke commands for mysql?

2001-10-21 Thread Barbara Ferrell
- Original Message - From: [EMAIL PROTECTED] To: Barbara Ferrell [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 7:52 AM Subject: Re: where can find a lisy of keystroke commands for mysql? Your message cannot be posted because it appears to be either spam or simply off topic to our

Where can i find a list of keystroke commands for MYSQL?

2001-10-21 Thread Barbara Ferrell
i am two days new in learning MYSQL and am designing a table. i can't get back to the beginning of the table when i notice a typo and also even back to the beginning of my line without overwriting everything. i have spent forever looking everywhere .. i can't even backspace past the .

Re: Control Database size

2001-10-20 Thread Barbara Ferrell
i am totally new at this and trying to learn mysql. i just got on the list but i cannot figure out what address to send a question to. how are you doing it please? - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday,

Fw: Can Mysql search full text fast through 3.3 million text documents?

2001-10-19 Thread Barbara Ferrell
- Original Message - From: Barbara Ferrell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 19, 2001 6:51 PM Subject: Fw: Can Mysql search full text fast through 3.3 million text documents? We have 3.3 million text documents ( U.S. Patents) that we can put into any