Executing Create Table/ INSERT INTO
#1

I'd like to make to different .sql files with each functions in it.

How can I do so?
Reply
#2

You want to make .SQL files containing sql data? If that is the case it's really easy. (Considering you've made all of your tables via phpmyadmin or something.)

For phpmyadmin:

1. Click the database/table you'd like to use.
2. Hit the EXPORT tab.
3. Make sure the format is "SQL".
4. Hit go.
5. A .SQL file should have downloaded to your computer containing the data you wanted to make the SQL file from )

Thats the easiest option imo.
Reply
#3

Quote:
Originally Posted by Mitchy
View Post
You want to make .SQL files containing sql data? If that is the case it's really easy. (Considering you've made all of your tables via phpmyadmin or something.)

For phpmyadmin:

1. Click the database/table you'd like to use.
2. Hit the EXPORT tab.
3. Make sure the format is "SQL".
4. Hit go.
5. A .SQL file should have downloaded to your computer containing the data you wanted to make the SQL file from )

Thats the easiest option imo.
There are errors on my sql file so I'd need to seperate my INSERT INTO/ Create table and upload them to my localhost in a two different .sql file.

Doing research etc.

I figured out something I can do but I do not know how to perform this action
putting it in a file and pipe it in to stdin.
If someone could explain me how I'd appreciate.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)