Indigenous Science & Technology

[ "mistake->1'st success" ]

Tutorials Platform

1'st Time in a Train

On Board::Intro
Syntax
Create Database
Create Table
Constraint
Insert
Select
Where
AND & OR
IN & Between
Order By
Top/Limit
Distinct
Update
Delete
Truncate Table
Drop

JOIN the table to luch with together

Joining Tables
Inner Join
Outer Join
Left Join
Right Join
Full Join
Cross Join

Hey Advanced Ninja!

Union
Like
Alter Table
Aliases
Group By
Having
Create View
Create Index
Dates & Times
Cloning Tables
Temporary Tables
Subqueries

Let's drive with my Examples...

Practicess
Do you have any questions?
Get involve in my projects...

Be Web Developer & Designer

Let me tell something about SQL!

How to create database and table in msql?

Simple, just open and type in cmd [for Windows-10 System 64 bit, Bitnami-wampstack-5.6.31-0]:

cd C:\\Bitnami\wampstack-5.6.31-0\mysql\bin\ (enter)
C:\Bitnami\wampstack-5.6.31-0\mysql\bin>mysql -u root -p (enter)
Enter password: ************ (enter)

Result from mysql:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 147
Server version: 5.6.36 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Now,Type:

mysql> create database testsite;
Query OK, 1 row affected (0.31 sec)
mysql> show databases;
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| testsite |
+--------------------------+
33 rows in set (0.24 sec)
mysql> use testsite;
Database changed
mysql> create table testing(
-> id int(11) NOT NULL AUTO_INCREMENT,
-> name_test varchar(100) NOT NULL,
-> PRIMARY KEY(id)
-> );
Query OK, 0 rows affected (0.36 sec)
mysql>

Login to Mysql:

Microsoft Windows [Version 10.0.16299.192]
(c) 2017 Microsoft Corporation. All rights reserved.
C:\Users\crystal-4>cd C:\\Bitnami\wampstack-5.6.31-0\mysql\bin\
C:\Bitnami\wampstack-5.6.31-0\mysql\bin>mysql -u rot p
ERROR 1045 (28000): Access denied for user 'rot'@'localhost' (using password: NO)
C:\Bitnami\wampstack-5.6.31-0\mysql\bin>mysql -u root p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
C:\Bitnami\wampstack-5.6.31-0\mysql\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.6.36 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

