![]() RIGHT JOIN SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition 4. LEFT JOIN SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON condition 3. INNER JOIN SELECT * FROM TABLE1 INNER JOIN TABLE2 where condition 2. How to delete stored procedure DROP PROCEDURE sp_name Joins 1. How to call Stored procedure CALL sp_name 3. Create a Stored Procedure CREATE PROCEDURE sp_name(p1 datatype)ĮND 2. Drop a Trigger DROP TRIGGER trigger_name Stored Procedures 1. Create a Trigger CREATE TRIGGER trigger_name trigger_time trigger_event SET query : CONCAT('UPDATE ',tblJustSayThanks,' because you seem to be concatenating your SQL text with the value of tblJustSayThanks, but I think you mean to use the identifier itself. Deleting a View DROP VIEW View_name Triggers 1. How to call view SELECT * FROM View_name 3. DROP INDEX DROP INDEX index_name ON table_name Views 1. For MySql WorkBench, Please use below : update emp as a inner join department b on a.departmentidb.id set a.departmentnameb.name where a. CREATE INDEX CREATE INDEX index_name on table_name(column_name) ĬREATE UNIQUE INDEX index_name on table_name(column_name) 2. DELETE DELETE FROM table_name where condition Example DELETE from EMPLOYEE where empId='0001' Indexes 1. Go to Edit -> Preferences Click SQL Editor tab and uncheck Safe Updates check box Query -> Reconnect to Server // logout and then login Now execute. ![]() WHERE condition Example UPDATE EMPLOYEE SET dept = 'Sales' WHERE empId='0001' 4. Example SELECT * FROM EMPLOYEE where dept ='sales' 3. Example INSERT INTO EMPLOYEE VALUES (0001, 'Ava', 'Sales') 2. INSERT INSERT INTO table_name (column1, column2, column3. Prior to MySQL 8.0. COMMENT Single-Line Comments: -Line1 Multi-Line comments: /* Line1, RENAME RENAME TABLE table_name1 to new_table_name1 6. ALTER ALTER TABLE Table_name ADD column_name datatype Example INSERT INTO EMPLOYEE VALUES (0001, 'Dave', 'Sales') 3. After unchecking 'Safe Updates' follow the step below: Query -> Reconnect to Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |