Categories
Database

Basic SQL Statements with Example

SQL or T-SQL Statement/syntax are quite important for the database developer, here are some selected basic statements with example using SQL Server that may help you to get started with sql query. Basic SELECT statement, * means all columns SELECT * FROM Customers Basic SELECT statement, specifying which columns to display SELECT FirstName, LastName FROM […]

Categories
MySQL

Import file size limit in PHPMyAdmin

Performance tuning is very important and there are still a lot of question around, here our tips to help base on our experience. Import file size limit in PHPMyAdmin For uploading large files through PHPMyAdmin, follow these steps: Step 1: Open your php.ini file. Step 2: Upgrading Memory Limit: memory_limit = 750M Step 3: Upgrading […]

Categories
Java

How to create project with MAVEN

I. How to create project in MAVEN There are two ways for create project in MAVEN 1. Normal Java Project Step 1: cmd past below code to command prompt mvn archetype:generate -DgroupId=com.javacambodia -DartifactId=NumberGenerator -DarchetypeArtifactId=maven-archetype-quickstart -DinteractiveMode=false Note: DgroupId : name of your package (whatever you want) DartifactId : name of your project Press enter Step 2: […]

Categories
Source Control

How to use GitLab

  I. How to use GitLab Go to website GitLab (https://gitlab.com) Step 1: We have to add SSH key to your profile Step 2: Right click on any directories on your local computer Step 3:Please follow this step after you signup on Gitlab: Generate key on Git Bash: ssh-keygen -t rsa -C “your.email@example.com” -b 4096 […]