Home » Archive

Articles tagged with: SQL

Magento »

[19 Mar 2012 | No Comment]

Here is a quick tip to add OR query and AND query to collection object. I am implementing this on product collection. Getting product collection

Database, MySQL »

[18 Jul 2011 | 3 Comments]

Some definitions of foreign key:- A FOREIGN KEY in one table points to a PRIMARY KEY in another table. A foreign key is a field in a relational table that matches the primary key of another table. The foreign key can be used to cross-reference tables. A table may have multiple foreign keys, and each [...]

Magento »

[2 Aug 2010 | 2 Comments]

Scenario: You have created a custom module. You have entered certain data in your database. You need to show the data randomly. Solution:

Database, MySQL, SQL »

[15 May 2010 | 2 Comments]

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. [@via w3schools] A SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or [...]

Database, SQL »

[10 Mar 2009 | One Comment]

Error description: Cannot insert the value NULL into column ‘SourceId’, table ‘Advisory.dbo.AdvDocSource’; column does not allow nulls. INSERT fails. The statement has been terminated. The ‘CompanyAdd’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. ——————————- This error occurs because the ‘SourceId’ column in [...]