SQL

Sub Queries

We can simply say query within another query. we can say that a Subquery is a query that is embedded in WHERE clause of another SQL query. Important rules for Subqueries: You can place the Subquery in a number of SQL clauses: WHERE clause, HAVING clause, FROM clause. Subqueries can be used with SELECT, UPDATE, INSERT, DELETE statements …

Sub Queries Read More »

Who uses these databases?

Here are a few examples of famous companies that use these databases: PostgreSQL:  Apple BioPharm Etsy IMDB Macworld Debian Fujitsu Red Hat Sun Microsystem Cisco Skype MySQL: GitHub US Navy NASA Tesla Netflix WeChat Facebook Zendesk Twitter Zappos YouTube Spotify.

MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB

Method : 1 Change a settings in “my.ini” innodb_log_file_size = 500M innodb_log_buffer_size = 800M ‘my.ini’ file location in Ubuntu/Linux: my.ini file might be one of below location /etc/my.cnf /etc/mysql/my.cnf $MYSQL_HOME/my.cnf [datadir]/my.cnf ~/.my.cnf ‘my.ini’ file location in Window: Below steps for my.ini file cd C:\Program Files\MySQL\MySQL Server 5.5 copy my-medium.ini my.ini net stop mysql net start …

MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB Read More »