Ass Hat
Home
News
Events
Bands
Labels
Venues
Pics
MP3s
Radio Show
Reviews
Releases
Buy$tuff
Forum
  Classifieds
  News
  Localband
  Shows
  Show Pics
  Polls
  
  OT Threads
  Other News
  Movies
  VideoGames
  Videos
  TV
  Sports
  Gear
  /r/
  Food
  
  New Thread
  New Poll
Miscellaneous
Links
E-mail
Search
End Ass Hat
login

New site? Maybe some day.
Posting Anonymously login: [Forgotten Password]
returntothepit >> discuss >> [nerd] PHP/MySQL help... by DreamingInExile on Dec 20,2007 6:56pm
Add To All Your Pages!
toggletoggle post by DreamingInExile   at Dec 20,2007 6:56pm
Is it possible in ONE SQL statement to insert data into the table 't1' from database 'db1' by selecting data from another table 't2' in the same database 'db1' where some conditions have to be checked between field's values of table 't2' in database 'db1' and field's values of table 't3' in database 'db2'?



toggletoggle post by the_reverend   at Dec 20,2007 8:07pm
it's possible in mysql 5.1 I believe. there is nothing php-wise in that question.



toggletoggle post by the_reverend   at Dec 20,2007 8:10pm
in mysql 5.x you can do stored proceedure calls. in earlier versions, you can using an insert or update statement and relational columns



toggletoggle post by the_reverend   at Dec 20,2007 8:38pm
if you do it through hp and multiple sql queries, it will take minutes.
through spc's, hours.
through relational dbs, days.



toggletoggle post by DreamingInExile   at Dec 20,2007 8:54pm
well, the PHP comes in as it has to all be done with a web app... I'm starting to stress it. I hate sql for reasons like this



toggletoggle post by the_reverend   at Dec 20,2007 9:01pm
sql is the single greatest part of computer programming right now. mysql, tsql, hsql, mssql and oracle all have their special place in my heart for various reasons. although I perfer mysql cause itzs bleeding edge.besides, if you didn't have sql to use for this, what would you use? dba/flat files?
if you are trying to this all through sql, then php doesn't matter.



toggletoggle post by DreamingInExile   at Dec 20,2007 9:14pm
I like MySQL, it's very handy, especially for web apps, but I was asked if this could be done, via a php web application, and I'm starting to get aggravated about getting it done before the holiday



toggletoggle post by the_reverend   at Dec 20,2007 9:22pm
why? using ph, it should take you a few minutes to do.



toggletoggle post by DreamingInExile   at Dec 20,2007 9:40pm
because I have to write all the crap to auto install the db schema



toggletoggle post by the_reverend   at Dec 20,2007 9:46pm
ok then 15 minutes. php my admin would do all that for you. just export the tablr structures and asome if exists before it.



toggletoggle post by menstrual_sweatpants_disco   at Dec 21,2007 11:40am



Enter a Quick Response (advanced response>>)
Username: (enter in a fake name if you want, login, or new user)SPAM Filter: re-type this (values are 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E, or F)
Message:  b i u  add: url  image  video(?)show icons
remember:skynet is always watching protecting you
[default homepage] [print][12:51:06pm Mar 28,2024
load time 0.02875 secs/12 queries]
[search][refresh page]