MySQL

What is your question?

* MySQL is a database management system.<xmp> <xmp>* A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.

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

MySQL Related Topic's

No topic yet