What does SQL Select symbol || mean?

|| represents string concatenation. Unfortunately, string concatenation is not completely portable across all sql dialects: ansi sql: || (infix operator) mysql: concat ( vararg function ). caution: || means ‘logical or’ (It’s configurable, however; thanks to @hvd for pointing that out) oracle: || (infix operator), concat ( caution: function of arity 2 only ! ) … Read more

Can’t import database through phpmyadmin file size too large

For Upload large size data in using phpmyadmin Do following steps. Open php.ini file from C:\wamp\bin\apache\Apache2.4.4\bin Update following lines max_execution_time = 259200 max_input_time = 259200 memory_limit = 1000M upload_max_filesize = 750M post_max_size = 750M than after restart wamp server or restart all services Now Upload data using import function in phymyadmin. Apply second step if … Read more

How to turn on/off MySQL strict mode in localhost (xampp)?

->STRICT_TRANS_TABLES is responsible for setting MySQL strict mode. ->To check whether strict mode is enabled or not run the below sql: SHOW VARIABLES LIKE ‘sql_mode’; If one of the value is STRICT_TRANS_TABLES, then strict mode is enabled, else not. In my case it gave +————–+——————————————+ |Variable_name |Value | +————–+——————————————+ |sql_mode |STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION| +————–+——————————————+ Hence strict mode … Read more