![]() (You find the port number in MAMP -> Preferences -> Ports but the standard port is 8889 so you can try my settings first. Talking about 4) This is the connection data that you have to enter into Sequel Pro to connect. If something fails, just google the error – there is loads of help on those topics. ![]() MySQL Tutorial – Install the Software to connect to a databaseĤ) Connect to the server using Sequel Proġ) and 2) and even 3) are pretty straightforward, you should be able to do that without any help. So I use MAMP to set up a locally running webserver which comes with a MySQL server. The only real database that I could connect to would be my running wordpress installation and its backend database – but I don’t want to mess with the live date. I chose Sequel Pro to do my selects but you could go with any other software out there. Normally we’d connect to a web-server with some databases with a local software. My approach is to recreate a real case as close as possible. Web ServicesĪlthough there are some web services like where you can try some selects but the performance is really slow and getting a big dataset in there is not very practical. You’ll do thousands of iterations of selects and it’s fine that most of them fail as your software will tell you where you failed and you can improve on that. In my opinion the most important step of learning how to work with MySQL is the test-environment and some test-date. Start with the most important part: The Test-Environment You’ll still export the result of your query (more on that later) to your data analysis software later but with mysql you can join data from multiple tables beforehand which saves you a ton of time and hundreds of VLOOKUPS or INDEX-MATCHES in your excel files. You don’t have to copy a snapshot of the data – you’ll work right there live on your database. ![]() One of the biggest reasons is, that you can work with live data. The alternative would be to grab the data (which is really just table data like you’d find in excel) and copy it to excel and do your analysis there. If you don’t want to be dependent on an IT-guy for every bit of data-analysis of your application – you start teaching yourself MySQL. Most marketers use their knowledge of MySQL to do some kind of data-analysis. It is very likely that the company that you work for or started yourself uses MySQL for some use case. MySQL short for Structured Query Language is an open-source relational database management system ( see Wikipedia) and is used in millions of companies as the main database.Īpplications / Companies that use the MySQL database include: WordPress, Drupal, Facebook, Twitter, Flickr, and YouTube. In this MySQL tutorial we’ll look into creating databases, creating tables and some query examples.
0 Comments
Leave a Reply. |