Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools

Posted by Stanimir Dimitrov
Stanimir Dimitrov
5,555 Points

How is the SQL file created ?

In this tutorial we do use a ready made sql file with some instruction ,how to be uploaded to our Local PhpMyAdmin Database. What I would like to know is how such file is created ? Do we use a program ?

1 Answer

Tim Danner
Tim Danner
3,284 Points
Tim Danner
Tim Danner
3,284 Points

As far as I know, you can create a SQL file on any text editor, where you fill in the SQL syntax that gets executed whether in a command line prompt or in a workplace/software that the SQL server has to provide.

Usually the files are created by the SQL itself in situations when the data needs to be exported for backup or other uses.

I believe there's people who are more experienced in this field who could give you better explanations, hope this helps.

Stanimir Dimitrov
Stanimir Dimitrov
5,555 Points

Yes it does helps! Much appreciated !