I finally got the database connected but it won't create the table for me.
Can we only create tables at the command line?
$sth = $dbh->prepare (CREATE TABLE test
(first_field CHAR(10),
second_field INT)) or print "Can't create table: " . DBI->errstr;
$sth -> execute($test) or print "Can'
Teresa Raymond wrote:
Hello,
I was wondering if anyone could help me solve this problem. The script
appears not to be connecting to the database. This script prints "Here
we go" but never prints "Database connected". I used the format that the
hosting company supplied.
"DBI:mysql:$database:loc
On Sat, 22 Nov 2003 10:14:38 -0500, Teresa Raymond wrote:
> This script
> prints "Here we go" but never prints "Database connected". I used the
> format that the hosting company supplied.
Teresa,
your script seems fine to me... but you might want to read the documentation
of the auto-f
On Sun, 23 Feb 2003 at 20:09, Ed Sickafus opined:
ES:Server: Linux (RedHat 7.2) Apache 1.3.x
ES:I'm trying to run an introductory exercise out of MySQL Cookbook by Paul
ES:DeBois
ES:Accessing MySQL from a PC via PuTTY to ISP's UNIX
ES:I can get to the mysql> prompt but no further.
[snip]
since yo
I agree with what John Herbold already posted but would add:
This probably has more to do with your hardware up to a point. Running
mysql on a 486 is going to obviously not be as efficient as running it
on a dual sun box, etc.
In a previous position we ran 50 or so databased sites that ranged f
No, I think you will be fine. The RDMBS is designed to handle just that
kind of thing. I do it for several applications at work, Helpdesk, etc. My
hardest hit application inserts about 4K records a day, and I have not had
any problems, and it has been productional for over two years.
If you are
On Thu, 15 Aug 2002 at 16:37, Jim Lundeen opined:
JL:ok, i just setup a new server (redhat 7.3) and my guy says that the
JL:dbd/dbi stuff is configured for perl-to-mysql connectivity, but i get
JL:the following error message in my error log each time i try to run a
JL:script from either the comma
Easy way to check is:
perl -MDBD::mysql -e1
Cheers,
Kevin
On Thu, Aug 15, 2002 at 03:44:23PM -0500, Mike(mickako)Blezien ([EMAIL PROTECTED])
said something similar to:
> Jim Lundeen wrote:
> > ok, i just setup a new server (redhat 7.3) and my guy says that the
> > dbd/dbi stuff is configured f
Jim Lundeen wrote:
> ok, i just setup a new server (redhat 7.3) and my guy says that the
> dbd/dbi stuff is configured for perl-to-mysql connectivity, but i get
> the following error message in my error log each time i try to run a
> script from either the command line or via the browser:
>
> ---
Maureen E Fischer wrote:
> Hello,
> Is there a way of varying the key fields in a where statement? I don't
i would suggest posting your questions on a more appropriate mailing list.
http://www.perl.com/pub/a/language/info/mailing-lists.html
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Hytham Shehab wrote at Fri, 08 Jun 2001 15:10:19 +0200:
> hi all of u,
> i got a simple question, why (1) is valid, however, (2) is not ?!!
> (1) sorting order is explicity typed in the query statement:
> $sth = $dbh->prepare("select student_name from students order by first_name
> asc");
>
Hytham Shehab wrote:
> i did it already flip, but its not yet valid, also it seems to be mentaly
> valid, its not for mysql.
perhaps you should ask your question on a more appropriate list. try
this one:
http://lists.perl.org/showlist.cgi?name=dbi-users
--
To unsubscribe, e-mail: [EMAIL P
fliptop said:
> you're trying to substitute the value twice. try something like this
> instead:
>
> $sort = 'first_name asc';
> $sth = $dbh->prepare("select foo from bar order by ?")
> $sth->execute($sort);
i did it already flip, but its not yet valid, also it seems to be mentaly
valid, its not
Hytham Shehab wrote:
> (2) sorting order is passed as a bind parameter:
> $sort = 'asc';
> $sth = $dbh->prepare("select student_name from students order by first_name
> $sort");
> $sth->execute($sort);
you're trying to substitute the value twice. try something like this
instead:
$sort = 'fir
Hytham Shehab wrote:
> hi all of u,
> all whatta i want is see the exact executed query b4 its execution, i
> mean not like this "select blah from blah when x=? but not ? order by ?", i
> want to see as if u write it in the console of mysql, something like that
> "select blah from blah w
Andrew Rosolino wrote:
> $query = "INSERT INTO browse (username, password)
> VALUES ('Kittyf', '5521f') LIMIT 0, 30 ";
does limit/offset apply to insert statements? see this page for correct
insert syntax:
http://www.mysql.com/doc/I/N/INSERT.html
--
To unsubscribe, e-mail: [EMAIL PROTECTE
Olav Rogall wrote:
>
> Hallo List,
>
> Am Saturday, November 17, 2001 um 3:33:52 AM schriebst Du:
>
> >> > Does anyone know of a good online resource for learning how MySQL works,
> >> > specifically how Perl cooperates with it?
> >> > thanx...
> >>
> >> you can't get much better than the ori
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (_brian_d_foy) wrote:
> > Does anyone know of a good online resource for learning how MySQL works,
> > specifically how Perl cooperates with it?
> > thanx...
>
> you can't get much better than the origianl documentation
On July 1, 2001 01:19 am, Ryan Gralinski wrote:
> I can't find a module to open and read/write to a mySql database, can
> someone help me out?
http://dbi.symbolstone.org/
Derek
[ To help the beginners group work, it is best to 'reply-all' so that the
group gets the complete interchange. ]
I see you have
$SQL="SELECT name,extno,dnis,cli,acd FROM avid_call_db..online_stats_table
WHERE acd > 0";
#
^^ two dots?
$sth = $dbh->prepare($SQL);# prepares the statement
20 matches
Mail list logo
