Jonathan Villa wrote:
Sorry, I meant referenced in another table not database
On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote:
I have several tables I want to delete as well as their reference in
another database
The query produced is this:
==
Gnanavel wrote:
$output=exec("cp file1 file2");
echo "$output";
does not works. can any one help me out of this problem
When I was executing the "cp" command it doesn't return anything.
But it returned the name of the last file when i executed the "ls"
`cp file1 file2` doesn't return anything -
Evan Morris wrote:
Hi all
Say you have two tables, TABLE1 and TABLE2. Each table contains (amongst
others) a field called SOMEVALUE
Now, in TABLE1 SOMEVALUE contains "string1", but in TABLE2 SOMEVALUE
contains "string2".
Now you join these tables (on SOMEOTHERVALUE) and you loop through the
result
Gnanavel wrote:
I have problem in executing linux command
$output=exec("ls -a");
echo "$output";
the above coding works, but
$output=exec("cp file1 file2");
echo "$output";
does not works. can any one help me out of this problem
When I was executing the "cp" command it doesn't return anything.
Mohammad Saadullah wrote:
Hi guys,
I am resending the same query again because still stuck on it.
I have been working in php/oracle for quite some time now but recently
had to shift myself to mysql and I am struggling with a particular query here.
what is the query you would write for oracle ?
FB wrote:
Hi,
I have 3 similar tables. I want to merge them. The thing I use is
1) SELECT *
2) Make a while statement
3) INSERT each raw into the other table
is there a easier way?
FB
if the columsn are identical
insert into table1 select * from table2;
insert into table1 select * from table3;
Snijders, Mark wrote:
hi,
no the both sollutions won't work cause:
I can't sort within a query cause subnetaddr is a varchar ("10.10.10.10")
so it will be ordere like this
10.10.10.10
100.10.10.10
60.10.10.10
and that's not good cause 60 is smaller as 100, so with the function
ip2long() i will
nabil wrote:
Please help me how to print a timestamp string retrived from the database,
and print it as -MM-DD
use the mysql date_format fumction
DATE_FORMAT(date,format)
select date_format(date_field, '%Y-%m-%d') from data;
see the mysql docs for more details
--
Sean
--
PHP Database Mail
Hi,
this problem seems to have appeared after a system upgrade ...
command line works fine
mysql -uschool -pbonfire school
BUT
/* Connecting, selecting database */
$link = mysql_connect("localhost", "school", "bonfire")
or die("Could not connect : " . mysql_error());
print