AUTO_INCREMENT value

--=-SePUGFUqEEp3di1V7Teq
Content-Type: multipart/alternative; boundary="=-6aFCHnAlvWIrlgZB7oBg"


--=-6aFCHnAlvWIrlgZB7oBg
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit


Is there something wrong with this query? Or how do I check for an
error message? The query below works when in phpmyadmin, but not in my
cron job. There has been times when cron jobs have needed a small tweak
to work when they run ok in phpmyadmin, but I am unsure of what is
wrong.

ALTER TABLE `thev4173_verseoftheday`.`verse_of_the_day_email_que`
AUTO_INCREMENT =1

Ron

--






--=-6aFCHnAlvWIrlgZB7oBg
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.2">
</HEAD>
<BODY>
<BR>
Is there something wrong with this query?    Or how do I check for an error message?  The query below works when in phpmyadmin, but not in my cron job.  There has been times when cron jobs have needed a small tweak to work when they run ok in phpmyadmin, but I am unsure of what is wrong.<BR>
<BR>
<TT><FONT COLOR="#1a1a1a">ALTER TABLE `thev4173_verseoftheday`.`verse_of_the_day_email_que`  AUTO_INCREMENT =1</FONT></TT><BR>
<BR>
Ron<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
--
<DIV ALIGN=center></DIV><BR>
<BR>
<DIV ALIGN=center><A HREF="http://www.TheVerseOfTheDay.info"><IMG SRC="cid:1283693999.1922.9.camel [at] localhost.localdomain" ALIGN="bottom" BORDER="0"></A></DIV>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-6aFCHnAlvWIrlgZB7oBg--

--=-SePUGFUqEEp3di1V7Teq--
ron.piggott [ So, 05 September 2010 15:42 ] [ ID #2047239 ]

RE: AUTO_INCREMENT value

I figured it out, the permissions weren't set on the user to allow the
command to work. Ron


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ron.piggott [ So, 05 September 2010 16:51 ] [ ID #2047241 ]
PHP » gmane.comp.php.database » AUTO_INCREMENT value

Vorheriges Thema: Module positioning
Nächstes Thema: Need Help with database output