To view this content, you must be a member of Terresquall's Patreon at $10 or more
Unlock with PatreonAlready a qualifying Patreon member? Refresh to access this content.
All posts tagged under:
tutorials
Importing a CSV file into an SQL table
CSV stands for Comma-Separated Values, and CSV files are text files that look something like this:
example.csv
Username,Email,Address,Contact johndoe,john@example.com,"71 Pickering Street, Singapore, Singapore",+65-91234567 janedoe,jane@website.com,"24 Raffles Lane, Singapore, Singapore",+65-81234567 marysmith,mary@smith.com,"83 Riveting Road, Singapore, Singapore",+65-97654321 bobsmith,bob@smith.com,"84 Riveting Road, Singapore, Singapore",+65-87654321
Essentially, the CSV file format is meant to represent tabular data. The above CSV file represents the following table:
| Username | Address | Contact | |
|---|---|---|---|
| johndoe | john@example.com | 71 Pickering Street, Singapore, Singapore | +65-91234567 |
| janedoe | jane@website.com | 24 Raffles Lane, Singapore, Singapore | +65-81234567 |
| marysmith | mary@smith.com | 83 Riveting Road, Singapore, Singapore | +65-97654321 |
| bobsmith | bob@smith.com | 84 Riveting Road, Singapore, Singapore | +65-87654321 |
Due to their tabular nature, data in a CSV file can very easily be imported into and stored in an SQL table. The commands to do that, however, are not very well-documented online.
If a CSV file does not open as a text file on your computer, that’s because your computer is opening the file with a spreadsheet program such as Microsoft Excel. In such a case, to see the file as text, you will want to open these files on a text editing software such as Notepad.
Continue reading
Creating a Farming RPG (like Harvest Moon) in Unity — Part 7: Growing and Harvesting Crops
Creating a Farming RPG (like Harvest Moon) in Unity — Part 6: Managing In-Game Time
Creating a Farming RPG (like Harvest Moon) in Unity — Part 5: Equipping Items
Ever wanted to create a game like Harvest Moon in Unity? Check out Part 5 of our guide here, where we go through how to equip and unequip items. You can also find Part 4 of our guide here, where we went through how to create an item management system.
Continue reading
Creating a Farming RPG (like Harvest Moon) in Unity — Part 4: Item Management
Ever wanted to create a game like Harvest Moon in Unity? Check out Part 4 of our guide here, where we go through how to create an item management system. You can also find Part 3 of our guide here, where we went through how to set up farmland elements that our player character will interact with.
Continue reading
Creating a Farming RPG (like Harvest Moon) in Unity — Part 3: Farmland Interaction
Correction: In the video, we made a reference to the PlayerController component in the PlayerInteraction class. However, we later found that we didn’t make use of it at least in this part, so you can choose to skip that bit in the video for now, as it is redundant. They are highlighted in red in the finalised codes below.
Ever wanted to create a game like Harvest Moon in Unity? This is Part 3 of our guide, where we go through how to set up farmland elements that our player character will interact with. You can also find Part 2 of our guide here, where we went through how to set up our player camera.
Continue reading
Creating a Farming RPG (like Harvest Moon) in Unity — Part 2: Basic Camera
Ever wanted to create a game like Harvest Moon in Unity? Check out Part 2 of our guide here, where we go through how to create a camera that follows our player character around. You can also find Part 1 of our guide here, where we went through how to set up our player character.
Continue reading
Creating a Farming RPG (like Harvest Moon) in Unity — Part 1: Movement
Ever wanted to create a game like Harvest Moon in Unity? Check out Part 1 of our guide here, where we go through how to create animations and movement for the player character.
Continue reading