SQL

In my previous post, I introduced how to import data into SQL. That process was done manually to import data into a local SQL server. I use MySQL. A local SQL server means you can only access the data from your own computer. If you use another computer elsewhere, you won’t be able to access … Read more

In my previous post, I introduced how to combine multiple files into one using Access, and now I’ll explain how to do the same using MySQL. The SQL code is similar in both programs, so the code will be the same. First, I uploaded three different datasets to MySQL, and I want to combine them … Read more

In my SQL, sometimes we need to calculate average or something else for filtered data. It woud be much easiler if we create temporary tables when calculating filtered data. here is an example. First, let’s create a database Second, I’ll create a data table. Let’s see the data table was well created. Now, I want … Read more

□ Creating an Azure SQL Database: A step-by-step guide In my previous post, I introduced how to set up Azure SQL Database. Today, let’s practice some SQL coding! 1) to create data table I just created two data tables YieldData, and BiomassData. 2) to summarize data I will summarize the data tables by calculating the … Read more

When you use SQL, it’s about managing your data in the database. However, you might also expect that you can access your database from wherever you are. If you use SQL programs, you would primarily achieve the former, but it’s less relevant to the latter. SQL is a powerful language for managing data in a … Read more

Let’s practice Azure SQL codes. The data you can practice can be downloaded below. https://github.com/agronomy4future/raw_data_practice/blob/main/micronutrients.csv If you download the data, first you can upload data to Azure SQL server. The method to upload data to Azure SQL server is explained in the below post. 1) Create database First, let’s create Database to upload external data … Read more

I have created a data table. If you copy and paste the code below into your MySQL window, you can obtain the same data table. □ Select all data column □ Select specific data column □ Select specific data column within specific variable

□ Creating Data Tables in MySQL: A Step-by-Step Guide If you followed my previous post, you can manually create a Data Table. If you copy and paste the code below into your MySQL window and then run it with Ctrl+Shift+Enter, you will see the below data table. ■ How to calculate new values? Now, I’d … Read more

□ A Step-by-Step Guide to Importing Excel Data into MySQL If you followed my previous post, you can easily create a Data Table when importing external data. In this post, I will introduce how to create a Data Table manually. First, let’s create a database named ‘test_data.’ Within this database, I’ll create a Data Table. … Read more

[Step 1] Database Setup for Importing Excel Data into MySQL The first step is to create a database for importing external data. The code for this step is as follows: After creating a database, refresh the page to display the newly created database. [Step 2] Setting Up the Table Data In the database you created, … Read more

This is the process to install MySQL Workbench on your PC. First, please go to the link and download the latest version of MySQL. https://dev.mysql.com/downloads/workbench/ The next page will ask you to log in to your Oracle web account or sign up, or you can choose to skip this step and start the download. The … Read more

□ Exploring Data Management in ACCESS: Uploading Data to the Database In the previous post, I introduced how to upload Excel files to ACCESS. Now, let’s explore how to upload multiple Excel files to ACCESS and merge them into one dataset. Let’s say you have uploaded 5 Excel files to ACCESS, as shown in the … Read more