# Mysql query

**URL:** https://forum.kirupa.com/t/mysql-query/11233
**Category:** Uncategorized
**Created:** [January 14, 2003, 11:15am UTC](https://forum.kirupa.com/t/mysql-query/11233 "2003-01-14T11:15:29Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jimw00d](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@jimw00d](https://forum.kirupa.com/u/jimw00d)
#### Post date: [January 14, 2003, 11:15am UTC](https://forum.kirupa.com/t/mysql-query/11233/1 "2003-01-14T11:15:29Z")

</div>

Basically I am having problems inserting an auto\_increment column in my new table. I am not sure of the format but I believe that it’s:

Order INIT(5) UNSIGNED AUTO\_INCREMENT

This would insert a new column right?

But if I try to test the table by manually inserting the information into it and I don’t enter a value for this column it returns an error because the values don’t match the columns in terms of numbers. I thought that auto\_increment was just that.

As I am writing this I am figuring out the problem,

any ideas would be good though

regards

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [January 14, 2003, 4:39pm UTC](https://forum.kirupa.com/t/mysql-query/11233/2 "2003-01-14T16:39:20Z")

</div>

Doing it manually is a pain. I suggest you look up a set of scripts called phpMyAdmin. Makes adding colums deleteing, doing anything imaginable with MySQL a lot simpler.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [January 17, 2003, 10:44pm UTC](https://forum.kirupa.com/t/mysql-query/11233/3 "2003-01-17T22:44:31Z")

</div>

you can download phpMyAdmin from:

> **[Plantar Fasciitis - Personal Health & Prosperity Wizard](http://phpwizard.net/foot/plantar-fasciitis/)**
>
> Do you wake up in the morning with a sharp stabbing pain that erupts in your foot whenever you place it down? If so you are suffering from Plantar Fasciitis
