Answer Posted / ramya

Two type of indexing
Spatial indexes (created using SPATIAL INDEX):
1.Available only for MyISAM tables. Specifying a
SPATIAL INDEX for other storage engines results in an error.
2.Indexed columns must be NOT NULL.
3.In MySQL 5.0, the full width of each column is
indexed by default, but column prefix lengths are allowed.
However, as of MySQL 5.0.40, the length is not displayed in
SHOW CREATE TABLE output. mysqldump uses that statement. As
of that version, if a table with SPATIAL indexes containing
prefixed columns is dumped and reloaded, the index is
created with no prefixes. (The full column width of each
column is indexed.)

Nonspatial indexes (created with INDEX, UNIQUE, or PRIMARY KEY):
1.Allowed for any storage engine that supports spatial
columns except ARCHIVE.
2.Columns can be NULL unless the index is a primary key.
3.For each spatial column in a non-SPATIAL index except
POINT columns, a column prefix length must be specified.
(This is the same requirement as for indexed BLOB columns.)
The prefix length is given in bytes.
4.The index type for a non-SPATIAL index depends on the
storage engine. Currently, B-tree is used.

Do you know what is the use of rand() in php?

937

---

Do you know what is the function func_num_args() used for?

973

---

How is it possible to know the number of rows returned in the result set?

1068

---

What is the use of strpos in php?

991

---

What is the difference between implode() and explode() in php?

955

---

How do sessions work in php?

939

---

What is http get and post?

973

---

How to uploaded files to a table?

943

---

Tell me what is the definition of a session?

973

---

What is a static method php?

956

---

How can we change the maximum size of the files to be uploaded?

966

---

Explain php parameterized functions.

934

---

What are the array functions in php?

920

---

Is php 5.6 secure?

921

---

What is difference between mysqli and mysql?

1004

---