mysql> select substring('SQUARE ANS ALWAYS WORK HARD',14,6);

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

Question Posted / abhishek

3 Answers
19178 Views
Citrix, SAP Labs, I also Faced
E-Mail Answers

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

What database does facebook use?

898

What is concurrency control?

920

What is the normal procedure followed by a java client to access the db?

779

Is database a storage?

842

How do you notify dbpak about stored procedure?

845

Define entity set.

854

What do you mean by cardinality and its types?

881

Enlist the cursor types.

981

Describe concurrency control.

973

What is the first step in creating a database?

829

What are the types of model?

820

What are the two types of data independence?

1007

In DBMS, what are the two integrity rules used?

886

Describe the four types of indexes.

1004

What are the benefits of modeling?

971