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 the

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 cont

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, plea

linux, mysql and intel processor or amd processor

2001-12-01 Thread Barbara Ferrell
i am setting up a musql database on linux. if you had a choice which processor would you use. does it really matter. i keep reading that linux runs better with an intel processor. - Before posting, please check: http://ww

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 simp

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, Nov

"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 w

> mysql < what does the < and > mean?

2001-11-01 Thread Barbara Ferrell
i am typing a command C:\apache\mysql\bin> mysql< = C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = Andrew Murphy's help. but i wondered what it meant? i have looked in = the books.. - Before postin

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

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: 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 s

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: Saturd

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