CODEWITHSUNDEEP
mysqlsqldatabasephpmyadmin
KiaN
KiaN

Reputation: 33

creating table with phpmyadmin

I've got a few question about phpmyadmin table creating sequence

  1. I'm wondering what attribute and index mean in phpmyadmin?
  2. What is collation?? (for example if i want to same numbers, which one should i choose?)
  3. Also a question about null checkbox if i don't want a field to have null values, checking it will make it required or not checking it?
  4. And also what is timestamp in default list box?
  5. What is the 'PARTITION definition' at the end of the table creating page?
  6. And why is there another collation at the end of the table creating list?

i'll be so thankful if someone answers me

Upvotes: 2

Views: 3298

Answers (1)

underscore
underscore

Reputation: 6887

Answers for your questions

1) Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows.Read More

2 ) what-does-collation-mean

3) IF a column is null you can send empty value to it without an error.IF it is NULL and you will send empty value to it it will gave an error.

4) TIMESTAMPS

5) What is the 'PARTITION definition'

Upvotes: 1

Related Questions