Database/Scripting:
- What is a SQL Database?
Okay, I get asked this a lot more than I care to admit to, but a SQL Database is a systematic collection of data which support storage and manipulation of data. To put it in layman's terms, if we think of a website like a human body, the HTML would be your skin, PHP would be your muscles/nerves, and the Database would be your brain.
- How to I repair or optimize my database?
Take a look at this image:
- How do I import run a SQL file?
There are a couple of ways to do this.
1.) Open up your phpmyadmin and go to your database and select import. Click "Choose File" and select the SQL file that you want to import, then click "Go".
2.) (This is my preferred way) Open up your phpmyadmin and go to your database and select SQL. Open up the SQL file and either highlight all or hit Ctrl + A, then right click and copy, Or hit Ctrl + C. Go back to the database and paste that into the box "Run SQL query/queries on database XXX", XXX being the name of your database. Then click Go and that's it.
- What is a good way for me to learn more about coding and SQL.
Easy, there are a ton of tutorials on YouTube, but also there is this:
That is a link to there SQL and all about them, they even have a test at the end of the lesson to see if you retained anything.
As for the coding, well, you can use W3Schools if you want, but you can also use which is more interactive and test you a lot more. There, they actually go over many types of coding from HTML, CSS, PHP, Javascript, jQuery, and more... , There is a lot there to learn from, and if you are serious about learning, then this is good start.
Last edited by coRpSE on Sat Mar 03, 2018 9:48 am; edited 4 times in total
#2: Re: Basic FAQ about Evo / FTP / Editors / Databases Author: MAGNET,
Posted: Fri Mar 02, 2018 3:56 am
—
Copy!
I look forward to seeing FAQ regarding databases. I visit this section of my Cpanel frequently and whatever content you add would be greatly appreciated.
I'm learning more and more each day and visiting your website has taught me alot.
Thanks so much for the time you and Lone put in on this CMS, TopDog!
#3: Re: Basic FAQ about Evo / FTP / Editors / Databases Author: [HSX]coRpSE, Location: Back of your mind!!!
Posted: Fri Mar 02, 2018 10:19 pm
—
n/p Magnet
Updated with more info. Will be adding more over time, I am just trying to remember the questions I get asked a lot.
HeadShot Extreme
-> PC & Codeing Talk
output generated using printer-friendly topic mod. All times are GMT - 7 Hours
Page 1 of 1