bobbyiliev / introduction-to-sql Goto Github PK

Can you assign this to me?

Is your feature request related to a problem? Please describe.

want to add about truncate table in table chapter

Describe the solution you'd like

The TRUNCATE TABLE command deletes the data inside a table, but not the table itself.

Additional context

contributing to hacktoberfest 2021

Hi ,
There is a scope of improvement along with few issues in the readme.md file.
i would like to contribute to its betterment so please can you assign this issue to me

Hi ,

There is a scope of improvement in the order-and-group-by.md file.
More use cases can be added along with examples.

I would like to contribute for the same.
Kindly assign this issue to me.

Note :- I have added some examples and use cases and raised a PR for the same.
PR Link :- Introduced HAVING Clause to filter out the groups created by GROUP BY Clause

Data Control Language Commands

• Grant

• Revoke

Kindly assign this to me.

https://sql.bobby.sh/

Is your feature request related to a problem? Please describe.

Between Operator not present in where.md

Describe the solution you'd like

I would add that with example

Additional context

I would like to add this as part of Hactoberfest 2021

Transaction Control Language commands

• Commit

• Rollback

• Savepoint

Please assign this to me.

Hi ,

There is a scope of improvement in the insert.md file.
More use cases can be added along with examples.

I would like to contribute for the same.
Kindly assign this issue to me.

Is your feature request related to a problem? Please describe.

Links to chapters are not added.

Describe the solution you'd like

Adding links to chapters in README.md

Additional context

please consider this for Hacktoberfest 2021.

Hi ,

There is a scope of improvement in the select.md file.
More use cases can be added along with examples.

I would like to contribute for the same.
Kindly assign this issue to me.

Note :- I have added some examples and use cases and raised a PR for the same.

Is your feature request related to a problem? Please describe.

The section 005-select.md would deserve a mention of basic pattern matching using LIKE and ILIKE operators.

Describe the solution you'd like

Add another section called "Pattern matching" to 005-select.md explaining how to use LIKE and ILIKE.

Additional context

Is your feature request related to a problem? Please describe.

Create table Chapter don't include point of How to create a new table from existing table

Describe the solution you'd like

I would like to add the point with an example.
Syntax of it
CREATE TABLE new_table AS (SELECT * FROM old_table);

Additional context

Want to contribute as part of Hacktoberfest 2021

Hi ,

There is a scope of improvement in the join.md file.
Different types of Inner Join can be added with use cases.

I would like to contribute for the same.
Kindly assign this issue to me.

Note :- I have added some examples and use cases and raised a PR for the same.
PR Link :- Added Information about different types of INNER join with use cases

File Location/Types in Contributing.md doesn't match the current project structure will update that.

To Reproduce

1.Visit : This
There are no translations of the book present in the repo now will change it as per the current structure.

Expected behavior

Current structure explanation

Screenshots

Additional context

I Will work on it as part of Hacktoberfest 2021

Is your feature request related to a problem? Please describe.

creating-tables Chapter does not describe how to rename a table

Describe the solution you'd like

Add rename table point along with example

Additional context

Contributing as part of Hactoberest 2021