mysql> show databases;
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| advertise |
| apple |
| blog |
| candidateinterestedfield |
| cms |
| dashboard |
| dgpdoctor |
| dgpemployer |
| dgphospitals |
| dgphotels |
| dgpjobseeker |
| docpen |
| docsmania |
| doctorslogin |
| mysql |
| nokia |
| one |
| orange |
| performance_schema |
| phpgang |
| picimage |
| plus_signup |
| profileedit |
| readyjob |
| searchpagination |
| tan |
| test |
| test2 |
| testdb |
| testsite |
| upload_image |
| zencart |
+--------------------------+
33 rows in set (0.55 sec)
mysql> use dashboard;
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_dashboard |
+----------------------------+
| admindashboardsignup |
| cancer_consultation_form |
| casepaper |
| currentreply |
| date |
| general_consultation_form |
| infoandcasepaper |
| keralaayurvedashram |
| minku |
| replytokeralaayurvedashram |
| testing |
| tinku |
+----------------------------+
12 rows in set (0.01 sec)
mysql> select * from date;
+----+----------------------+------------+
| id | col_name | col_date |
+----+----------------------+------------+
| 1 | DATE: Auto CURDATE() | 2018-02-09 |
+----+----------------------+------------+
1 row in set (0.13 sec)
mysql> select * from minku;
+----+-------+
| id | name |
+----+-------+
| 1 | hello |
+----+-------+
1 row in set (0.08 sec)
mysql> select * from tinku;
+----+---------------------+---------------------+
| id | DateTime | name |
+----+---------------------+---------------------+
| 2 | 0000-00-00 00:00:00 | hello |
| 4 | 0000-00-00 00:00:00 | hello |
| 5 | 0000-00-00 00:00:00 | name |
| 6 | 0000-00-00 00:00:00 | |
| 7 | 0000-00-00 00:00:00 | hmmm |
| 8 | 0000-00-00 00:00:00 | 2018-02-10 18:24:57 |
| 9 | 2018-02-10 18:27:02 | hello_bro |
| 10 | 2018-02-10 18:28:32 | hello_bro |
+----+---------------------+---------------------+
8 rows in set (0.07 sec)
mysql> select * from esting;
ERROR 1146 (42S02): Table 'dashboard.esting' doesn't exist
mysql> select * from testing;
Empty set (0.04 sec)
mysql> insert into minku(id, name) VALUES('2', 'your name please?');
Query OK, 1 row affected (0.11 sec)
mysql> select * from minku;
+----+-------------------+
| id | name |
+----+-------------------+
| 1 | hello |
| 2 | your name please? |
+----+-------------------+
2 rows in set (0.00 sec)
mysql> explain minku;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | | NULL | | +-------+--------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> insert into minku values('3','Raj Kumar');
Query OK, 1 row affected (0.04 sec)
mysql> select * from minku;
+----+-------------------+
| id | name |
+----+-------------------+
| 1 | hello |
| 2 | your name please? |
| 3 | Raj Kumar |
+----+-------------------+
3 rows in set (0.00 sec)
mysql> delete from minku where id=3;
Query OK, 1 row affected (0.05 sec)
mysql> select * from minku;
+----+-------------------+
| id | name |
+----+-------------------+
| 1 | hello |
| 2 | your name please? |
+----+-------------------+
2 rows in set (0.00 sec)
mysql> explain testing;
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name_test | varchar(100) | NO | | NULL | |
+-----------+--------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> drop table testing;
Query OK, 0 rows affected (0.15 sec)
mysql> show tables;
+----------------------------+
| Tables_in_dashboard |
+----------------------------+
| admindashboardsignup |
| cancer_consultation_form |
| casepaper |
| currentreply |
| date |
| general_consultation_form |
| infoandcasepaper |
| keralaayurvedashram |
| minku |
| replytokeralaayurvedashram |
| tinku |
+----------------------------+
11 rows in set (0.00 sec)
mysql> show databases;
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| advertise |
| apple |
| blog |
| candidateinterestedfield |
| cms |
| dashboard |
| dgpdoctor |
| dgpemployer |
| dgphospitals |
| dgphotels |
| dgpjobseeker |
| docpen |
| docsmania |
| doctorslogin |
| mysql |
| nokia |
| one |
| orange |
| performance_schema |
| phpgang |
| picimage |
| plus_signup |
| profileedit |
| readyjob |
| searchpagination |
| tan |
| test |
| test2 |
| testdb |
| testsite |
| upload_image |
| zencart |
+--------------------------+
33 rows in set (0.00 sec)
mysql> use nokia;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> drop database nokia;
Query OK, 0 rows affected (0.07 sec)
mysql> show databases;
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| advertise |
| apple |
| blog |
| candidateinterestedfield |
| cms |
| dashboard |
| dgpdoctor |
| dgpemployer |
| dgphospitals |
| dgphotels |
| dgpjobseeker |
| docpen |
| docsmania |
| doctorslogin |
| mysql |
| one |
| orange |
| performance_schema |
| phpgang |
| picimage |
| plus_signup |
| profileedit |
| readyjob |
| searchpagination |
| tan |
| test |
| test2 |
| testdb |
| testsite |
| upload_image |
| zencart |
+--------------------------+
32 rows in set (0.00 sec)
mysql> create database nokia_man;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| advertise |
| apple |
| blog |
| candidateinterestedfield |
| cms |
| dashboard |
| dgpdoctor |
| dgpemployer |
| dgphospitals |
| dgphotels |
| dgpjobseeker |
| docpen |
| docsmania |
| doctorslogin |
| mysql |
| nokia_man |
| one |
| orange |
| performance_schema |
| phpgang |
| picimage |
| plus_signup |
| profileedit |
| readyjob |
| searchpagination |
| tan |
| test |
| test2 |
| testdb |
| testsite |
| upload_image |
| zencart |
+--------------------------+
33 rows in set (0.00 sec)
mysql> use nokia_man;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> create table nokia_sale(
-> id int(11) NOT NULL AUTO_INCREMENT,
-> DateTime datetime,
-> brand_name varchar(100) NOT NULL,
-> company_founded_by varchar(100) NOT NULL,
-> company_present_CEO varchar(100) NOT NULL,
-> company_established_in varchar(100) NOT NULL,
-> primary key(id)
-> );
Query OK, 0 rows affected (0.23 sec)
mysql> explain nokia_sale;
+------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| DateTime | datetime | YES | | NULL | |
| brand_name | varchar(100) | NO | | NULL | |
| company_founded_by | varchar(100) | NO | | NULL | |
| company_present_CEO | varchar(100) | NO | | NULL | |
| company_established_in | varchar(100) | NO | | NULL | |
+------------------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> select * from nokia_sale;
Empty set (0.00 sec)
mysql> insert into nokia_sale values('1',NOW(),'NOKIA','unknown','unknown','predicted date is 20th june 20130');
Query OK, 1 row affected (0.04 sec)
mysql> select * from nokia_sale;
+----+---------------------+------------+--------------------+---------------------+-----------------------------------+
| id | DateTime | brand_name | company_founded_by | company_present_CEO | company_established_in |
+----+---------------------+------------+--------------------+---------------------+-----------------------------------+
| 1 | 2018-02-13 10:26:34 | NOKIA | unknown | unknown | predicted date is 20th june 20130 |
+----+---------------------+------------+--------------------+---------------------+-----------------------------------+
1 row in set (0.00 sec)
mysql> insert into nokia_ (id,DateTime,brand_name,company_founded_by,company_present_CEO,company_established_in) VALUES('2',NOW(),'NOKIA','Fredrik Idestam, Eduard Polón, Leo Mechelin in Finland','Rajeev Suri','1965');
Query OK, 1 row affected (0.05 sec)
mysql> select * from nokia_sale;
+----+---------------------+------------+---------------------------------------------------------+---------------------+-----------------------------------+
| id | DateTime | brand_name | company_founded_by | company_present_CEO | company_established_in |
+----+---------------------+------------+---------------------------------------------------------+---------------------+-----------------------------------+
| 1 | 2018-02-13 10:26:34 | NOKIA | unknown | unknown | predicted date is 20th june 20130 |
| 2 | 2018-02-13 10:31:18 | NOKIA | Fredrik Idestam, Eduard Polón, Leo Mechelin in Finland | Rajeev Suri | 1965 |
+----+---------------------+------------+---------------------------------------------------------+---------------------+-----------------------------------+
2 rows in set (0.00 sec)

