.
Please let me know how to install Mysql and PHP machine. Please advice the
necessary steps for the installation.
With Warm Regards
Harpreet Singh Chana
Phone : @ 4326
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi mysql list members,
Is it possible to reboot the linux server through a PHP page. Like a client
clicking on a button in a php page and that would result in rebooting the
linux server.
Can this be done?? Pls help,
Regards,
Harpreet Kaur
a and b r not tables but views. i am using multiple views .
The sql for the views are as follows:
CREATE view cch_dubber_dublist_view_a1 as select distinct
a.playlist,a.material_id,a.destination_locator,a.destination,a.air_time,a.traffic_duration,a.comment,a.title,a.device_name,m.media_locator
. The time it takes is 18 seconds.
My boss wants it to run in 4-5 seconds. If the number of records r more like
4-5000 then it takes even longer. How can i reduce the time even further.
Can i index the tables or nething will that help.
Help is greatly appreciated.
Thanks,
Regards
Harpreet Kaur
How can i set the default values of a datetime field in a mysql table as the
current date.
I am trying
alter table copy_tbl add create_date datetime default now() but it does not
work.
Please help.
Regards,
Harpreet Kaur
_
MSN
server through socket 'var/lib/mysql/mysql.soc
(2)
What is wrong. Please help.
Regards,
Harpreet kaur
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
The mysql is working now and i can get into it. But when i type
mysql databasename /home/backup/backup_databasename.sql
To restore a database do i need to have the database created first.
i get an error message
error 1044: access denied for user @localhost to database databasename
If i log
Dont worry. It worked. Yes i was supposed to create the database before
using the restore command as it couldnt find the database.
Thanks neways,
Regards,
Harpreet kaur
From: Harpreet Kaur [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: mysqldump
Date: Tue, 23 Apr 2002 16:08:23 +
a browser.
But nothing is happening no matter what i cange in mycron.txt file.
Help is appreciated . please refer me to a tutorial where i can start form
scratch as this is my first cron job.
my mycron.txt file has the following one single line.
* * * * * /home/harpreet/crontest.php
I have
i going wrong? I saved the above line in a text file and put in my
home directory.
Please help.
Regards,
Harpreet
mysql cron help
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
the tables except this one table which has
description field with several lines. It assumes each line as a seperate
field rather then one field and so create errors.
Please help.
Regards Harpreet
_
Get your FREE download of MSN Explorer
,
regards, Harpreet
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
Before posting, please check:
http://www.mysql.com
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative
that would work?
select * from lib_asset_tbl where material_id '' and asset_id in (select
asset_id from lib_copy_tbl)
Help is appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc
where dev_device_view and cch_playlist_views are sql statements joining 2
tables using an inner join.
Help is appreciated,
regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-
Before posting, please check
. And
when i type in
mysql select * from user;
i get error message:
Select command denied to user 'root@localhost' for table 'user'
Where did i go wrong .. please help...
i get the same error message when i try to use ne other database even the
one i created just now.
Regards,
Harpreet Kaur
Software
,update, delete,create,drop, reload, shutdown,process,
file,alter on *.* to 'root'@'localhost' with grant option
Help is greatly appreciated,
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
lib_asset_tbl b on a.parent_id=b.asset_id
union
select asset_id,material_id,'' from lib_asset_tbl where virtual_flag='N'
Help is appreciated,
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-
Before posting, please
lib_asset_tbl b on a.parent_id=b.asset_id
union
select asset_id,material_id,'' from lib_asset_tbl where virtual_flag='N'
Help is appreciated,
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-
Before posting, please
I am using version 3.23 and dont think will be moving up to 4.0. Can i
somehow create a temporary table and add all the rows i need and do a select
query from that temp table. Neone done this before.
Thanks for ur responses and time,
Regards,
Harpreet Kaur
Software Developer
Crispin
Can we create a php page that will use mssql_connect to connect to ms sql
server get the data and then use mysql_connect and connect to mysql server
and populate the table.
Is this possible.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-Original Message-
From
for making it clear. I
am still glad I joined the group as Will's post did help a lot.
Neways cheer up everybody and yes i do agree 'be nice to people' - it will
not only help others but ur own self.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
mysql
);
$total_rows = mysql_numrows($result);
echo $total_rows;
?
/BODY
/HTML
Error message:
Warning: MySQL Connection Failed: Access denied for user:
'testing@localhost' (Using password: YES) in /var/www/html/contact.php on
line 8
Please help.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc
the files but i cant move
the files to it. It can be done from the linux server but i cant do them
myself from my computer. What am i missing?? like i can got from /var/www/
and then when i click on html folder it gives me error message permisiion
denied.
Help will be apppreciated,
Regards,
Harpreet
new to mysql and linux and am still testing
different things.
And thanks for ur help.
regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re
browser but cannot transfer any new files.
I am sure i am missing somewhere here also. Help is greatly appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-Original Message-
From: Deepanshu Shukla [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 1
please help and let me know what am i missing.
An early response will be appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-
Before posting, please check:
http://www.mysql.com/manual.php
26 matches
Mail list logo