Fork, Commit, Merge - Easy Issue (SQL)

[nikohoffren]

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 command cd 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!

---

For this issue, you need to have sqlite installed to your local machine.
Check out README.md for more instructions of how to install sqlite and how to make a pull request.

Feel free to ask any questions here if you have some problems!

Also, kindly give this project a star to enhance its visibility for new developers!

[viprajtelukoti]

Hello @nikohoffren, I would like to work on this.