SA-MP Forums Archive
Executing Create Table/ INSERT INTO - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Executing Create Table/ INSERT INTO (/showthread.php?tid=478691)


Executing Create Table/ INSERT INTO - DavidLuango - 30.11.2013

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

How can I do so?

Re: Executing Create Table/ INSERT INTO - Mitchy - 30.11.2013

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.

Re: Executing Create Table/ INSERT INTO - DavidLuango - 30.11.2013

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.