MySQL autonumber
kidz | Posted 7:57am 25. January 2005 Server Time |
In MySQL db, how to make my User_ID autonumber like in MS Access??? |
steven290 | Posted 8:07am 25. January 2005 Server Time |
i usually use a gui to make the dbase - try downloading the trial version of navicat.com then add a new field, make the type bigint, auto increment, primary key
findel | Posted 8:07am 25. January 2005 Server Time |
When viewing the table in Edit mode (in MySQL Control Center), make sure the Data Type of the field is 'int', length should be in the region of 11, and you need to tick the AUTO_INCREMENT box.
findel | Posted 8:09am 25. January 2005 Server Time |
oh yeah (as steven said) and make it the primary key (if thats what you want).
kidz | Posted 8:18am 25. January 2005 Server Time |
yah I'm using the trial version of Navicat.. now trying out.. so does unchecking "Allow Null" have any effect on my table? Can leave decimals blank or not?
steven290 | Posted 8:20am 25. January 2005 Server Time |
you need to leave allow null uncheck for autonumber and i would check for other fields
kidz | Posted 8:24am 25. January 2005 Server Time |
Why i always cannot save my table?
It say..
1064 - You have any error in your SQL Syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255)' not null comment"
, Primary Key (User_ID)
)' at Line 7
steven290 | Posted 8:34am 25. January 2005 Server Time |
double check yourself - make sure the
id field: bigint type, allow null uncheck, auto increment checked primary key checked
all others place a check in allow null and make longtext
steven290 | Posted 8:37am 25. January 2005 Server Time |
you could also click the query button then new query then under sql paste this
create table tablename (id bigint auto_increment primary key, field1 longtext, field2 longtext, field3 longtext)
etc. then just change to what names you want
steven290 | Posted 8:38am 25. January 2005 Server Time |
make sure you hit save > then run the query now go bakc to your table view and doouble click you database > you should now see the new table
steven290 | Posted 8:39am 25. January 2005 Server Time |
go into the chatshop - i can walk you step by step
Woodrow | Posted 6:19am 13. August 2009 Server Time |
Hi Steven. Just came across this and I too am having a few issues, you seem to be clued up in this area, could I trouble you for a little help :) Thanks.
lymanknap | Posted 3:54pm 4. August 2010 Server Time |
MgbMc2 <a href="http://nfjsczsrzbgr.com/">nfjsczsrzbgr</a>, [url=http://qnonwlqoanoc.com/]qnonwlqoanoc[/url], [link=http://szrhbrchzcjh.com/]szrhbrchzcjh[/link], http://ufsltjzawwoq.com/
lymanknap | Posted 2:08pm 5. August 2010 Server Time |
http://www.treatanxietydisorder.net/ mixing xanax and ambien %-( http://www.forget-acne.com/ accutane jpcc http://www.good-bye-anxiety.com/ xanax 2556 http://www.phentermineguide.net/ phentermine =))) http://www.buyxanaxnow.net/ xanax yyzhir
lymanknap | Posted 3:59pm 5. August 2010 Server Time |
http://tramadol911.com/ buy tramadol =-]] http://edpillsonline.net/ cialis :[ http://viagracomparisons.com/ buying viagra 0154
lymanknap | Posted 11:59pm 5. August 2010 Server Time |
aIGcnu <a href="http://jdsljscluted.com/">jdsljscluted</a>, [url=http://uacqyrqfnwlw.com/]uacqyrqfnwlw[/url], [link=http://xgtcokktvdsq.com/]xgtcokktvdsq[/link], http://shhwckmyrldu.com/
lymanknap | Posted 6:35am 6. August 2010 Server Time |
JZtcfH <a href="http://mhuhkvkpicjc.com/">mhuhkvkpicjc</a>, [url=http://fcplpiaprmsa.com/]fcplpiaprmsa[/url], [link=http://kpfuwkbzgvot.com/]kpfuwkbzgvot[/link], http://qrnudmiecrxe.com/
lymanknap | Posted 10:40am 6. August 2010 Server Time |
wxUuci <a href="http://bskgumwmubbv.com/">bskgumwmubbv</a>, [url=http://wlehaljgcnck.com/]wlehaljgcnck[/url], [link=http://gektjlytpwbs.com/]gektjlytpwbs[/link], http://qfsnacneckke.com/
lymanknap | Posted 7:21pm 6. August 2010 Server Time |
http://www.gihberkeley.org/zovirax.html buy zovirax nbb http://www.foodieindenial.com/vytorin.html vytorin 6680 http://www.gihberkeley.org/xenical.html xenical som http://www.gihberkeley.org/celebrex.html buy celebrex icgug
lymanknap | Posted 9:59am 7. August 2010 Server Time |
http://www.wjcrew.org/cheapesthealthinsurance.html cheapest health insurance dyflsf http://www.iphoneobserver.com/cheap-life-insurance.html reassure america life insurance 09631 http://www.nltsecrets.com/ business insurance wofuww http://www.whatsatararrel.com/ new jersey car insurance 16639 http://www.wjcrew.org/ online auto insurance 487219
lymanknap | Posted 5:03am 9. August 2010 Server Time |
http://www.healthinsurancemate.com/ short term health insurance >:-OOO http://www.mega1031.org/ home insurance gtq http://www.getautoinsurancerates.net/ auto insurance 8-( http://www.car-insurance-guide.net/ cheap car insurance 590191
choonchan | Posted 12:55am 9. August 2010 Server Time |
j49mhl <a href="http://avuwnfdktcix.com/">avuwnfdktcix</a>, [url=http://kilsmmoixpgg.com/]kilsmmoixpgg[/url], [link=http://eziverjcssce.com/]eziverjcssce[/link], http://hdssuaxzjuqz.com/
lymanknap | Posted 8:37pm 9. August 2010 Server Time |
http://www.viagra-advice.com buy viagra online 51275 http://www.buydiazepam.net/ buy valium online cheap 7098 http://www.treatanxietydisorder.net/ buy xanax online xzvs http://www.prozacsearch.com/ prozac nation 8-OO
choonchan | Posted 11:31pm 9. August 2010 Server Time |
http://www.tongfeng666.com/lifeinsurance.htm life insurance :-[[ http://www.fimbresforcouncil.com/cheaphomeinsurance.html cheap home insurance :PPP http://www.hotkumquat.com/auto-insurance-rates.html auto insurance quotes teyl http://www.arcataenglishcockers.com/ health insurance quotes dol http://www.karenmartinezforassembly.org/auto_insurance.html auto insurance >:[
choonchan | Posted 10:51pm 10. August 2010 Server Time |
f7l0DT <a href="http://yyrhflwymotc.com/">yyrhflwymotc</a>, [url=http://mefxosahiqkq.com/]mefxosahiqkq[/url], [link=http://jhkcizfpbhxk.com/]jhkcizfpbhxk[/link], http://yinuoyxxsptj.com/
choonchan | Posted 4:47am 11. August 2010 Server Time |
http://www.buycheaphomeinsurance.com/ home owner's insurance lakzw http://www.autosinsurancequotes4u.com/ auto insurance quotes ksdhqv http://www.autosinsurance4u.com/ discount auto insurance 809989 http://www.getlifeinsurancequotes.net/ life insurance 8167 http://www.carinsurancequotes-online.net/ car insurance quotes 328037
choonchan | Posted 3:52pm 13. August 2010 Server Time |
http://www.epiloglaserengraving.com/ health insurance florida hdlhm http://www.sundayonanism.com/cheap_auto_insurance.html eastwood auto insurance 303018 http://www.hiphopstash.com/home-insurance.html in home health care insurance 33502 http://www.ruthie-ackerman.com/ trustmark life insurance 15970
choonchan | Posted 9:54pm 13. August 2010 Server Time |
http://www.itsalltherage.org/cialis.html cialis hrri http://www.cyclingresults.net/ ambien %)) http://www.brain-treatments.net/ phentermine >:-DDD http://www.dsiblogger.com/ get rx for tramadol online amtsm http://www.afrilifetv.com/ to buy propecia gypxw
choonchan | Posted 1:03am 17. August 2010 Server Time |
http://www.tophealthinsurers.com/ temporary health insurance 706 http://www.healthinsurancesearches.com/ health insurance quotes jszwmo http://www.car-insurance-guide.net/ nj car insurance owky http://www.getcheaphealthinsurance.net/ health care insurance qrezzl http://www.getaffordablehealthinsurance.net/ health insurance plans 806592
choonchan | Posted 6:42am 17. August 2010 Server Time |
http://www.ussui.com/ valium 21564 http://www.sbpiura.org/ get online prescription for propecia wsecpj http://www.mediaspecblog.com/ accutane uce http://www.aricoalicioncivicasanisidro.com/ valium xanax bars order cheap 376062
mkaymer | Posted 5:06am 20. August 2010 Server Time |
http://www.maddonnasnashville.com/cialis.php ordering cialis online %-))
mkaymer | Posted 6:15pm 21. August 2010 Server Time |
http://www.randommadnessintorrance.com/accutane.html buy accutane =-] http://www.protectoraceuta.com/valium.html valium online :-))) http://www.protectoraceuta.com/xanax.html xanax =[ http://www.venezuelaesdeportes.com/ accutane buy >:(((
mkaymer | Posted 8:57am 24. August 2010 Server Time |
http://www.controlaxiety.com/ valium 45267 http://www.levitra-meds.net/ levitra agi http://www.pricedmedics.com/ what is phentermine jkll http://www.rxmarket.net/ accutane generic 9287 http://www.myrxweb.net/ phentermine hydrochloride zae
mkaymer | Posted 9:29am 25. August 2010 Server Time |
http://www.eltoromn.com/health_insurance.htm health insurance oxxv http://www.theworryfreelife.com/auto-insurance-quotes.html auto insurance quotes 0612 http://www.theworryfreelife.com/health-insurance-quotes.html new york health insurance zin
Reply to Post MySQL autonumber
|
|
|
