Most common MySQL or MariaDB commands for Web Developers

Create Database 
  create database <Database Name>;

Selecting a Database
  Use <Database Name>;

List all tables in Database
  show tables;

Create User table
CREATE TABLE USER (
  ID int NOT NULL,
  NAME varchar(100) NOT NULL,
  EMAIL_ADDRESS varchar(100),
  PRIMARY KEY (ID)
)
Or 
CREATE TABLE USER (
  ID int NOT NULL AUTO_INCREMENT,
  NAME varchar(100) NOT NULL,
  EMAIL_ADDRESS varchar(100) NOT NULL,
  SALARY double DEFAULT NULL,
  NOTE text,
  PRIMARY KEY (ID)
)


Comments

Post a Comment

Popular posts from this blog

How to do AJAX using XMLHttpRequest for large data

Your are at right place if you are : working on loading huge amount of data from server be it JSON or XML document getting truncated JSON Response string  observing $.ajax call failure due to JSON.parse is compiling about invalid char while parsing JSON  observing performance lag while parsing JSON using $.ajax observing response code 200 but there is not response received in $.ajax success call  Uncaught InternalError: allocation size overflow in $.ajax If you are loading large data from server then you need to consider lot of factors impacting load time. There can be optimization on server as well as client. Coming to client, most commonly used API for AJAX is JQuery.ajax. But when it comes to fetching large data set from server be it in JSON format or XML document, you might end up facing issue mentioned at the beginning of this blog. I observed that in case of large JSON String in response, response string is being truncated. Also, if string is not truncated, JSON.par...
Read more

Caching mechanisms in modern world browser

Image
           Getting data locally is always faster than the getting data from server. There are different types of caching mechanism that can be used to cache data on browser for optimizing performance and faster data retrieval. We will see some of the data store that can be used on client to cache or store data. 1. Session Storages     This is a very well-known storage on browser. Commonly uses to session specific data on this store. We can infer a current tab as one session. Session storage will not be available across tabs or new tab. Maximum limit of of session storage is 5MB.     Limitations:     It cannot use to persist information across tab or sessions     It cannot store data more than 5MB.     Data is not secure. Additional effort need to secure data stored 2. Local storage     Local storage is also a very well-known storage. This is u...
Read more

Polymorphism in Java OOP

Image
Polymorphism is word made from two words "Poly" which means many and "morph" means shape/form. Polymorphism means "ability to take multiple shapes or forms". In Java, method and Object both takes multiple forms. There are two forms of polymorphism : Compile time Polymorphism Run time Polymorphism Compile time polymerphism Compile time polymorphism is achieved using method overloading. Method will have same signaturre(name) but different parameters.This method is bound statically with method name and input parameter type hence static binding. Output : Display String Display int Runtime Polymorphism Method overriding is used to achieve Runtime polymorphism. Method will be overridden in subclass. This method is resolved depending on Object instance dynamically at runtime. Output : Display of Display Unit. Display of Monitor.
Read more