Visitor Table in MYSQL
js
12:49:00
Create a visitors table and create some basic Store Procedures. create_visitors CREATE DEFINER=`root`@`localhost` PROCEDUR...
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
Sunday, 20 October 2019
Thursday, 14 May 2015
mysql
mysql
New
Transaction in mysql
js
23:07:00
Transaction A transaction is a set of one or more SQL statements that perform a set of related actions. In addition to ensuring the prop...
Tuesday, 12 May 2015
mysql
mysql
New
Dynamic Query in mysql
js
22:26:00
Dynamic Query delimiter $ CREATE PROCEDURE execute_immediate(in_sql VARCHAR(4000)) BEGIN SET @tmp_sql=in_sql; PREPARE s1 FROM @tmp_sql; E...
mysql
mysql
New
Auto increment in mysql query
js
22:21:00
Auto increment Auto increment can be any data type Tinyint (signed , unsigned), smallint... auto increment column automatically add th...
Sunday, 10 May 2015
mysql
mysql
New
View in mysql
js
22:56:00
Creating a View A view is essentially a SQL Server object that specifies exactly how a user will see that data in a database. It is a sto...
Saturday, 9 May 2015
mysql
mysql
New
subqueries in mysql
js
16:12:00
subqueries in mysql joins perform better than subqueries , so it’s often more efficient to rewrite a subquery as a join when possible. ...
mysql
mysql
New
Procedure in mysql
js
16:04:00
Procedure A database stored program sometimes called a stored module or a stored routine is a computer program (a series of instruction...
mysql
mysql
New
Select Into in mysql
js
14:50:00
Select Into SELECT INTO has two different parts: First, it creates the new table with the columns corresponding to the columns listed i...
mysql
mysql
New
Save query result in table
js
14:44:00
Save query result in table If the destination table already exists, use INSERT ... SELECT to copy the result set into it. For example, if...
Thursday, 7 May 2015
mysql
mysql
New
Query Optimizer
js
00:31:00
Query Optimizer In order to ensure that your SELECT statements retrieve data as quickly as possible, you can ensure that your tables have...
Wednesday, 6 May 2015
mysql
mysql
New
Operator in mysql
js
14:41:00
Operator in mysql (++, --, +=, etc.) are not supported. DECLARE a int default 2; DECLARE b int default 3; DECLARE c FLOAT; SET c=a+b; sel...
mysql
mysql
New
different datatypes in mysql
js
14:38:00
different datatypes in mysql String Data Types The CHAR data type is a fixed-length character data type that can store up to 255 charac...
mysql
mysql
New
join in mysql
js
00:07:00
join in mysql join is used to get records from related tables. Basic Join SELECT BookTitle, Copyright, AuthID FROM Books AS b, Author...
Tuesday, 5 May 2015
mysql
mysql
New
index in table
js
23:58:00
Index Index is used to increase the performance of the query. When creating a table definition that includes indexes, you should plac...
Monday, 4 May 2015
mysql
mysql
New
Group By in mysql
js
22:58:00
Group By Get all jobs of the employees: USE sample; SELECT job FROM works_on GROUP BY job; Aggregate Functions The argument of an aggre...
mysql
mysql
New
Global Unique IDs or GUIDs in mysql
js
22:44:00
Globally Unique Identifier (GUID) in C# - Tips and Tricks A GUID is a 128-bit integer (16 bytes). GUID is Globally Unique Identifier. pro...
mysql
mysql
New
Get page wise records in mysql
js
22:32:00
Get page wise records Select * from items Limit 0,10 >> return firt 10 records Select * from items Limit 11,10 ...
mysql
mysql
New
System-Related Functions in mysql
js
22:08:00
System-Related Functions SELECT CONNECTION_ID(); SELECT DATABASE(); SELECT VERSION(); The function takes one argument, which is the netwo...
mysql
mysql
New
ENCODE() and DECODE() Functions in mysql
js
21:52:00
ENCODE() and DECODE() Functions The first encryption function that you look at is the ENCODE() function, which encrypts a specified strin...
mysql
mysql
New
Bit Functions in mysql
js
21:44:00
Bit Functions The bit aggregate functions work in the same way that bit operators work. When values in a grouped column are calculated us...
Comments