Category Archives: MySql

Export A database Dump Terminal MySql

Export A database Dump Terminal MySql

To export a database use this command in terminal. mysqldump -u [username] -p [database] > db_backup.sql Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the Read More

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the Read More

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. Read More

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share:

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 Please like, share and subscribe. 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

Cool People Share: