Fork, Commit, Merge - Easy Issue (SQL)
nikohoffren opened this issue · 0 comments
Fork, Commit, Merge - Easy Issue (SQL)
Write a SQL script to Create a users Table
Note: You don't have ask permission to start solving the issue or get assigned, since these issues are supposed to be always open for new contributors. The actions-user bot will reset the file back to previous state for the next contributor after your commit is merged. So you can just simply start working with the issue right away!
Description:
The goal of this task is to write a SQL script that creates a simple table. The script should create a table named users with the following columns:
- id (integer)
- name (text)
- email (text)
Here are the steps to do that:
- Open the
tasks/sql/easy
directory from the root of your project. - Open the
create_users.sql
file and add all the requested fields. - In the terminal (or the integrated terminal in VS Code), navigate to the directory where the
create_users.sql
file is located with commandcd tasks/sql/easy
. - Type
sqlite3 mydatabase.db
to create and connect your SQLite database. - Type
.read create_users.sql
to run the script and create the users table. - Now, to see the structure of the users table, type
PRAGMA table_info(users);
If the table was created successfully, the output should look like something like this:
0|id|INTEGER|0||1
1|name|TEXT|0||0
2|email|TEXT|0||0
If the output looks correct, you are done and ready to make a pull request!
Check out README.md for more instructions and how to make a pull request.
Feel free to ask any questions here if you have some problems!