In fulfilling my passion for making computer systems work better, I have had many roles: If I’m not currently committed to solving a technology problem for someone, I’ll be happy to help solve yours. My specialties include: operations or software team development & management, software & web app development (Ruby/Rails, Python, Perl, Javascript, DHTML/CSS, Nginx/Apache, MySQL) web operations application and system integration embedded systems development and integration mobile telecommunications standards development (3GPP, 3GPP2, OMA, IETF). I value my team members and colleagues as customers to my service, and celebrate all successes as a team. I stay current with emerging technologies and software development tools & techniques so as to maintain my value as a contributor and trusted advisor. I have a lot of experience in making technology fulfill business goals in a variety of environments and contexts, but especially highly scalable, multi-tier system architectures. I’ve manifested this passion in many ways: creating or modifying software that helps people, whether as end-users or as software developers building products that helps users well enough to earn revenue growing and managing teams of people to create manageable, useful, technology-based solutions. My passion has always been about making technology work harder and better so people don’t have to. RIGHT JOIN SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition 4.Welcome to the web home of Alan K. 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 ![]() 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. 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. 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. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |