Member of the Month

hi_vis360
December, 2024

Online

Welcome to the Newschoolers forums! You may read the forums as a guest, however you must be a registered member to post. Register to become a member today!

SQL Code Anyone? Help!

profile picture
EASTIE21
Posts: 278 - Karma: 21
Any NS out there familiar with writing the SQL code on Microsoft access? I am in a class for it right now which my advisor lied to me about and said there was no computer code writing or anything similar. Well this statement was greatly false!
Anyways anyone who might be able to give me a hand pm me or something and of course +k if anything helpful is posted.
Apr 20 2011 8:21AM
0 0
profile picture
bermbuster49
Posts: 7445 - Karma: 90
google that shit up, shouldnt be too hard. I dont know much SQL, just how to create querys and execute them and work with the data somewhat. Oh yeah i mainly do that through PHP but i have done a project with SQL in visual basic this semester too
Apr 20 2011 9:28AM
0 0
profile picture
Justo8484
Posts: 3905 - Karma: 205
SELECT [field names go here, separated by commes] FROM [table name] WHERE [field name you want to compare] LIKE/= 'value to compare to field'

That'll spit out, say, all records where 'firstname' = 'John', etc. from there you basically just add on query params, unless you actually have to do joins and whatnot. also check w3schools. it might not be specific to using SQL in access, and is probably for MySQL, but the basics are pretty much the same, and if you're using access, i doubt you're doing anything more than the basics anyway. hope that helps!
Apr 20 2011 12:39PM
0 0
profile picture
EASTIE21
Posts: 278 - Karma: 21
Jea that helps. I know what we are doing is pretty basic its just I have never written anything before. Thanks guys
Apr 20 2011 3:16PM
0 0
profile picture
1337
Posts: 31060 - Karma: 29,346
http://w3schools.com/sql/default.asp
Apr 20 2011 3:58PM
0 0
All times are Eastern (-5)