Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook"
at the command line in mysql heres what i type but i get a error
mysql>create table guestbook
->(
-> name varchar(40) null.
-> url varchar(40) null.
-> comments ... (3 Replies)
(sorry for my english)
Hi, i have an app that uses MYSQL API C.. i trying do a timeout until the table is locked by an other thread , in the docs of Mysql i can see that MYSQL_OPT_READ_TIMEOUT is not implemented for linux ¿?¿?.. any body knows a way to do a timeout until the table is locked by... (0 Replies)
Everybody,
can you tell me how express about this; we have text data file as :
parameter1 Parameter2
AA 55
BB 77
. .
. .
. .
We want to draw table for this data as attached then send as body of Email (4 Replies)
I'm having trouble with this code.
if i do
.\read.pl -u user
it prints out
2010-12-20 12:00:00 host1 <cmd>a
2010-12-20 12:00:01 host1 <cmd> <execute>
2010-12-20 12:00:02 host1 <cmd>b
2010-12-20 12:00:03 host1 <cmd>c
however, if i enter
.\read.pl -h host1
it should... (3 Replies)
I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening?... (0 Replies)
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
I have a MYSQL table with demographic data. The addresses contained in the table were entered manually before the advent of online postcode lookup software and, hence, there are a lot of errors when using automated online mailing checking software. I plan to export the data as csv file for a 3rd... (1 Reply)
Discussion started by: barrydocks
1 Replies
LEARN ABOUT PHP
wincache_refresh_if_changed
WINCACHE_REFRESH_IF_CHANGED(3) 1 WINCACHE_REFRESH_IF_CHANGED(3)wincache_refresh_if_changed - Refreshes the cache entries for the cached filesSYNOPSIS
bool wincache_refresh_if_changed ([array $files = NULL])
DESCRIPTION
Refreshes the cache entries for the files, whose names were passed in the input argument. If no argument is specified then refreshes all
the entries in the cache.
PARAMETERS
o $files
- An array of file names for files that need to be refreshed. An absolute or relative file paths can be used.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
WinCache performs regular checks on the cached files to ensure that if any file has changed then the corresponding entry in the cache is
updated. By default this check is performed every 30 seconds. If, for example, a PHP script updates another PHP script where the applica-
tion's configuration settings are stored, then it may happen that after the configuration settings have been saved to a file, the applica-
tion is still using old settings for some time until the cache is refreshed. In those cases it may be preferrable to refresh the cache
right after the file has been changed. The following example shows how this can be done.
Example #1
A wincache_refresh_if_changed(3) example
<?php
$filename = 'C:inetpubwwwrootconfig.php';
$handle = fopen($filename, 'w+');
if ($handle === FALSE) die('Failed to open file '.$filename.' for writing');
fwrite($handle, '<?php $setting=something; ?>');
fclose($handle);
wincache_refresh_if_changed(array($filename));
?>
SEE ALSO wincache_fcache_fileinfo(3), wincache_fcache_meminfo(3), wincache_ocache_fileinfo(3), wincache_ocache_meminfo(3), wincache_rplist_file-
info(3), wincache_rplist_meminfo(3), wincache_ucache_meminfo(3), wincache_ucache_info(3).
PHP Documentation Group WINCACHE_REFRESH_IF_CHANGED(3)