DATABASE
Run MySQL on Command Line in Windows
Sometimes if we want to run MySQL but we don't have phpMyAdmin installed. What should we do?On Windows we can run MySQL in following steps:Open Console Window->Type "mysqld -u root". This means we start the mysql server with username root. This program will handle all the communications between our console window and the actual data;After starting the server, we need to use a client to connect to the server and communicate with it. the mysql program is right for this. Next in the command console, we type "mysql -u root -p" to connect the server. By default, after the installation,the defaul...
8,255 0 WINDOWS MYSQL COMMAND LINE CONSOLE DEFAU
Database Testing – Practical Tips and Insight on How to Test Database
Database is one of the inevitable parts of a software application these days. It does not matter at all whether it is web or desktop, client server or peer to peer, enterprise or individual business, database is working at backend. Similarly, whether it is healthcare of finance, leasing or retail, mailing application or controlling spaceship, behind the scene a database is always in action.Moreover, as the complexity of application increases the need of stronger and secure database emerges. In the same way, for the applications with high frequency of transactions (e.g. banking or finance appli...
SQL Grammar Summary
æ•´ç†äº†ä¸€ä¸‹ï¼Œå¸Œæœ›å¯¹å¤§å®¶æœ‰ç”¨SQLè¯å¥å¤§å…¨ --è¯ å¥ åŠŸ 能--æ•°æ®æ“作SELECT --从数æ®åº“表ä¸æ£€ç´¢æ•°æ®è¡Œå’Œåˆ—INSERT --å‘æ•°æ®åº“è¡¨æ·»åŠ æ–°æ•°æ®è¡ŒDELETE --从数æ®åº“表ä¸åˆ 除数æ®è¡ŒUPDATE --æ›´æ–°æ•°æ®åº“表ä¸çš„æ•°æ®--æ•°æ®å®šä¹‰CREATE TABLE --创建一个数æ®åº“...
Create trigger in MySQL
To create trigger in MySQL, the syntax is :CREATE [DEFINER = { user | CURRENT_USER }] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_bodyOne example is :DELIMITER %%DROP TRIGGER IF EXISTS delete_commentCREATE TRIGGER delete_comment AFTER DELETE ON file_generate_infoFOR EACH ROW BEGIN DELETE FROM article_comment WHERE article_id=OLD.article_id;END%%The whole create trigger statement should be complete statement but not many separate commands. So we use %% as the statement delimiter. You can choose other symbols as delimiter as well....
2,235 0 MYSQL TRIGGER DILIMITER PHPMYADMIN
An example of SQL outer join
SELECT MEMBER.Name, MEMBER.Address, ORGANIZER.phoneNo, TRAVEL.Tour_Name, TRAVEL.Start_Date, TRAVEL.End_DateFROM TRAVEL RIGHT JOIN ((MEMBER LEFT JOIN ORGANIZER ON MEMBER.Member_ID=ORGANIZER.memberID) LEFT JOIN PARTICIPATION ON MEMBER.Member_ID=PARTICIPATION.MemberID) ON TRAVEL.TravelID=PARTICIPATION.TravelID;...
3,128 0 ACCESS SQL OUTER JOIN