Technology Innovation

This video explains you about the creating of new database and followed by the implementation of create , update, alter , delete , truncate and drop the table. Creating table with example data by defining the columns and its relevant datatype and the importance of primary key usage and the various methods of performing insert query and usage.

Growing your business goes hand in hand with growing your skill set. With all of the new technology and software available to companies today, it would be foolish for businesses not take advantage of them. When it comes to implementing automation into the workplace, businesses can expect to see an improvement in their business and employees across the board. Automation can benefit your business in multiple ways. From increasing productivity and optimizing your procedures, to allowing employees and employers to learn new skills–automation has a wonderful range of benefits. Here are some ways automation can make you better at your job: Organize Information Faster with Automation Automation services and tools help transfer, maintain, and organize information as fast as possible. When software is used in the workplace, businesses can rest assured that their data will be perfectly protected, free from any human error. All of the information that your business works through ...

Whenever you want to delete a particular row from a parent table, usually a database engine checks whether this parent data primary key value refers to any child table data. For Example, Table: user id login_Id user_Name 1 demo001 Note 2 demo002 Book Table: userAddress id user_id Country State 1 1 India Himachal Pradesh 2 2 India Tamil Nadu Primary Key Foreign Key Table UserAddress has “ user_id ” is a foreign key reference from Table User. So User Table is Parent Table and UserAddress Table is Child Table If you are try to delete any data in child table then you might be not facing an error but if you try to delete any data in parent table then you will face problem “ Cannot delete or update a parent row: a foreign key constraint fails ” because parent table data is referencing to child table. Execute this Query SET FORE...

Database is used to store the information in a perfect manner so that it can be easily manage the data and can be easily retrieved by filtering it with the help queries. There are two type of database 1. Relational Database - Human relations like parents and child 2. Flat Database          - Stores on hard disks like text files. What is Mysql Database? Mysql Database is a relational database, open source ( free of cost ) and its most popular database that can be used for web application and can be used for dynamic server side application.

Where Syntax in Select Query can be used to filter the data from database.Suppose if you have 100 of data with different gender like male and female but you want the data of all male what you can do? Simply use mysql select query with where condition to filter the data from table. Example Table : For your reference table_name Column_name1 Column_name2 Column_name3 Column_name4 1 Male articles Sam 2 Female database Sam 3 Male coding Jam 4 Male coding Kam 5 Female coding Jam Table Name is : table_name Query : "SELECT * from table_name WHERE Column_name2='Male'" If you execute the above query then all female records will disappears from the table data ...

If you have same data on the database table and you want to avoid duplication in your query result then you can use distinct word in mysql query to avoid duplication. Example Table : For your reference table_name Column_name1 Column_name2 Column_name3 Column_name4 1 Tech articles Sam 2 Mysql database Sam 3 Java coding Jam 4 J2ee coding Kam 5 Hibernate coding Jam Table Name is : table_name The table table_name contains four column data but the column_name4 has 2 sam and 2 Jam but i want  to avoid sam and Jam with single results. Query : "SELECT  DISTINCT Column_name4 from table_name" If you execute the above query then the duplicate data from Column_name4 will be filtered. table_name Column_name4 Sam Jam Kam

Select Query in MySQL is used to select data from a database tables. Select Query can be performed with single column, multiple column and all column Example Table : For your reference table_name Column_name1 Column_name2 Column_name3 Column_name4 1 Tech articles Sam 2 Mysql database Sam 3 Java coding Jam 4 J2ee coding Kam 5 Hibernate coding Jam Table Name is : table_name Default Syntax for SELECT Query in Mysql  Query : " Select column_name1 from table_name" If you execute the above query then the above table data will be displayed only column_name1 table_name Column_name1 1 2 3 4 5 Query : " Select  column_name1,   column_name3  from  table_name" If you execute the above query then the above table data will display column_name1 and column_name3 table_name Column_name1 Column_n...

Learn how you can create a database that supports Multi languate or UTF-8. Whenever you create a database or table by default it will create the characterset to latin1 which is only supports english character and for other non english character it wont support. To support multilingual you need set UTF-8 character set to all your table and database. Go to your schema or database properties and change the collation or charset to UTF-8 or Alter database databasename charset=utf8; Go to your table properties and alter the collation or charset to UTF-8 or Alter table tablename charset=utf8; Alter table tablename alter column columnname charset=utf=8; After altering all table now you can able to insert any format of data without being corrupted. That's It...