INFORMATICS

The Best

Przełącznik języka

Zaproś mnie na KAWE

Jeżeli podoba Ci się strona i chcesz wspomóc projekt!

Postaw mi kawę na buycoffee.to

Tools

This Site

Mining

Księgowość

Płatnik

Security

CMS

Hardware

Backup

Windows Server

Uncategorised

Databases

Przydatne strony

Emulators

Poczta

PHP

Powershell

Storage Array

Active Directory

SEO

Serwis

MSSQL

DNS

FORTINET

Windows

Poradniki

Antivirus program

Linux

Naprawy

Windows Server

Foto

Licznik

3.png0.png4.png0.png7.png1.png0.png
Today814
Yesterday897
This week5592
This month15611
Total3040710

Visitor Info

  • IP: 18.189.143.1
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

6
Online
czwartek, 21 listopad 2024 19:05

Komenty MYSQL c2

Ocena użytkowników: 3 / 5

Gwiazdka aktywnaGwiazdka aktywnaGwiazdka aktywnaGwiazdka nieaktywnaGwiazdka nieaktywna
 

 

 

Komendy MySQL Funkcje String Funkcja Data i Czas Funkcje matematyczne
ALTER DATABASE AES_DECRYPT ADDDATE ABS
ALTER TABLE AES_ENCRYPT ADDTIME ACOS
ALTER VIEW ASCII CONVERT_TZ ASIN
ANALYZE TABLE BIN CURDATE ATAN
BACKUP TABLE BINARY CURRENT_DATE ATAN2
CACHE INDEX BIT_LENGTH CURRENT_TIME AVG
CHANGE MASTER TO CHAR CURRENT_TIMESTAMP BIT_AND
CHECK TABLE CHAR_LENGTH CURTIME BIT_OR
CHECKSUM TABLE CHARACTER_LENGTH DATE BIT_XOR
COMMIT COMPRESS DATE_ADD CEIL
CREATE DATABASE CONCAT DATE_FORMAT CEILING
CREATE INDEX CONCAT_WS DATE_SUB COS
CREATE TABLE CONV DATEDIFF COT
CREATE VIEW DECODE DAY COUNT
DELETE DES_DECRYPT DAYNAME CRC32
DESCRIBE DES_ENCRYPT DAYOFMONTH DEGREES
DO ELT DAYOFWEEK EXP
DROP DATABASE ENCODE DAYOFYEAR FLOOR
DROP INDEX ENCRYPT EXTRACT FORMAT
DROP TABLE EXPORT_SET FROM_DAYS GREATEST
DROP USER FIELD FROM_UNIXTIME GROUP_CONCAT
DROP VIEW FIND_IN_SET GET_FORMAT LEAST
EXPLAIN HEX HOUR LN
FLUSH INET_ATON LAST_DAY LOG
GRANT INET_NTOA LOCALTIME LOG10
HANDLER INSERT LOCALTIMESTAMP LOG2
INSERT INSTR MAKEDATE MAX
JOIN LCASE MAKETIME MIN
KILL LEFT MICROSECOND MOD
LOAD DATA FROM MASTER LENGTH MINUTE PI
LOAD DATA INFILE LOAD_FILE MONTH POW
LOAD INDEX INTO CACHE LOCATE MONTHNAME POWER
LOAD TABLE...FROM MASTER LOWER NOW RADIANS
LOCK TABLES LPAD PERIOD_ADD RAND
OPTIMIZE TABLE LTRIM PERIOD_DIFF ROUND
PURGE MASTER LOGS MAKE_SET QUARTER SIGN
RENAME TABLE MATCH    AGAINST SEC_TO_TIME SIN
REPAIR TABLE MD5 SECOND SQRT
REPLACE MID STR_TO_DATE STD
RESET OCT SUBDATE STDDEV
RESET MASTER OCTET_LENGTH SUBTIME SUM
RESET SLAVE OLD_PASSWORD SYSDATE TAN
RESTORE TABLE ORD TIME TRUNCATE
REVOKE PASSWORD TIME_FORMAT VARIANCE
ROLLBACK POSITION TIME_TO_SEC  
ROLLBACK TO SAVEPOINT QUOTE TIMEDIFF  
SAVEPOINT REPEAT TIMESTAMP  
SELECT REPLACE TIMESTAMPADD  
SET REVERSE TIMESTAMPDIFF  
SET PASSWORD RIGHT TO_DAYS  
SET SQL_LOG_BIN RPAD UNIX_TIMESTAMP  
SET TRANSACTION RTRIM UTC_DATE  
SHOW BINLOG EVENTS SHA UTC_TIME  
SHOW CHARACTER SET SHA1 UTC_TIMESTAMP  
SHOW COLLATION SOUNDEX WEEK  
SHOW COLUMNS SPACE WEEKDAY  
SHOW CREATE DATABASE STRCMP WEEKOFYEAR  
SHOW CREATE TABLE SUBSTRING YEAR  
SHOW CREATE VIEW SUBSTRING_INDEX YEARWEEK  
SHOW DATABASES TRIM    
SHOW ENGINES UCASE    
SHOW ERRORS UNCOMPRESS    
SHOW GRANTS UNCOMPRESSED_LENGTH    
SHOW INDEX UNHEX    
SHOW INNODB STATUS UPPER    
SHOW LOGS      
SHOW MASTER LOGS      
SHOW MASTER STATUS      
SHOW PRIVILEGES      
SHOW PROCESSLIST      
SHOW SLAVE HOSTS      
SHOW SLAVE STATUS      
SHOW STATUS      
SHOW TABLE STATUS      
SHOW TABLES      
SHOW VARIABLES      
SHOW WARNINGS      
START SLAVE      
START TRANSACTION      
STOP SLAVE      
TRUNCATE TABLE      
UNION      
UNLOCK TABLES      
USE      

 

Search