My name is latif Khan. I am an IT Professional (Programmer, Developer, Analysit, Designer).
About my Education:
Msc Computer Science (Quaid-i-Azam University Islamabad pakistan)
MS Mobile Computing (University of Bedfordshire UK)
On this website you will find different programming and database tutorials .
This function convert first letter of a string to uppercase and the rest of the string will be in lowercase.
UPDATE table_name SET field_name = CONCAT(UPPER(LEFT(field_name, 1)), LOWER(SUBSTRING(field_name, 2)))
update column1 of table1 from column1 of table2 on the basis of both tables ids.
UPDATE table1
SET column1 = table2.column1
FROM table1 , table2
WHERE table1.column_id = table2.column_id
delete X1 from TableName X1, TableName X2
where X1.DupColumn = X2.DupColumn and X1.id > X2.id
Linux – 2.0
1. Create directory:
mkdir dir1
2. Remove empty directory:
rmdir dir1
A relational database consists a set of relations , attributes each attribute being identified by its name. Relational database is done to save maintenance cost, efficiency , save space (disk space)
More accurately, the relational model is based on predicate logic and set theory. You have sets of statements of fact, and the underlying system can determine new sets of facts from those. For efficiency, you have to organize those facts into groups that share the same structure (names and associated type domains), and in practice your ability to draw conclusions is limited by the system’s command language (SQL poorly implements predicate logic and set theory; and the database doesn’t do much of your thinking for you). The real power comes from your complete control over determining new facts. All relationships between facts are explicit in the database, and the command language can use and manipulate them. The mathematics behind the model make this manipulation feasible.
SELECT * from
FROM customers
INTO OUTFILE '/foldername/customers.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
this will return last inserted id in a table by a database connection used.
mysql_query($mysql_insert_query, $db_connection);
$last_inserted_Id = mysql_insert_id($db_connection);
Case in sql Select
Case can be used in different ways. In this example it is used as to mask the actual value of column.
SELECT product_id , 'Special Offer' = CASE
WHEN special_price < normal_price THEN 'Product on Special Offer'
ELSE 'Normal Price'
END
FROM Products
This query will select a random date time in the past 60 days
many of the programmers use nested loop to display two levels of category. which is not an efficient way. we can fetch all the data in one call, and then display it using some logic.