MySQL 5 has a CSV storage engine
You can read Page 639 of the MySQL Administrator's Guide and Language Reference
(2nd edition)
ISBN 0-672-328700-4
Try this:
Step 1:
CREATE TABLE NewDataCSV (firstname varchar(30),lastname varchar(30))
Engine=CSV;
This should create NewDataCSV.frm and NewDataCS
You'll probably need to create a database first (to host the table).
This can be done most easily from the GUI MySQL Administrator tool, or
from phpMyAdmin if you have it, or from a mysql command line:
http://dev.mysql.com/doc/refman/5.0/en/create-database.html
To create a table use the CREAT
Hi Venu,
I would like to know the OS your using (for mysql server), BTW if
your using window. Try installing the myodbc and configure it so that
vfoxpro can communicate with it.
check this site:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP
At 06:28 PM 5/22/2006, VenuGop
Sabeer-
Welcome to the list! I'm pretty much a lurker here, but I have learned
a lot. You've come to the right place to get your MySQL questions
answered.
Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my bes
Sabeer-
Welcome to the list! I'm pretty much a lurker here, but I have learned
a lot. You've come to the right place to get your MySQL questions
answered.
Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my bes
From: Norm Lamoureux <[EMAIL PROTECTED]>
> I downloaded the lastest version of MySQL the other day but it
> all looks greek to me, not like a database like ACCESS or Alpha Five.
Now I'm with you! You're talking about a database being a program with a nifty front
end for the users as well as a ba
Hi,
You got part right, the database I use at home is Edibase for DOS, the
program has been updated for Windows, too expensive for that and the web
plug in ($5,000.00 I think) I am trying to port it over to a Windows
Database. I downloaded the lastest version of MySQL the other day but it
all look
From: Amer Neely <[EMAIL PROTECTED]>
> I think what Norm is trying to do... is search a DOS-based database
> using a script from Excite.
> The data has to be updated on the server, but in a format searchable
> by the script.
Ohhh, that makes sence for his descriptions so far.
> Why not ask you
> Hi,
> Ok, I guess I was confusing everyone. I thought this was a simple
> problem, we need a search engine to search through our data, I might be
> able to convert to csv, or I found another way...
>
> example...
>
[ snip ]
I think what Norm is trying to do (Norm correct me if I'm wrong) is
se
so one of your questions is, if i may paraphrase,
"what database manager should i use?"
i believe that you said that it has only eight
hundred records?
and it's only a single table?
you can manage it manually with little trouble?
and it's a low volume web site?
pardon my sacrilege, but if t
Hi Norm,
It sounds to me like we have some lack of clerity. Let me see if I can place some
useful definitions:
- CSV
A text format for representing data.
- CSV file
A file written in the CSV format.
- Database
A place to store data.
- Program
Software that does something.
- Database
Hi,
Ok, I guess I was confusing everyone. I thought this was a simple
problem, we need a search engine to search through our data, I might be
able to convert to csv, or I found another way...
example...
-NO-
SAR1100
-COMMENTS-
999 try6
-ORG_LEVEL_1-
SARNIA COMPUTER USERS' GROUP
-AL
there may be some willing to help, but having
trouble understanding.
i don't know about anybody else, but i've been
following this since his first posting, and my
simple mind is having trouble identifying his
problem. is it technical, organizational, or
sociological?
mysql
> From: Norm La
From: Norm Lamoureux <[EMAIL PROTECTED]>
> Sounds like I am confusing everyone...
> I only have one database with over 800 records
> The data on the website is the result of my database.
> I wish to search on words in each record.
Search with what? Do you mean the page at:
http://www.informs
Hi,
Sounds like I am confusing everyone...
I only have one database with over 800 records
The data on the website is the result of my database.
I wish to search on words in each record.
I might be able to export each record as a CSV file?
Clear as mud (I think)
Thanks again,
Norm
Rodney Bro
From: Norm Lamoureux <[EMAIL PROTECTED]>
> In the DOS database... each organization is seperate...
> ...exported all data as a text file
> ...individual web pages for each one.
"Individual web pages for each one", does this refer to items like:
http://www.informsarnialambton.org/listing/36.HTM
Hi,
In the DOS database (EDIBASE) I use at home, each organization is
seperate, I exported all data as a text file, then I had to create
individual web pages for each one. I have a list of each numbered web
page. I would like to have only one database, instead of changing
individual ones as needed.
From: Norm Lamoureux <[EMAIL PROTECTED]>
> ...700 individual web pages that EXCITE does a search for...
Are these web pages actual individual files, or are they simply information in a
database someplace that needs to get displayed?
> I don't know whether my server has these programs, I can
Hi,
It is 760 organizations listed, when I said two, I meant that on the WWW
I have over 700 individual web pages that EXCITE does a search for and
my main database in DOS. I don't know whether my server has these
programs, I can check.
Thanks
Norm
Rodney Broom wrote:
>
> Hi Norm,
>
> I gather
lizard,
Sunday, November 10, 2002, 9:32:33 AM, you wrote:
l> My name is Mike.
l> I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
l> I want to grant access to databases and tables to users,but only to a certin
l> databases and tables.
l> I red the how-to but both grant and revoke commands does no
Also, make sure you're running "FLUSH PRIVILEGES" after your grants and
revokes. (Did I spell that right?)
-Mike
> Hi all.
> My name is Mike.
> I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
> I want to grant access to databases and tables to users,but only to a certin
> databases and tabl
I don't know why but the message "Query OK. 0 rows affected (some time)"
after grant and revoke syntax shows that your commands have been
executed successfully. Take a look at grant and revoke syntax more
carefully.
lizard wrote:
Hi all.
My name is Mike.
I have a Linux RedHat 7.3 with Mysql v
Hi,
Mailing list: http://lists.mysql.com/
Joining three tables could be something like this.
Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER
JOIN t3 ON t2.id = t3.id
I highly recomend you to read some basic SQL books
before you carry on with your project. Trial and error
is not always th
Hi.
On Sat 2002-07-20 at 22:23:06 -0700, [EMAIL PROTECTED] wrote:
> And could not find where or if they have archives of the list for my to
> search though so I guess I will ask my question.
Some searchable archives can be found here:
http://www.mysql.com/documentation/searchlists.html
> I was
i've report this bug to php, they said it's not bug of php
but i've found the problem
* ALL is ok for SERVER, problem issue only by CLIENT(libmysql.a)
php-win-binary don't compile libmysql supporting GBK charset!
neight other multibyte charset.
also the one i compiled is linked with lib
Xuefer,
Monday, April 15, 2002, 8:55:08 AM, you wrote:
X> mysql-4.01
X> binary package
X> windows
X> also the same in linux source/binary package
X> when SHOW VARIABLES
X> got:
X> -
X> character_set gbk
X> character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
>Hi all...
>
>This is my first post to the list. I've been working on MySQL now for about a
>week and really like it. I have a question that I can't find in any of the
>books or how-tos.
>
>When I add a line to my customer's table I need it to put today's
See the manual reference to the 'timestamp' type.
-Original Message-
From: Jim Hatridge [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 5:50 PM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
Hi all...
This is my first post to the list. I've been working on MySQL no
Hi Jim,
Welcome to our relatively?relationally happy band.
> This is my first post to the list. I've been working on MySQL now for about a
> week and really like it. I have a question that I can't find in any of the
> books or how-tos.
A whole week and no post...
> When I add a line to my custo
Jim,=20
What you're asking about is the "timestamp" data type. =20
Look at : http://www.mysql.com/doc/D/A/DATETIME.html
In a nutshell, if you assign 'null' to a timestamp column it will put in
value of 'NOW()'.
Eric Mayers
Software Engineer
> -Original Message-
> From: Jim Hatridge [m
On Friday 08 February 2002 19:28, Eric Mayers wrote:
> Jim,
>
> What you're asking about is the "timestamp" data type.
>
> Look at : http://www.mysql.com/doc/D/A/DATETIME.html
>
> In a nutshell, if you assign 'null' to a timestamp column it will put in
> value of 'NOW()'.
>
> Eric Mayers
> Softwar
Hi Jim,
Welcome to our relatively?relationally happy band.
> This is my first post to the list. I've been working on MySQL now for about a
> week and really like it. I have a question that I can't find in any of the
> books or how-tos.
A whole week and no post...
> When I add a line to my custo
Jim,
What you're asking about is the "timestamp" data type.
Look at : http://www.mysql.com/doc/D/A/DATETIME.html
In a nutshell, if you assign 'null' to a timestamp column it will put in
value of 'NOW()'.
Eric Mayers
Software Engineer
> -Original Message-
> From: Jim Hatridge [mailt
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
>Hi all...
>
>This is my first post to the list. I've been working on MySQL now for about a
>week and really like it. I have a question that I can't find in any of the
>books or how-tos.
>
>When I add a line to my customer's table I need it to put today's
Date |Thu, 16 Aug 2001 13:40:16 +
>From |"Brian Johnson Jaber" <[EMAIL PROTECTED]>
Hello!
BJJ> Dear Sirs
BJJ> Hello, i have questions on mysql i create a table and i create an index key
BJJ> in it i want to know how can i know in mysql if the date that i import it
BJJ> into the table are f
whoops,
yip,
**blush**
-Original Message-
From: Jack Challen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:23 AM
To: [EMAIL PROTECTED]
Cc: Sean O'Donnell
Subject: Re: Hello please help me out
[EMAIL PROTECTED] wrote:
>
> try
>
> echo file.sql >
[EMAIL PROTECTED] wrote:
>
> try
>
> echo file.sql > mysql -u username -p password databasename
>
You mean:
^
cat file.sql | mysql -u username -p password databasename
^
Or, better:
mysql -u username -p password databasename < file.sql
--
Jack Chall
[EMAIL PROTECTED] wrote:
>
> try
>
> echo file.sql > mysql -u username -p password databasename
>
> or on dos
>
> type file.sql > mysql -u username -p password databasename
>
> That should execute the scripts on the db in question,
>
> or you can download a a tool like mysqlgui/mysqlfront an
try
echo file.sql > mysql -u username -p password databasename
or on dos
type file.sql > mysql -u username -p password databasename
That should execute the scripts on the db in question,
or you can download a a tool like mysqlgui/mysqlfront and
use it to load and run the queries.
Sean
-O
At 9:19 AM +0530 6/28/01, Divakar wrote:
>Hi list
>
> I am a beginner in the field of mysql
>I would like to know whether it is possible to run sql scripts(a .sql file)
>in mysql.
>if yes please some body tell me how do we do that,.
The MySQL Reference Manual is your friend:
http://www.mysql.c
> > First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
> > echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
> > ./configure,the prompt is configure not found.I don't know what is the
> > reason.I think maybe the tar of Solaris is not work in good
The information contained in this email is privileged
and confidential and intended for the addressee only. If you are not the
intended recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error you are asked
to destro
I believe it states on the download page (or maybe it is on the mysql
download page, in any case, I have seen it a lot) that gzip is broken on
solaris and you MUST use gunzip? Just a guess. Don't know for sure. No
solaris to play with :|
On 4/4/01 8:33 PM, "php_mysql" <[EMAIL PROTECTED]> wrote
43 matches
Mail list logo
