mysql

Update Records In MySql Terminal

Update Records In MySql Terminal

To update a record you can use this command. UPDATE [table] SET [column] = ‘[updated-value]’ WHERE [column] = [value]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Select With Custom Order Limit Terminal MySql

Select With Custom Order Limit Terminal MySql

To select with a customer order and limit the results use this command. SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value]; You can order by ascending. ASC Or you can order by descending. DESC Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Select A Range MySql Terminal

Select A Range MySql Terminal

To select a range use this code. Take out the brackets and replace the values. SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Select Records Starting & Ending With Value MySql Terminal

Select Records Starting & Ending With Value MySql Terminal

To find records that start and end with a certain value use this command. SELECT * FROM [table] WHERE [column] LIKE ‘[val_ue]’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Select Records Starting With A Value MySql Terminal

Select Records Starting With A Value MySql Terminal

To find something that starts with a certain string use this code. SELECT * FROM [table] WHERE [column] LIKE ‘[value]%’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

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 If that does not work for you then you may have created a user in cPanel or some other website management application. You may have to use the –no-tablespaces tag. The syntax looks like this mysqldump –no-tablespaces -h localhost Read More

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

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

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

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

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

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

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

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