I finally got the following few lines of code to work:
$userdb=$feilds{'user'};
$rows=$dbh-do
(INSERT INTO bandbook (user, ect, ect, ...)
VALUES(?,?,?,?,?,?,?), undef, $userdb,
'ect', 'ect', )
|| die fucked up inserting data: $DBI::errstr;
print $rows row(s) added to
Under Description of MySQL regular expression syntax, the manual says:
This is a simplistic reference that skips the details. To get more exact
information, see Henry Spencer's regex(7) manual page that is included
in the source distribution.
Can anyone recommend any gui tools that would help during the normalisation
proccess.
kind regards
Paul
Thanks to paul DuBois for his excellent book MySQL
-
Before posting, please check:
http://www.mysql.com/manual.php
Description:
After doing scripts/mysql_install_db I get errors
/usr/bin/mysqdl_safe: line 278: 2759 Illegal instruction
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
--datadir=$DATADIR $USEROPTION --pid-file=$pid_file --skip-locking
$err_log 21
011104
NatureHi,
How can I modify safe_mysqld to make it email me if the mysql server
fails/shuts down for some reason please?
regards, Graham Nichols.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
well. for now it can only be one contact and one address per
customer. the thing
is though, that also other people can have addresses and contacts. so
for example
there will be a user table or something like that. and a user will also have
address and contact information.
would you still
Uriel Wittenberg writes:
Carl, I appreciate your response, but I did check both the table of
contents and the index. I did not do a string search on update, if
that's what you had in mind.
I admit that the search function is as good as one might wish. And
I agree that finding things in the
Hi,
I am trying version 4 with myIsam tables. (I am almost
ready to move to some
other hopefully safer type ). The problem is I get
table
corruption.
I have a large database(21000 tables, but
the whole /var/lib/mysql/mydatabase directory is less
than 800MB) database. I know this is
Hi all,
Do anyone have this experience before?? I have granted the permission
for a machine to access mysql databases several times and then flush
privileges. I use perl DBI module to connect to databases through Web.
But I found that after a day or even several hours later. I found that
the
Description:
I've tried to install MySQL-2.23.37 on LinuxPPC dr4 (not a recent
distribution, I know that...), from the source code (mysql-3.23.37.tar.gz).
unzip of the file was successfull, configuration and compilation seem to
have worked fine, but the installation of the grant tables failed,
I'm trying to create at table that inserts a default value into a field if
nothing is supplied. If in interpret the documentation correctly this should
be accomplished by something like this:
CREATE TABLE Location (LocationID VARCHAR(10) NOT NULL PRIMARY KEY, Name
VARCHAR(50), Address1
On Sun, 2001-11-04 at 13:52, Chris Williams wrote:
I'm trying to create at table that inserts a default value into a field if
nothing is supplied. If in interpret the documentation correctly this should
be accomplished by something like this:
CREATE TABLE Location (LocationID VARCHAR(10)
Oh! Ok. Thanx! Although I didn't really want to do all of that, I guess
it's the only way. Unless someone has something better.
- Deryck Henson
- http://www.sourcecodecafe.com
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: Deryck Henson [EMAIL
i have a table with and ID column that auto_increment with that
following content
++--+++
| ID | JokeText | JokeDate | AuthorName |
++--+++
| 1 | what's up? | 2001-11-04 | duraid |
| 2 | duraid |
I have a SQL statement that I use to grab movie profiles. When I constructed
the input form, I decided I didn't want to use blank entries for tables that
didn't have a entry for that particular film e.g. a poster wasn't available
for sale.
This SQL statement in PHP works fine when EVERY table
I have a SQL statement that I use to grab movie profiles. When I
constructed
the input form, I decided I didn't want to use blank entries for
tables that
didn't have a entry for that particular film e.g. a poster wasn't
available
for sale.
This SQL statement in PHP works fine when
Is anyone using ZEOS and Delphi with MySQL w/InoDB? I am wondering how
the transaction stuff runs or if it even works with this combination.
Many Thanks
M;)
MySQL database sql
-
Before posting, please check:
Hi,
When doing an Alter Table, what does state
Repair with keycache
Mean, and should it take 27 hours (so far) on a 26,000,000 record table.
And another issue: When searching the archives, I'll get something like
4. Re: Repair with keycache
Thanks for your pointer. This SQL statement ended up working:
Thanks for your pointer! This ended up working for me:
SELECT * FROM profiles
LEFT JOIN allposters ON (profiles.titlesid = allposters.titlesid)
LEFT JOIN officialsites ON (profiles.titlesid = officialsites.titlesid)
LEFT JOIN titles
I suggest a few things. First, set it to NOT NULL DEFAULT 1, and then set
the value explicitly to null, which will cause it to use the default value.
The problem with inserting '' is that its casting to an integer and mysql
decides that '' should be 0. Or try using : insert into table (column1,
Hi there,
I have been attempting to use mysqlhotcopy to make a backup
copy of all of the databases on a server. It wasn't completely
self-evident from the Mysql manual how best to do this, so I
tried the following:
mysqlhotcopy -u blah -p blah --regexp=.* --flushlog /blah/blah/blah/destdir
Hello,
Can anyone help me? I want to use MySQL locally.
My PC has no networkcard and no modem.
I want to access my database located in my PC what should I
do? I am using Visual Basic and ODBC.
What should I set so that I would not need to
On Sun, Nov 04, 2001 at 08:07:36PM -0800, Matthew Clegg wrote:
Hi there,
I have been attempting to use mysqlhotcopy to make a backup copy of
all of the databases on a server. It wasn't completely self-evident
from the Mysql manual how best to do this, so I tried the following:
[snip]
Is there any support for XML export from MySQL databases?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Hello All.
*disclaimer*
I'm blond. I'm a linux newbie. I've searched the mailinglist/newsgroup
archives.
*end disclaimer*
I'm trying / wanting to install mysql++ on my MANDRAKE 8.1 LINUX
MACHINE.
That means i'm running GCC/G++ VERSION 3.0.1
Could someone please be kind to explain IN DUMB
My deepest appologies folks.
I posted this to the wrong mailing list.
Sorry for the spam. *bows low*
I will now post this to the correct mailing list [[EMAIL PROTECTED]]
Terribly sorry.
-PK-
[Filter bypass keywords: database,sql,query,table ;) ]
¿ÿ^:ô[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
At 4:26 PM -0500 11/4/01, duraid wrote:
i have a table with and ID column that auto_increment with that
following content
++--+++
| ID | JokeText | JokeDate | AuthorName |
++--+++
| 1 | what's up? |
At 10:16 PM -0800 11/4/01, Philip Hernandez wrote:
Is there any support for XML export from MySQL databases?
No, but you can do this relatively easily from within a program,
e.g., using the XML::Generator::DBI Perl module.
-
On Sun, Nov 04, 2001 at 10:49:55PM -0600, Paul DuBois wrote:
At 10:16 PM -0800 11/4/01, Philip Hernandez wrote:
Is there any support for XML export from MySQL databases?
No, but you can do this relatively easily from within a program,
e.g., using the XML::Generator::DBI Perl module.
The
On Sat, Nov 03, 2001 at 07:40:02PM +, Alex Kirk wrote:
I forgot to mention one very important thing: this error cropped up
after I edited
/usr/local/libdata/perl5/site_perl/i386-openbsd/DBI.pm to use DBI
version 1.20 instead of 1.15 (apparently, this file was not updated
after I
On Mon, Oct 29, 2001 at 04:06:39PM -0300, Webmaster wrote:
Hi all;
i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE,
when I execute a make
i get an error make: no target to make.
Thanks and have a great day!
I guess you haven't run the configure script.
On Sun, Nov 04, 2001 at 09:06:02PM -0400, Corey Kaye wrote:
This is my Perl script. I though that adding $query-finish would
unlock the table but it didn't. It looks like the only way around
this is to connect/disconnect from the DB between each update. All
that connecting/disconnecting i
On Sun, Nov 04, 2001 at 01:06:27AM +0100, florian wrote:
im storing pretty big amounts of customer data in a mysql databases.
its about 2 million rows. what im wondering about now is, how does
mysql perform joins on such amounts of data?
i was planning to split the info in at least 3
On Fri, Nov 02, 2001 at 03:37:53PM -0800, another oracle dba wrote:
Hi.
I have a query which completes in about 9 sec when executed alone,
but the time grows dramatically when I execute several similar
queries at the same time. If I execute 3 queries the time grows to
27-40sec, for 5
Hi John Kelly,
This is not a perfect solution but may be useful to you. But still with two
queries!
From Mysql prompt issue these two queries.
SELECT @maxcat := max(Category) FROM table
WHERE category = 'Sports:Football:Players' OR
category = 'Sports:Football' OR category = 'Sports';
Select
On Sat, Nov 03, 2001 at 12:07:03AM +, Manjeet Singh wrote:
Hi Group,
I am new to mysql, and would like you all to give some time in
resolving my trouble. I am stuck up with a problem of designing
stores database for a big company.The company is located in
different places and wants
On Fri, Nov 02, 2001 at 03:07:42PM +0600, Ershad Shafi Chowdhury wrote:
Hi! Has anyone experienced a replication server to miss updates? Our
master is running Mysql 3.23.33 on RH 6.1 Kernel 2.2.12-20 and the
slave is running 3.23.24 on Solaris 2.5.1 Normally Inserts and
updates occur on the
Hello
I am trying to get a mysql client working in windows, and have a few
questions I would like to ask. My environment is this: I am using the
Borland command-line tools, version 5.5, and am currently running Windows
98, but would obviously like the client to work on all(!!) flavours of
Hi friends,
I am a system administrator.
I am from China:)
We want to build a big system with Mysql for authortication,But we don't know how to
establish cluster for Mysql,
Could you help me please and tell me what we must to do!
Waiting for your answer and thanks very much!
WeiMing.Li
40 matches
Mail list logo