Tables in dashboard database;

1: in phpmyadmin:

2: in mysql cmd:

mysql> show tables;
+----------------------------+
| Tables_in_dashboard |
+----------------------------+
| admindashboardsignup |
| cancer_consultation_form |
| casepaper |
| currentreply |
| date |
| general_consultation_form |
| infoandcasepaper |
| keralaayurvedashram |
| minku |
| replytokeralaayurvedashram |
| tinku |
+----------------------------+
11 rows in set (0.00 sec)

Selection of casepaper in phpmyadmin from database dashboard:

Structure view:

Changing length of comment variable:

Changed length of comment variable from 100 to 3000 characters:

In mysql cmd:

mysql> explain casepaper;
+---------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| DateTime | datetime | NO | | NULL | |
| name | varchar(100) | NO | | NULL | |
| subject | varchar(100) | NO | | NULL | |
| email | varchar(100) | NO | | NULL | |
| contact_number | varchar(100) | NO | | NULL | |
| comment | varchar(100) | NO | | NULL | |
| case_paper_path_one | varchar(100) | NO | | NULL | |
| case_paper_path_two | varchar(100) | NO | | NULL | |
+---------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.09 sec)
mysql> alter table casepaper modify comment varchar(4000);
Query OK, 8 rows affected (0.64 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql> explain casepaper;
+---------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| DateTime | datetime | NO | | NULL | |
| name | varchar(100) | NO | | NULL | |
| subject | varchar(100) | NO | | NULL | |
| email | varchar(100) | NO | | NULL | |
| contact_number | varchar(100) | NO | | NULL | |
| comment | varchar(4000) | YES | | NULL | |
| case_paper_path_one | varchar(100) | NO | | NULL | |
| case_paper_path_two | varchar(100) | NO | | NULL | |
+---------------------+---------------+------+-----+---------+----------------+
9 rows in set (0.03 sec)

Adding column in mysql through cmd:

mysql> select * from currentreply;
+----+------------------------+------------------------------------------------+----------+
| id | client_mail | reply | login_id |
+----+------------------------+------------------------------------------------+----------+
| 1 | rajrocks9211@gmail.com | It's reply from keralaayurvedashram... | 1 |
| 2 | rajrocks9211@gmail.com | It's another reply from keralaayurvedashram... | 1 |
+----+------------------------+------------------------------------------------+----------+
2 rows in set (0.03 sec)
mysql> alter table currentreply add column DateTime DATETIME after id;
Query OK, 0 rows affected (0.89 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from currentreply;
+----+----------+------------------------+------------------------------------------------+----------+
| id | DateTime | client_mail | reply | login_id |
+----+----------+------------------------+------------------------------------------------+----------+
| 1 | NULL | rajrocks9211@gmail.com | It's reply from keralaayurvedashram... | 1 |
| 2 | NULL | rajrocks9211@gmail.com | It's another reply from keralaayurvedashram... | 1 |
+----+----------+------------------------+------------------------------------------------+----------+
2 rows in set (0.00 sec)
mysql> insert into currentreply values('3',NOW(),'raj.ece1731@gmail.com','hello','1');
Query OK, 1 row affected (0.04 sec)
mysql> select * from currentreply;
+----+---------------------+------------------------+------------------------------------------------+----------+
| id | DateTime | client_mail | reply | login_id |
+----+---------------------+------------------------+------------------------------------------------+----------+
| 1 | NULL | rajrocks9211@gmail.com | It's reply from keralaayurvedashram... | 1 |
| 2 | NULL | rajrocks9211@gmail.com | It's another reply from keralaayurvedashram... | 1 |
| 3 | 2018-02-13 14:57:27 |
raj.ece1731@gmail.com | hello | 1 | +----+---------------------+------------------------+------------------------------------------------+----------+
3 rows in set (0.00 sec)
mysql>

More Practices & Case

Indigenous Science & Technology is a platform to provide latest & on going information/project related web development, web apps & software, automation & industries, robotics,drone, missile technology and Yoga Therapies to the new comers in the field of engineering and science.

Note:1) This website is not doing any kind of business. It's just for testing purpose of our skills and technique of social media marketing and SEO/Google ranking. Whatever we do experiment during the development of various kind of websites/web-apps project, we guys use this website just to test our assignment on live server in real time.Currently, we are not intended to make any kind of money and profit with http://www.indoscie.com/

Note:2)If you see any kind of ads over pages then that is nothing but just a way to arrange financial support to maintain the budget of the website.

