Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
ALIAS Keyword
ALIAS Keyword:
It is used to give temporary names to table and columns. It is very useful for situations where column or table names are too long.
Synatx:
SELECT columnname AS alias_name FROM tablename;
This syntax is used ...
How to hit MySql queries by using Angular JS
Hello Readers If you want to hit the MySql queries from another page by your current page, The by using Angular js you can do this. Also angular js will offers you to show your records in a pre formated desing.
Let's see the example as below:-
...
SQL Tutorial -> Sql Delete
<-- Chapter 19: SQL UPDATE
Chapter 20
SQL DELETE
DELETE statement is used to delete a particular data Rows from Database Table with the help of WHERE clause. Without WHERE clause all rows will be deleted.
Lets see an example from th...
SQL Tutorial > Sql And & Or
<-- Chapter 15: SQL <= Operator
Chapter 16
SQL And & Or
AND/OR Operators are used in SQL statements to filter the Records based on more than one condition. AND Operator display the records in which all the specified conditions a...
SQL Tutorial -> Sql > Operator
<-- Chapter 11: SQL BETWEEN Operator
Chapter 12
SQL > Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-...
SQL Tutorial -> Sql != Operator
<-- Chapter 8: SQL = Operator
Chapter 9
SQL != Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Docto...
How to pass mulitple values to update records with a single query
Hello Readers if you want to update mulitple record by multiple id, then you have to use in clause in MySql
Lets see the example as below:-
$ids = array(474,25, 99,101);
Here I have an array $ids with multiple id's. Now this array w...
SQL Tutorial -> Sql = Operator
<-- Chapter 7: SQL NOT IN Operator
Chapter 8
SQL = Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
D...
SQL Tutorial -> Sql NOT IN Operator
<-- Chapter 6: SQL IN Operator
Chapter 7
SQL NOT IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
...
SQL Tutorial -> Sql IN Operator
<-- Chapter 5: SQL Where
Chapter 6
SQL IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Doctor
80...
I'm getting import CSV error while uploading files in php
Hi i'm developing the panel where admin can import the csv file directly to mysql database. But I'm getting the error.
My code is
<?php
//ENTER THE RELEVANT INFO BELOW
$mysqlDatabaseName ='bilmos';
$mysqlUserName ='root';
$mysqlPasswor...
SQL Tutorial -> Sql Where
<-- Chapter 4: SQL Distinct
Chapter 5
SQL Where
SQL Where : SQL Where clause extract or filters those records which matches the specified condition. Syntax for Where clause is used below
SELECT *
FROM tablename
WHERE condition
...
SQL Tutorial -> Sql Distinct
<-- Chapter 3: SQL Select
Chapter 4
SQL District
SQL District : District is a keyword which is used to fetch unique column values from database table OR we can simply say that ignores the column duplicate values. Syntax for district ke...
SQL Tutorial -> Sql Select
<-- Chapter 2: SQL Syntax
Chapter 3
SQL Select
SQL Select :
SELECT command describes that through which we can fetch data from MYSQL database tables OR we can say, It is used to retrieve/select data from MYSQL database.
SELECT comma...
SQL Tutorial ->Introduction to SQL
Chapter 1
Introduction to SQL
Introduction to SQL : SQL stands for Structured Query Language or we can call it as "sequel" or "S-Q-L" . SQL is a query Language used to accessing and modifying information in a database.There are some common ...
SQL Tutorial -> Sql Syntax
<-- Chapter 1 Introduction to SQL
Chapter 2
SQL Syntax
SQL Syntax : SQL syntax is basically followed by sql commands which modifies the database tables such as "users" , "students" etc. All the SQL statements always starts with the key...
Handling Duplicates using INSERT IGNORE
INSERT IGNORE:
INSERT IGNORE is used for handling duplicacy in a table as it ignores the query if the data is already present in the table and if the data does not exist then new row will be inserted.
Syntax:
INSERT IGNORE INTO tablename...
What is the join in MySQL ?
Welcome to findnerd, today we are going to discuss to join in MySQL.
Firstly let know what is join ?
An SQL JOIN clause is used to combining two or more tables and return output in single table.
So in simple word we can say that MySQL ...
Pattern Matching using REGEXP
REGEXP:
It is similar to LIKE which is used to fetch data based on regular expression from a table.
Syntax:
SELECT columnname(s) FROM tablename WHERE columnname REGEXP pattern;
Example 1:
SELECT name FROM Employee WHERE name R...
What is the mysql Constraints?
Welcome to FindNerd,
Today we are going to discuss about MySQL Constraints.
Firstly let know what is Constraints in MySQL ?
Constraints:- Constraints are the utilities that restrict ingression of data into the table if the designated co...
SQL Server Management Data Warehouse (MDW)
Management Data warehouse is a database containing a warehouse of data useful for managing SQL Server. Ensuring the excellent and high performance for all the users and customers is a high priority for Database Administrators. Troubleshooting SQL...
Compression and Decompression in SQL Server 2016
In the upcoming version of SQL 2016 a new component of COMPRESS and DECOMPRESS T-SQL functions is added. SQL Server 2016 provides built in functions for compression and decompression.The COMPRESS and DECOMPRESS functions can store and retrieve da...
how can I use php to display question
how can I use php to display question stored in mysql database and choose the right answer for it and give grade if the answer is right and store it back in mysql database (sorry I don't speak English very well )
Use of Transaction in DBMS
A transaction is any unit of work done against the database.A transaction can be used to save the changes made to the database, it can be used to rollback the database to any save point.
For example say if you are creating or updating a record...
How to get the colomn name of table using MySql
Hello Reader's, If you have to get the only names of columns of table then see the code below:-
You can use following query for MYSQL:-
SHOW columns FROM your-table;
Below is the example code which shows How to implement above syntax in ph...
how to stick posts to their respective posts in php&mysql
Guys im trying to join a comments table to posts table using the following query in a method.
public function feedView($session,$friend,$updateid) {
$sql2=" select u.update_body,u.author,u.time,u.title,u.account_na...
How to reset the Auto increment in mysql
Hello Reader's! If you already using the Mysql then you have seen the ID with autoincrement always add up. Forevery new entery the ID will increase even if you drop the table.
So if you want to reset this value you just have to run the mysql cod...
How to use IN statement using array in Mysql
Hello reader's! If you have an array with multiple values to match with database coloumn. Then you can use IN statement in mysql but you have to explode the array first.
let's see the exampkle below:-
$findIN= implode(',', $YourArray); // fir...
Syntax error due to reserved names in Mysql
Hello Reader's!, On using Mysql with the some special resereved keywords the error :-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near <Keyword>
It...
Use of '@' in PHP
Hello Reader!, You might have seen people using the '@' in the PHP coding. The operator '@' is used when you don't want to show the error messages even if they occur.
By using '@' the errors will be hidden.
Let's see the two syntax below:-
...
Using MySQL with node.js
Hello Everyone , In this blog we will discuss about how to use MYSQL in node.js.
node-mysql is one of the best modules which can be used for working with MySQL database.
To install the MySQL in node.js driver you have to follow up with the be...
How to insert if not exists in Mysql
If you want to enter a new records that is not exits then you can use Mysql two methods
Method 1 'REPLACE' :-
REPLACE INTO `users`
SET `userid` = 65,
`username` = 'abc',
`useremail` = 'abc@gmail.com';
In this case if record exists...
Uploading captured image into the specific folder server using volley library
This is one of the famous question which is unanswered clearly. I have posted it on stackoverflow link as follow:
http://stackoverflow.com/questions/33341069/uploading-captured-image-into-the-specific-folder-server-using-volley-library
I wa...
How to import mysql database using command line?
Sometimes when you have large databases files and you are unable to import the database manually. Then the easiest (and fastest) way is to use command line.
Import:--
1. Run the cmd (DOS) and get into the mysql folder, which in my case wo...
errror come on run time to connect my android app with mysql
my code this
AllProductsActivity Class
public class AllProductsActivity extends ListActivity {
// Progress Dialog
private ProgressDialog pDialog;
// Creating JSON Parser object
JSONParser jParser = new JSONParser();
ArrayList<H...
How to delete duplicate rows in a table set MySql
Hello readers!. If you having the much of redundant/duplicate data growing in your database you can delete it with just a single query as I wrote here.
Let say I have a table Address and want to delete the all the duplicate records whose city...
Php WP how to send a mail to the admin from a logged user
Hello,
I would like to know if in WP PHP is possible to make something like that:
I need for the logged user a form which when compiled and submitted, send a mail to the admin with the all data of the user from db and the message he/she write. ...
How to add a column with comment in MySql?
Sometimes we need to add a column with comment. We can do this easily by using COMMENT attribute in alter command.
Ex- Find the below alter command which will add "address" column to "user" table after "country" column.
ALTER TABLE `user` A...
Insert Data into MySQL database from HTML SubForms
Hello EveryOne,
I have 2 HTML Forms:
1. Register/Login
2. After User gets Login, He used to update details of him.
I used MySql database in order to save Login details of User. And also i have another table for updating details of him aft...
Entering Values in Second table with help of Primary Key of First Table
Hello EveryOne....
Here is the scenario.,
In MySql database, I have two tables.. User and UserDetails...
In 'User' table, i had generated userID made it as a primaryKey.
For Example, 101->user1.... 102->User2
Now I need...
How to calculate distance from Latitude and longitude
Hello readers!, If you are having a project in PHP and need to calculate the distance from lat and longs you can use the code below:-
Here all the entries are saved in table('business')
(SELECT name, ACOS(SIN(RADIANS($latitude))*SIN(RADIANS...
PHP TEAMLEADER FR EINES DER SPANNENDSTEN UNTERNEHMEN BERLINS GESUCHT !!!
Fr den Standort Berlin suchen wir zum nchstmglichen Termin eine/n
PHP Leadentwickler/Teamleiter (m/w)
Deine Aufgaben
Aufbau eines eigenen Entwickler-Teams mit dem Ziel fachliche und eventuell disziplinarische Fhrung eines bis zu 5 kpfig...
Control Flow Functions in MySQL
Mysql have several contral flow functions. Such as
1) IF
2) CASE
3) IFNULL
4) NULLIF
Control Flow functions returns value based on processed each row by query executed.
Contral Flow function can be used on **SELECT, WHERE, GROUP BY** a...
Stored Procedures and Functions in MySQL- Part 5
Conditional Constructs - IF...ELSEIF..ELSE
This construct is used to evaluate some complex conditions and based on the results execute different set of statements.
The basic syntax is
IF <conditions> THEN
&n...
Indexed full text search in PHP-MySQL (PART - 1)
We need to write search queries every now and then in our projects. This is one of the most common tasks a PHP developer has to do. Most of the developers still use wildcard queries for this purpose which is very slow in searching records. Howeve...
Stored Procedures and Functions in MySQL - Part 3
Parameters in Stored Routines
While executing any stored routine sometimes we need to pass on certain values in stored procedures these values are handled as Parameters. Their declaration consists of three parts :
Type of parameter
Par...
Create Update, Delete and Insert Functions
Hello,
Here I am writing the code to create update, insert and delete functions so that we can use it the same functions anywhere in the project.
<?php
// function to insert data
function insert($table = "", $fieldsArray = array()) {...
Case Sensitive MYSQL select query
Case Sensitive SQL query
A select query does not performs case-sensitive query which means if the user name is pravesh, Pravesh, PRAVESH then it will select all users using simple select. Below example of normal mysql select query -
SELECT...
Crosstab Query Sample
To convert the rows to column in MySQL
Sample query:
select column1, count((case when (column2 = 'M') then 0 end)) AS `males`, count((case when (column2 = 'F') then 0 end)) AS `females`,count(0) AS `Total` from table_name group by ...
How to connect to your MySQL database from a PHP Script
Create simple Mysql connection with the help of PHP code
<?php
$hostname = 'localhost'; //define the hostname here
$username = 'root'; //define the username here
$password = ' '; ...
