[RESOLVED] Couple of Questions..

Dang

I am very new to MySQL and am studying from a book and all is going great but I do have a couple of questons.

1.) I am entering data into the command line of the mysql client (?) (DOS promt) and while entering a record if there is an error in syntax I don't find out until I am completely done with the record and enter the last ");". Which means I have to go back and retype EVERYTHING, now I know I can use my up/down arrows to scroll through previousely entered lines, but I still have to start from the beginning. Is there a way to make the correction on the offending "line" and then re-run the command?

2.) Is there a way to import records from Excel into a MySQL database (I have seen the export feature)? In this case I may just not have read far enough, but I am just curious and can't find the answer in the book at this point.

It is so amazing the stuff you can do with PHP/MySQL, I am really enjoying learning thiese applications and love that there is a place like this to push you in the right direction when things get a bit foggy.

Thank you

redrage

1.> On mine i can use updown left and right so if i forgot a " in the middle of the light i just go up to that command, and use the left arrow over to where i want the ", put it in and hit enter.

2.> Yes but off the top of my head i duno. Pretty sure you save out of excell in CSV then run another utility on that file.

Dang wrote:
I am very new to MySQL and am studying from a book and all is going great but I do have a couple of questons.

1.) I am entering data into the command line of the mysql client (?) (DOS promt) and while entering a record if there is an error in syntax I don't find out until I am completely done with the record and enter the last ");". Which means I have to go back and retype EVERYTHING, now I know I can use my up/down arrows to scroll through previousely entered lines, but I still have to start from the beginning. Is there a way to make the correction on the offending "line" and then re-run the command?

2.) Is there a way to import records from Excel into a MySQL database (I have seen the export feature)? In this case I may just not have read far enough, but I am just curious and can't find the answer in the book at this point.

It is so amazing the stuff you can do with PHP/MySQL, I am really enjoying learning thiese applications and love that there is a place like this to push you in the right direction when things get a bit foggy.

Thank you

Dang

Thank you for the reply...

1.) In your example when I omit the " and then finish that line (by hitting enter) to move on to the next line I am unable to get back to the offending line to make a quick change, I am having to REBUILD my statement using the Up/down arrows which schrolls through my lines one by one and as I find the line I need I hit enter and keep repeating these steps until I have rebuilt the entire statement. Of course as I am scrolling through these lines I use the left/right arrow to fix the missing " when I run accross that line.

Does this make sense?
Or am I missing something?

Thank you so much!

shauny17

Try using 3rd party software such as Navicat or Mysql Query Browser?

Dang

Before I start looking for other solutions as I am learning, I want to make sure I have mastered my current environment.
I am sure that I am just missing something or is this the way it is supposed to work?

ahundiak

Dang wrote:
Before I start looking for other solutions as I am learning, I want to make sure I have mastered my current environment.
I am sure that I am just missing something or is this the way it is supposed to work?

The basic mysql interface is fairly primitive as far as the user interface goes. So yes, that is the way it works. A simple work around is to write your queries using vi or notepad and then just copy/paste them in.

Dang

That's what I wanted to know.

Thanks for the hot tip!