Mysl, MSSQL, Oracle, SQLITE, POSTGRES
First get the name of your database logs use ycsoftware select * from sys.database_files Next just run the following to truncate the logs use ycsoftware go dbcc shrinkfile (ycsoftware_Log,1) backup log ycsoftware with truncate_only dbcc … Read more
They both (“NOT IN” and “NOT EXIST”) have the same functionality with only one major difference: “NOT IN” will return a “NULL” if there are any NULL column(s) in the subquery. “NOT EXISTS” does not … Read more
use Tablename; select table_name, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=DATABASE();
I was always under the impression that varchar maximun length was 255. Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and … Read more
Here are your options: 1. Check the my.ini file 2. Check you GUI Configuration or preferences 3. Run the following query: SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = ‘ycsoftware’
