|
New site? Maybe some day.
|
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'? |
|
it's possible in mysql 5.1 I believe. there is nothing php-wise in that question. |
|
in mysql 5.x you can do stored proceedure calls. in earlier versions, you can using an insert or update statement and relational columns |
|
if you do it through hp and multiple sql queries, it will take minutes.
through spc's, hours.
through relational dbs, days. |
|
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
|
|
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. |
|
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 |
|
why? using ph, it should take you a few minutes to do. |
|
because I have to write all the crap to auto install the db schema |
|
ok then 15 minutes. php my admin would do all that for you. just export the tablr structures and asome if exists before it. |
[default homepage]
|
[print][ | 9:49:02am May 04,2024 load time 0.03487 secs/12 queries] | [search] | [refresh page] |
|