Description of MySQL usage tips

The following articles mainly introduce MySQL usage skills. I like to accumulate some tips or some useful experience when using MySQL databases, the following articles mainly describe how to use MySQL. I hope you will gain some benefits after reading them.

One of the tips for using MySQL.

 
 


  
  
Show databases;

  
  
Show tables;

 
 

MySQL Tips 2.

Print display

 
 


  
  
Select "Creating Foo table" as "Action ";

 
 

MySQL usage tips 3. Prevent SQL Injection

 
 


  
  
MySQL_real_escape_string (XXXX)

 
 

This function can filter 'and other symbols.

MySQL usage tips 4. char Functions

 
 


  
  
Select char (83,99, 48,114,112,105,111,110) as "Action ";

 
 

The above content is an introduction to MySQL's usage skills. I hope you will have some gains.