Give the user show view permission
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_show-view
On 06/06/2011 7:57 AM, Ron Piggott ron.pigg...@actsministries.org wrote:
I created a VIEW “table” yesterday. Last night when the cron job ran to
back up the database I received this
Have a look at this:
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_char-length
On Thu, Mar 10, 2011 at 9:49 AM, Ron Piggott ron.pigg...@actsministries.org
wrote:
Is there a command in mySQL that would allow me to SELECT the rows where
the `fax` column is more than 11
Try increasing this: PDO::MYSQL_ATTR_MAX_BUFFER_SIZE
More info here: http://php.net/manual/en/ref.pdo-mysql.php
On Thu, Jan 13, 2011 at 7:23 PM, Karsten Lehmann lehm...@maqsima.de wrote:
Hello
I try to read a 2000 character long string out of database. The database is
an oracle 10g Express
Read through this:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html, especially
the last 2 paragraphs.
On Sun, Nov 28, 2010 at 12:40 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE
`name` = '$name'”
Hi Ethan,
Database Creation: http://www.php.net/manual/en/function.mysql-create-db.php
http://www.php.net/manual/en/function.mysql-create-db.phpAdding Tables,
Extract Data: http://www.freewebmasterhelp.com/tutorials/phpmysql/1
http://www.freewebmasterhelp.com/tutorials/phpmysql/1Explore the
Have a look at this: https://developer.mozilla.org/en/DOM/window.onunload
https://developer.mozilla.org/en/DOM/window.onunloadBut, as someone
pointed out a few days ago, please do not post stuff that is not related to
PHP DB.
On Thu, Aug 26, 2010 at 6:32 AM, Vinay Kannan viny...@gmail.com wrote:
Try:
DATE(date_accessed) = CURDATE().
Have a look at this:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dateto
understand what's happening.
Regards,
Kesavan.
On 17/08/2010 6:26 AM, Ron Piggott ron.pigg...@actsministries.org wrote:
I am wondering why:
SELECT *
take a look at this:
http://datatables.net/examples/data_sources/server_side.html
On Mon, May 17, 2010 at 5:30 PM, nagendra prasad
nagendra802...@gmail.comwrote:
Hi Artur,
I am a beginner to this stuff. So, If you or anyone can give me some
example
codes or may be some links for my
You need to use the ALTER statement.
doc: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
http://dev.mysql.com/doc/refman/5.1/en/alter-table.htmlexample:
http://www.1keydata.com/sql/sql-foreign-key.html
On Wed, May 5, 2010 at 8:21 AM, Karl DeSaulniers k...@designdrumm.comwrote:
Hi,
I
http://www.javascriptkit.com/script/cut18.shtml
JS based solution would be the easiest.
On Wed, Mar 17, 2010 at 3:07 PM, Karl DeSaulniers k...@designdrumm.comwrote:
Hello,
I have been asked to see if I can set up an online calculator.
I was wondering if anyone had some pointers on where I
Well, you can always backup your databases through phpMyAdmin (export) or
from commandline using mysqldump just to be on the safer side.
On Sat, Mar 6, 2010 at 12:51 PM, David McGlone da...@dmcentral.net wrote:
On Friday 05 March 2010 12:35:43 Vinay Kannan wrote:
Hello,
I am currently
Remove the quotes around the variables in all your statements.
For example, this statement:
mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin',
sha1('$password'), '$email');
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
Why don't using consider using PDO for this purpose? Examples can be found
here: http://au.php.net/manual/en/pdo.prepare.php
On Sun, Jul 12, 2009 at 2:52 PM, Daniel Brown danbr...@php.net wrote:
[Redirected to PHP-DB: php...@lists.php.net]
On Sun, Jul 12, 2009 at 00:31, Jason
there is probably a better way to achieve this, but, this is a quick
solution
mysql SELECT * FROM test where sallary IN (SELECT MAX(SALLARY) FROM test
GROUP BY company);
+++---+-+
| id | name | company | sallary |
+++---+-+
| 2 | Peter
drop the images into a folder within your WAMP servers htdocs
directory and then update your database tables with the new location..
for security reasons you will not be able access files outside your
web directory through PHP
On Sun, Mar 8, 2009 at 11:34 AM, Sashikanth Gurram sashi...@vt.edu
yup, I have set the |PDO::ATTR_ERRMODE| attribute to
|PDO::ERRMODE_EXCEPTION|
and I am still not getting an exception!
My Code is something like this:
$query = $db-prepare($sql);
$query-execute($bind);
$row = $query-fetch(PDO::FETCH_ASSOC);
wher $db is the PDO obj and
I am sorry, setting |PDO::ATTR_ERRMODE| attribute to
|PDO::ERRMODE_EXCEPTION| *does* throw an Exception when the table cannot be
found. Stupid me; I was trying to catch Exception rather than a
PDOException.
On Sun, Mar 8, 2009 at 6:03 PM, kesavan trichy rengarajan k...@trk7.comwrote:
yup, I
17 matches
Mail list logo
