First123Last
1 of 5 pages
    Mohammad Towhidul Islam

    23-Dec-16 10:15:10 pm

    Query to swap row values in mysql

    Query to swap row values in mysql
    First you have to create a tmp_field update item_uom_factor set factor=(select factor from it

    Read More...


    1. Like
    2. Comment
    3. VCampus
    Mohammad Towhidul Islam

    11-Dec-16 11:14:18 am

    How to update field by increment in mysql

    How to update field by increment in mysql
    SET @a = 0; UPDATE item_master set order_by=(@a:=@a+1);

    Read More...


    1. Like
    2. Comment
    3. VCampus
    Mohammad Towhidul Islam

    17-Oct-15 11:41:49 am

    Understanding MySQL Cursor

    Understanding MySQL Cursor
    In this tutorial, you will learn how to use MySQL cursor in stored procedures to iterate through

    Read More...


    1. Like
    2. Comment
    3. VCampus
    Mohammad Towhidul Islam

    07-Oct-15 09:43:58 am

    MySQL Data types and Attributes Example

    MySQL Data types and Attributes Example
    1. Date and Time Data Types: a) DATE: create table student( id int(10) primary ke

    Read More...


    1. Like
    2. Comment
    3. VCampus
    Mohammad Towhidul Islam

    26-Jul-15 03:18:25 pm

    MySQL Descriptive Questions and Answers, WPSI, IDB-BISEW

    MySQL Descriptive Questions and Answers, WPSI, IDB-BISEW
    1. What are MySQL clients? Answer: The MySQL server is used to persist the data and provide a

    Read More...


    1. Like
    2. Comment
    3. VCampus
First123Last
1 of 5 pages