HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Search
-
Re: A few Sql questions - anyone care to help!
Auto-increment is only set on a primary key, so you'd just use: ->PrimaryKey('WhateverID') Truncate is just a method on the SQL object you can call like Insert or any other. Just pass the tablename. You alter a table by redefining it with Structure. There isn't a native function in Vanilla for on duplicate key update so… -
A few Sql questions - anyone care to help!
Is there a way in vanilla 2.1 to set a Column to Autoincrement ->Column('SampleID', 'int(11)', False, 'key','auto_increment') or ->Column('SampleID', 'int(11)', False, 'key', TRUE) with item after key being autoincrement. it doesn't seem so. if not how does an ALTER in vanilla jargon. Also how does one do a TRUNCATE in…
2 results