Database

What is your question?

Database is a systematic collection of data. Databases support storage and manipulation of data. Database makes easier to find data. For example.. 1. An online telephone directory would definitely use database to store data pertaining to people, phone numbers, other contact details, etc. 2. Library management system, each and every book are arranged according to particular subject or stream wise. Database in terms or computer science called Database Management System(DBMS) Some examples or DBMS MySQl, MS SQL, EXCEL, Oracle etc..

Subjects

Latest Asked Question

Q : UPDATE students_copy SET customer_name = REPLACE(customer_name, 'è', 'e')

45 Likes

Q : Update all values of a column to lowercase

A : see here. UPDATE tableName SET tag = LOWER(tag); fully workable; see also; https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_lower

45 Likes

Q : remove first string from field in mysql

A : here is the code for remove first character from string of column data; UPDATE table1 SET column1 = SUBSTRING_INDEX(column1 , "-",-1);

45 Likes

Q : remove all spaces from the entire column in mysql

A : hi here is code for this UPDATE `t1` SET `col1` = REPLACE(`col1`, ' ', '')

45 Likes

Q : update one column from another column in same table mysql

A : short answer for this query UPDATE table1 set col1 = col2;

45 Likes

Q : insert data from table1 to table2 in sql

A : hi here is code INSERT INTO t2 (col1) SELECT col1 FROM t1; INSERT INTO t2 (col2) SELECT col2 FROM t1;

45 Likes

Database Related Topic's

No topic yet