1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?

Question Posted / abhishek

Answer Posted / abhishek

mysql> select substring('SQUARE ANS ALWAYS WORK HARD',14,6);
+-----------------------------------------------+
| substring('SQUARE ANS ALWAYS WORK HARD',14,6) |
+-----------------------------------------------+
| WAYS W |
+-----------------------------------------------+
1 row in set (0.00 sec)

mysql>

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define database lock?

504

Enlist the types of cursor?

559

Is driver a software?

432

What is mean by dbms?

498

What is the easiest database to learn?

480




What is delimiter in dbms?

481

What is cardinality in db?

511

How rdbms is different from dbms?

490

Is it possible to declare or create a cursor for update of table? If yes tell me how?

469

Explain the functionality of dml compiler.

597

Enlist various transaction phases.

520

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2131

Is a server a database?

495

What is the difference between internal and external schema?

451

Can we linked SharePoint to a SQL databasebe?

589