<div>
&gt;&gt;What would I change the data type to?<br />
<br />
CREATE TABLE tblInfo (<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID INT NOT NULL AUTO_INCREMENT,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;title VARCHAR(150),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;category VARCHAR(150),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY(ID)<br />
)
</div>


>>What would I change the data type to?

CREATE TABLE tblInfo (
      ID INT NOT NULL AUTO_INCREMENT,
      title VARCHAR(150),
      category VARCHAR(150),
      PRIMARY KEY(ID)
)

<div>
you would then attach the value to your letter header or title
</div>


you would then attach the value to your letter header or title

<div>
I'm not sure I understand. Would that allow me to have the ID be something like a1, a2, a3 etc...?
</div>


I'm not sure I understand. Would that allow me to have the ID be something like a1, a2, a3 etc...?

<div>
<a href="http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html</a>
</div>


http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html [http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html]

<div>
thank you for grade!!!<br />
<br />
;-)
</div>


<div>
<div class="content wysiwyg-content">
How do you prepend and auto increment primary key? I would like to prepend it with a letter. What would I change the data type to?
</div>
</div>


How do you prepend and auto increment primary key? I would like to prepend it with a letter. What would I change the data type to?

Prepend and Auto Increment Primary key?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.