How do I upload a file to MySQL database and view that file

[newlearner2005]

Hello all,

I do not know how to upload a file to MySQL database and view the posting file on the webpage.
I followed the code on-line that show me how to upload, but when I click "browse" to open my file in local drive and click "upload". Nothing happen ! How can I view it on the web page to make sure it was saved in data base.
Could anybody help me ? I appreciate.
Thank you very much.
new learner.

 

[Bastien]

first you need to create the table in the db with the columns in the same order as in the file that you have (csv format is best (or tab delimited))

There are two setting that can affect the mysql loads data, at the bottom of the load file page there are two radio buttons for data and data local. Choose one and if it doesn't work, then choose the other radio button and try again...if the load is successful, you should be able to browse to the table by clicking the table name in the left hand col

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[newlearner2005]

Hello everybody,

Could you help me about this?

I know how to see MySQL databases by typing comannd
mysql> show databases;
And how to create table in the database ( example "mydatabase" is the name of database, and "mytable" is the name of the table)
mysql> use mydatabase;
mysql> create table mytable;
And I know how to see that table
mysql> describe mytable;

My question is:
By typing what command in DOS prompt, How to see the content of data I just insert to the table so that I can view, edit...
Thank you very much
new learner

 

[lgarner]

'mysql -e "select * from tablename" database' should work. Same as entering the query at the MySQL prompt.

 

[Bastien]

get yourself a nice gui interface...mysql has them, phpmyadmin is another...they will make you life much easier

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[newlearner2005]

Hello Bastien,

Thank you very much for your help. But it did not work that way !
I typed (in DOS prompt)
mysql> show databases;
It show "mydatabase".
Now I want to see what content of each database. I do not know how ? Even I knew "mytables" in " mydatabase", I typed
as you said, the dash lines run thru all the screen for a while and stop.
Thank you very much for your help.
new learner

 

[Bastien]

you need to download/install them

http://dev.mysql.com/downloads/query-browser/1.1.html

http://dev.mysql.com/downloads/query-browser/1.1.html

http://www.phpmyadmin.net

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[lgarner]

You can execute SQL commands at the mysql> prompt; it's not a full-screen interface. I'd suggest another product if you want to browse records. There's one or two on mysql.com, or you can use Access or other ODBC client.

What do you want to do? List tables? try "show tables". See the records in mytables? "select * from mytable". Don't like the dashes? "select * from mytable\G". There are a lot of things that you can do, but the command line isn't good for browsing data spreadsheet-style. Visit mysql.com to see what it can do.

 

[burnside]

use sqlyog - the latest version is fantastic

save your fingers and it free...

http://www.sqlyog.com