sql syntax cheat sheet

Tags: Remember Change Order rename new str des check logsData Sheet View Data Sheet Modify Table name Modify Field names modifying field data types Add Delete-field constraint (primary foreign key default check) To view the table structure: Syntax: Desribe (description) table_name; 　　　　　　DESC table_name;

system -,/etc/sysconfig/network-scripts/ifcfg-eth0 view IP. +,/USR/LOCAL/APP/PHP5 B/php.ini//PHP Related Settings A,/usr/local/app/apache2/conf/extra tpd-vhosts.conf//Virtual Site Settings at, C:\Program files\rhinosoft.com\serv-U\servudaemon.ini -, C:\windows\my.ini -, C:\Boot.ini　　Website Common configuration file config.inc.php, config.php. Load_file () with replace (Load_file (HEX), char (32))Note:Char (60) indicates Char (32) indicates a spaceProblems with manual injections:When the post-i

a personnel database with such a data sheet: Id LastName FirstName Address City 1 Adams John Oxford Street London 2 Bush George Fifth Avenue New York 3 Carter Thomas Changan Street Beijing First create the database: Create Database w3s; To view the database that was created: show databases; Sele

Some of the most commonly used SQL statement syntax for the triple compilation. Need a friend to come over to refer to the next I. Data Control statement (DML) section 1.INSERT (Insert the statement into the data sheet) INSERT into table name (field name 1, field Name 2, ...) Values (value 1, value 2, ...); INSERT into table name (field name 1, field Name 2,

money=money+200 WHERE in (3,6); --Query all members of the surname Zhang Select*from t_user WHERE username like ' Zhang% '; --Query all names containing the members of the sheet Select*from t_user WHERE username like '% zhang% '; --Query name only two words and surname Zhang Select*from t_user WHERE username like ' Zhang _ '; --Show all members by salary sort Select*from t_user ORDER by Money DESC; --The default is ASC ascending, desc descending --Di