We are investing and running this website for educational purposes only.If anyone want to get involve in business with us, let me know about your plan and business type," how can we help you?".

We are self motivated young group of engineers equiped with state of art and technology.Our aim is to provide wonderful life to everyone with the help of latest technology, medical equipments, medicine, Yoga therapies/exercises etc.We work on ground to high level of engineering and medical industries.We willing to take any kind of risk in our work of engineering and medical fields which is always in favour of human kind/humanities. As an employee, freelance developer and service provider whatever we earn, some part of that we invest in our projects.We are not looking for any kind of invester from any part of the world.We are neither arrogant nor ego ful people, the only thing is that we show our completed work and demo to our client and get involve in their business, which turns the source of our income.That's the reason we never regret on our failure of project because we are not bounded to pay others if we fail, that saves us from helling and disappointment.

1)Web Development, Web Apps & SEO:

These all are active platform where we are currently working on. We have done lot of project in fields of website development, maintenance and marketing but as a team member & employee of other companies.We have done also a projects on real time user interaction based web apps project. We are currently working on methods and technique to minimize the web downloading time on various media devices, social media marketing, google ranking etc.We are not looking for project as we have already lot of project to be done but we are looking of new web enthusiast, content writer, journlist and photographer who can donate their work to us as we are not well established to pay them for time being. By donating your work we will try to give you a unique identity in form of fame and best creater in your interested fields. But in case of future, if we will be able to make revenue from our this small start up, hopefully definitely we will get in touch with you to rewards your work in from of money and value.We are not doing any promise but just demonstrating hope, desire,faith and our expression to all our supporters.

To know the realm of website and development please visit: What is the guideline for web developer ?

To know how to minimize downloading time of website, please visit:what-is-page-speed-performance-testing ?

Most of the very important business oriented and value added features are free of cost here such as information all about doctors and patient realationsheep on line, job search and job posting, placement of your any kind of business oriented digital advertise etc.

Good news for doctors: Now All the doctors are able to register and provide their consulting/practicing/education information to their patient & client for free of cost such as, educational details, consulting fee, consuting place, consulting timing, contact number and lot of extra activities. Doctors don't have to pay anything to anyone for registering here. Whatever you will provide data about yourself that will be visible to everyone visiting on this website. You have to just visit on tab [ Docs-infosystem ].

To bring free jobs and free advertise place portal, we are working hard.Hopefully, we will allow you guys very soon.

PlaceAdsFree tab is for all business oriented people from zero level to high level of turn over revenue. In simple way any budy can post their advertise for free of cost.They don't have to pay anything to represent your business here.We are working hard to allow you guys to be here very soon.

Continue to web development work...

2)Robotics, Automation, Drone & Electronics:

All these fields are our core fields of engineering. These fields are not on full fledge working platform and still we are setting -up our own lab. Hopefully very soon we will start doing project related to all these fields in near future.