describe [table]; <\/pre>\nShow table structure.<\/p>\n
show index from [table]; <\/pre>\nList all indexes on a table. <\/p>\n
CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME); <\/pre>\nThis will create new table(assign name) with columns and create with date and time. <\/p>\n
ALTER TABLE [table] ADD COLUMN [column] VARCHAR(120);<\/pre>\nThis will add an another column in the existing table.<\/p>\n
ALTER TABLE [table] ADD COLUMN [column] int NOT NULL AUTO_INCREMENT PRIMARY KEY; <\/pre>\nIt is used for Adding a column with an unique, auto-incrementing ID.<\/p>\n
INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]'); <\/pre>\nIt will insert a new record into the table.<\/p>\n
NOW()<\/p>\n
MySQL function for date time input. <\/p>\n
SELECT * FROM [table];<\/pre>\n This command is used to Selecting records in the table. <\/p>\n
EXPLAIN SELECT * FROM [table]; <\/pre>\nThis command will Explain records which is present in the selected table. <\/p>\n
SELECT [column], [another-column] FROM [table]; <\/pre>\nIt is used for Selecting parts of records which is present in the table.. <\/p>\n
SELECT COUNT([column]) FROM [table]; <\/pre>\nThis command is used for Counting records in the table.<\/p>\n
SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column]; <\/pre>\nThis command is used for Counting and selecting grouped records. <\/p>\n
SELECT * FROM [table] WHERE [column] LIKE '%[value]%'; <\/pre>\nThis command is used to Select records containing [value] .<\/p>\n
SELECT * FROM [table] WHERE [column] LIKE '[value]%'; <\/pre>\nIt is used to Select records starting with [value].<\/p>\n
SELECT * FROM [table] WHERE [column] LIKE '[val_ue]';<\/p>\n
Select records starting with val and ending with ue. <\/p>\n
SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2]; <\/pre>\nThis is used to Select a range in the table. <\/p>\n
UPDATE [table] SET [column] = '[updated-value]' WHERE [column] = [value];<\/pre>\nThis commands is used for Updating records.<\/p>\n
DELETE FROM [table] WHERE [column] = [value];<\/pre>\nThis command is used for Deleting records.<\/p>\n
DELETE FROM [table];<\/pre>\n(This also resets the incrementing counter for auto generated columns like an id column.)<\/p>\n
Delete all records from a table (without dropping the table itself)<\/p>\n
truncate table [table];<\/pre>\nThis command will Delete all records in a table<\/p>\n
ALTER TABLE [table] DROP COLUMN [column];<\/pre>\nRemoving table columns.<\/p>\n
DROP TABLE [table];<\/pre>\nDeleting tables.<\/p>\n
DROP DATABASE [database];<\/pre>\nDeleting databases<\/p>\n
SELECT [column] AS [custom-column] FROM [table];<\/pre>\nCustom column output names.<\/p>\n
mysqldump -u [username] -p [database] > db_backup.sql<\/pre>\nExport a database dump (more info here).<\/p>\n
mysql -u [username] -p -h localhost [database] < db_backup.sql<\/pre>\nImport a database dump (more info here)<\/p>\n
exit;<\/pre>\nThis command is used to Logout or quit from the mysql.<\/p>\n","protected":false},"excerpt":{"rendered":"
The following are the list of commands used in mysql to create an data base and manage it for Linux web server. Start by logging-in using a SSH client, like PUTTY, to access the shell command line. Before entering this command make sure your will be in mysql > And […]<\/p>\n","protected":false},"author":1,"featured_media":482,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-372","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/07\/securely-administer-mysql-with-an-ssh-tunnel.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa2YU7-60","_links":{"self":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=372"}],"version-history":[{"count":0,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media\/482"}],"wp:attachment":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}