2

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

Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
KiaN
  • 33
  • 2
  • 8

1 Answers1

1

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'

Community
  • 1
  • 1
underscore
  • 6,495
  • 6
  • 39
  • 78
  • i just don't get it i wanna create a table but it's just sending this error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BINARY NOT NULL, `userdescription` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bi' at line 1 – KiaN Apr 27 '14 at 08:16