Soldato
- Joined
- 12 Feb 2006
- Posts
- 17,626
- Location
- Surrey
just a quick question, kind of embarrassed that i have to ask as i'm sure it's very simple but it's something i have never had to do so never found out.
been using laptop over weeked do create databases in mySQl, now i want to copy the databases, just the structure not the information stored in them, across to my pc, how do i do this?
and also one of the fields is an id field which i want to be 3 numbers long, so 101, 333 etc, how can i have auto_increment be 3 characters in length? and if possible allow zeros at the front, so 001, 002 etc doesn't get shortened to 1?
been using laptop over weeked do create databases in mySQl, now i want to copy the databases, just the structure not the information stored in them, across to my pc, how do i do this?
and also one of the fields is an id field which i want to be 3 numbers long, so 101, 333 etc, how can i have auto_increment be 3 characters in length? and if possible allow zeros at the front, so 001, 002 etc doesn't get shortened to 1?