Category Archives: MySql

Import A Database Dump MySql Terminal

Import A database Dump Terminal MySql

To import a database dump use this command. mysql -u [username] -p -h localhost [database] < db_backup.sql Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Read More

Delete Records MySql Terminal Command

Delete Records MySql Terminal Command

To delete records in mysql use this terminal command. DELETE FROM [table] WHERE [column] = [value]; Delete all records without dropping the table. This will also reset the increment number value. DELETE FROM [table]; Delete all records in a table. truncate table [table]; Remove table columns. ALTER TABLE [table] DROP COLUMN [column]; Deleting tables. DROP TABLE Read More

Select Records Containing Terminal MySql

Select Records Containing Terminal MySql

To find records containing something use this command. SELECT * FROM [table] WHERE [column] LIKE ‘%[value]%’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 Read More

Selecting Specific Records MySql Terminal Command

Selecting Specific Records MySql Terminal Command

To select specific records in terminal use this code. SELECT * FROM [table] WHERE [column] = [value]; You can also use these selectors. Less Than < Greater Than > Not Equal To != And and Or or Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If Read More

Counting and Selecting Group Records MySql Terminal Commands

To count and select group records in terminal use this command. SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the Read More

Counting Records MySql Terminal Command

Counting Records MySql Terminal Command

To count records enter this command. Take out square brackets and replace names accordingly. SELECT COUNT([column]) FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips Read More

Selecting Parts Of Records MySql Terminal Command

Selecting Parts Of Records MySql Terminal Command

To select parts of records use this command. SELECT [column], [another-column] FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD $10 Read More

Explain Records MySql Terminal Command

Explain Records MySql Terminal Command

To explain records use this command. Take out brackets and replace table with your table name. EXPLAIN SELECT * FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip Read More

Selecting Records Terminal MySql

Selecting Records Terminal MySql

To select record in terminal for mysql use this command. Change the value of table and take out the brackets. SELECT * FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the Read More

MySql Function for Date Time Input Terminal Commands

MySql Function For Date Time Input Terminal Commands

For date time input use this function. NOW() Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD $10 Tip $10.00 USD $20 Tip Read More

Add A Column MySql Terminal Command

Add A Column MySql Terminal Command

To add a column in terminal just enter this command. Change the values for customization. ALTER TABLE [table] ADD COLUMN [column] VARCHAR(120); To Add A column with a unique auto increment id use this. ALTER TABLE [table] ADD COLUMN [column] int NOT NULL AUTO_INCREMENT PRIMARY KEY; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Read More

Insert A Record MySql Terminal Command

Insert A Record MySql Terminal Command

To insert a record use this command in terminal. Customize the values. INSERT INTO [table] ([column], [column]) VALUES (‘[value]’, [value]’); Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip Read More

Create A New Table With Column MySql Terminal Command

Create A New Table With Column MySql Terminal Command

To create a new table with columns use this command. CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME); Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Read More

List All Indexes On A Table MySql Terminal

List All Indexes On A Table MySql Terminal

To see all indexes on a table enter this code. show index from [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD Read More

Show Table Structure MySql Terminal Commands

Show Table Structure MySql Terminal Commands

To show the table structure in terminal use this code. describe [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Lets be friends on YouTube Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD $10 Tip Read More