TUTORIEL

How to install DRACULA theme in NOTEPAD ++ Step1: Download this folder :  https://www.dropbox.com/sh/3qu5xo8mk1egw6n/AAAFogo6ZnqCfB5ps66sSTDJa?dl=0 Step 2: Inside the folder copy the file named Dracula.xml Step 3: Open RUN , and type this command:  %AppData%\Notepad++\themes Step 4: Paste the Dracula.xml inside the folder Step 5: Now Restart Notepad ++ Step 6: Now go to Setting, Style configuration in THEME choose DRACULA. Enjoy !!!

Requirement:  1) You need to have JAVA  installed in your PC 2) You need to configure JAVA in your PC, to test if JAVA in configured in your PC. Open Command Prompt in type: JAVAC if you have a response means JAVA it's installed 3) You need a JAVA MAIL library you can download it here: https://www.oracle.com/technetwork/java/javamail/index-138643.html 4) You need to add this code in your IDE. can be (BLUE J, NETBEANS or ECLIPSE) 5)You need an INTERNET connection 6) COPY and PASTE this code in your IDE: import java.util.Properties; import javax.mail.Message.RecipientType; import javax.mail.MessagingException; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress ;  import javax.mail.internet.MimeMessage; import java.util.Properties; import javax.mail.Message.RecipientType; import javax.mail.MessagingException; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddr...

Let's say we have a database called atest and a table called atest with a column called DateT with those date values: +---------------------+ | DateT               | +---------------------+ | 2018-10-05 13:53:34 | | 2018-10-04 00:00:00 | +---------------------+ We know want to display with SELECT command the first date time with is:    2018-10-05 13:53:34 Here is the query for that:    select * from atest where DateT >= cast((now()) as date)and DateT< cast((now() + interval 1 day) as date); And if you have a column which is DATE only use this query:  select * from atest  where DateT = CAST(CURRENT_TIMESTAMP AS DATE) ;

Let say we have a table called transaction and differents columns  we want to make this operation montant=500 -100 with the column  idtransaction  and montant  Step 1: Write this command in mysql: update transaction set montant= montant -100 where idtransaction= -1; The result is: 400 We did a minus operation 500-100 = 400  in mysql