Search In
Error Code : 1005
Can't create table 'DatabaseName.#sql-9cc_1' (errno: 150)
(0 ms taken)
After searching a lot i have got solution for the above problem while i was adding FK to a column.
The error was because of different MySQL engine. There are di
Hello Readers,
If you want to speed up the mysql query or optimize the query:
Below are some points to follow while writing the mysql query:
Always every table must have a Primary Key. Primary key is very essential for mysql operation
While crea
PHP has three types of modules which are as following.
A) Core PHP : This modules handles requests, error handling as well as file streams.
B) Zend Engine: It convert the php code into machine tokens or opcode and it will execute it in a virtual ma
ORM means "Object Relational Mapping."
it is a technique that we basically used to convert types of data to an Objects
Also as converting any objects to data.
Magento, ORM is stands as Model (which is based on Zend Framework Zend_Db_Adapter)
G
Welcome to Findnerd. Today we are going to disccus two new features introduces in PHP7 that are closure::call. You can bind the outer function in class. It is also known as temporarily binding an object scope to a closure and invoking it. Please have
Sometimes we need to drop a column that we don't need further from the table. We can do this by using DROP keyword with ALTER command.
Syntax:
To drop/delete the column from a table, use the following syntax:
ALTER TABLE table_name
DROP COLUMN col
In SQL, FORMAT() function is used to format a column value means how a field will to be displayed.
FORMAT() Syntax
SELECT FORMAT(column_name,format) FROM table_name;
In the above syntax parameters are as below:
Parameter Description
column_
In MySQL, aliases are used to give temporarily name to a table or a column. When we write a query we use Aliases to make column name more readable.
Alias Syntax for Columns
SELECT column_name AS alias_name
FROM table_name;
Alias Syntax for Tables
In MySQL, the BETWEEN operator is used to select values (values can be numbers, text, or dates) from a column within a specified range.
BETWEEN Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
We have a ta
LIKE Operator:
It is used to search for pattern in a table or a database . It is used with where condition. It is similar to REGEXP of MySQL.
Syntax:
SELECT columnname(s) FROM tablename WHERE columnname LIKE pattern-condition;
Example1:
SELECT
