How do you define a variable in MySql?
Here’s how:
SET @name = "Mike", @twitter = "@mmhan"; /** usage **/ SELECT * FROM `users` WHERE `name` = @name AND `twitter` = @twitter;
The name is
Mike Myat Min Han aka 'mmhan'.
I am a developer, mostly do development on Javascript, PHP and CakePHP alongside some development work on C, C++, Obj-C, C# and AS. I also have a thing for Python.
I post here all sorts of crap that I find worthy of sharing: Quotes, Jokes and Notes.
Here’s how:
SET @name = "Mike", @twitter = "@mmhan"; /** usage **/ SELECT * FROM `users` WHERE `name` = @name AND `twitter` = @twitter;