I am having the same problem.
This Query:
SELECT 'haystack needle haystack' LIKE concat('%', 'needle', '%')
returns 1
However, this query does not work correctly If you generalize is to
include a database column:
SELECT * FROM MyTable WHERE 'haystack needle haystack' LIKE CONCAT('%',
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jeff Kilbride [EMAIL PROTECTED]
Cc: Lopez David E-r9374c [EMAIL PROTECTED]; 'DeepBlue'
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 10:05 PM
Subject: Re: Memory Leak
On Fri, Mar 28, 2003 at 10:46:52AM
On Saturday, March 29, 2003, at 07:41 AM, Trevor Smith wrote:
2. your syntax just seems wrong. This should be:
SELECT * FROM MyTable WHERE NeedleColumn LIKE '%needle%';
to search for the string 'needle' anywhere in NeedleColumn, if that's
what you were looking for.
I'm jumping in mid-stream so
configurations. These are only a general reference, but should give you a
good starting point. I agree with David, though, in that your key_buffer
size is way too low.
Thanks,
--jeff
- Original Message -
From: Lopez David E-r9374c [EMAIL PROTECTED]
To: 'DeepBlue' [EMAIL PROTECTED]; [EMAIL PROTECTED
What's your log say?
Should be in /var/lib/mysql/hostname.err
-jeff
On Fri, 2003-03-28 at 18:32, Joseph Bannon wrote:
I installed mysql 4 today and ran mysqld_safe. Here is
what I get back...
[EMAIL PROTECTED] admin]# Starting mysqld daemon with
databases from /var/lib/mysql
030328 05
mysql user, but that's out of my experience.
-jeff
On Thu, 2003-03-27 at 05:55, sunil sharma wrote:
Hello friends
I am using mysql on Suse linux 7.1
my mysql data partition is of on reiserfs filesystem.
Can anybody tell me, How i can resitrict database
size?
Is their any possibility
It's also interesting to note that it's possible to split innodb data
between multiple files to have databases larger than the OS's max file
size.
-jeff
On Thu, 2003-03-27 at 14:17, Dathan Vance Pattishall wrote:
ISAM tables are cut off at 4gb of data
MYISAM / INNODB /BDB have a filesystem
a.id , is it possible ?
The first thing that comes to mind is to do:
SELECT a.id AS table_a_id, b.id AS table_b_id, c.id AS table_c_id FROM a, b, c
or something like that.
There may be more elegant ways, but I haven't be using MySQL that long. gr
jeff
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
, a source build may or
may not be what you're looking for. I'd go that route, but any of my
co-workers can attest to the fact that I'm an obsessive compiler.
-jeff
On Wed, 2003-03-26 at 15:49, Saul wrote:
From: Jeff Kilpatrick [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Organization
/mysql_install_db script, I have to do
this or I get the error you've gotten. The mysql daemon needs to be able to
read and write these files.
--jeff
- Original Message -
From: Saul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:10 PM
Subject: Re: Problem
rollback, leaving you in a crazy state
with some badly updated tables (right guys? I think I read that in the
docs a couple years ago).
-jeff
On Wed, 2003-03-26 at 22:33, [EMAIL PROTECTED] wrote:
Hi all,
I want to execute a set of Insert,Update and Delete if any one of the
statement fails
Does the mysql user have permission to write to /var/lib/mysql?
-jeff
On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote:
Description:
Just installed the rpm files for Linux x86 downloaded from the web.
After installing rpm files, server won't start. The error (from the log
that the master does, so the
master and slave are out of sync after the LOAD DATA INFILE executes. I am
running the 3.23.56 binaries, RedHat 7.3, on both machines. Also, is there
any way to find out what records were skipped and why?
Thanks,
--jeff
--
MySQL General Mailing List
For list archives
support.
You're welcome. That's what this list is all about (usually).
May I know about ur participation in this IT industry.
Yes, you may. :-)
LOL. Thanks! I needed a laugh after having to re-sync my master and
slaves... (see earlier post)
--jeff
--
Jeremy D. Zawodny | Perl, Web
.
-
Email Enviado utilizando o serviço MegaMail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine
and PHP installed, for some reason
Apache is not configured to handle PHP by default (at least in
Jaguar). You have to make changes to your httpd.conf file.
jeff
At 9:23 -0800 3/24/03, katherine bjork wrote:
My test.php page recognizes the potential for mysql but something went
wrong when I first
PROTECTED]
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
_ ____ +--+
/ | / /__ _/ /_ _|Jeff Shapiro |
/ |/ / _ \/ __ \/ ___/ __ \/ __ `/|Photography and Graphic Design|
/ /| / __/ / / (__ ) / / / /_/ / |Colorado Springs, CO, USA
It seems to be this way on all the lists -- the java.mysql.com List-ID
header is missing, too.
--jeff
- Original Message -
From: Joseph Bueno [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql-list [EMAIL PROTECTED]
Sent: Sunday, March 23, 2003 1:43 AM
Subject: List-ID Header
Hello
these files? What happens if I delete them How can I tell if any
of them are stale?
thanks
--
Jeff Mathis, Ph.D. 505-955-1434
The Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505
Jeff-
Actually, thsee sound like the binary log files used primarily for
replication. If you're on host doctorpants, they'll be
doctorpants-bin.001
doctorpants-bin.002
doctorpants-bin.index
and so forth. If you don't want a write query log and aren't doing
transactions, remove the binlog option
to delete these files if we
want. database backup and recovery is a separate issue?
thanks for your response
jeff
Jeff Kilpatrick wrote:
Jeff-
Actually, thsee sound like the binary log files used primarily for
replication. If you're on host doctorpants, they'll be
doctorpants-bin.001
/unsubscribe.php
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
-readable, the directory permissions restricted access.
--jeff
- Original Message -
From: Salada, Duncan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 21, 2003 10:41 AM
Subject: load data infile question
Hi everyone,
I am using MySQL 3.23.49 and have started having a problem
How are you dumping the database? It doesn't seem like you should have
problems going either direction, especially to a case-insensitive
filesystem.
Copying databases with something like
$ mysqldump database | mysql -hremote_server database
works for me, even if it is fairly slow.
-jeff
in all kinds of headaches down the road.
You may get people trying to change information that some one else
put in the tables.
The best way to go is the parent/child relationship.
just my $0.02.
jeff
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I
(mailing_id) AS mail_count FROM member_mailings
GROUP BY member_id;
This puts the number of mailings into a temp table.
Now we do:
SELECT mail_count, COUNT(member_id) FROM member_counts
GROUP BY mail_count;
I *think* that these to step should give you what you are after.
jeff
At 22:47 -0800 3/17/03
for your SELECT statement
(or if no index is being used...). Invaluable when trying to optimize your
SELECTs.
--jeff
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Here's a close analogy for you. In a library, fiction books are
typically sorted first
mailing, and 20,000 members that have been sent 2
mailings.
Is this possible in one query?
TIA,
Daren
--
_ ____ +--+
/ | / /__ _/ /_ _|Jeff Shapiro
tbl_people.id = tbl_peoples_interests.person AND
tbl_people_interests.interests.id = interests.id
-jeff
On Sat, 2003-03-15 at 09:23, Charles Kline wrote:
Hi all,
My first post to this list.
I have a query which I can't quite get to work. I was hoping that
someone here could educate me a bit
a static query that can do that. I think
you'll need to compensate in the PHP script. If you don't get any
better responses or don't want to wait, email me off the list and we'll
do some php hacking; now would be a good time.
Thanks,
-jeff
On Sat, 2003-03-15 at 10:44, Charles Kline wrote:
Jeff
I'm assuming you're IDs are getting bigger, so how about ordering them in
descending order?
SELECT ID, title, article FROM news ORDER BY ID DESC LIMIT 2
Also, if you're starting from 0, you don't need to include that in the LIMIT
clause.
--jeff
- Original Message -
From: Todd W [EMAIL
that the server daemons on the OSX box and Linux box had no
problems and kept chugging along.
I would doubt that it matters, but the master for this machine is
running MacOS Jaguar.
Thanks,
-jeff
--
Jeff Kilpatrick kilpatjr_at_lupusDoTomrfdOtouhscd0Tedu
Oklahoma Medical Research Foundation
Michael-
That seems to be correct. I've been able to do this using PuTTY as the
client. Just forward the local 3306 to the server's 3306 and connect to
localhost:3306. Be sure to log to the server via ssh before attempting
a connection.
-jeff
On Thu, 2003-03-13 at 13:09, Tam, Michael wrote
does mysql provide a command to export table structure and data? i can't
seem to find anything like this in the manual. i'm trying to export tables
and data created on my desktop to my isp...help!
Jeff
-
Before posting, please
) = 'TSV'
AND BA_DATE = DATE_FORMAT('2003-25-2', '%y-%d-%m')
But still 0 rows... D'OH... What am I missing here? Thanks for any
help... I would hate to have to tell the boss we're going back to
VB-ADO-MSAccess ;-)
Jeff
-
Before
Yes Paul, that's what I meant.
See, even confusing myself now ;-)
The field is datetime as the time is used in other functions...
Would I be better using 2 separate fields?
Jeff
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Jeff [EMAIL PROTECTED]; MySQL List [EMAIL
Thanks guys,
Appreciate the help. Kinda makes sense now ;-)
Jeff
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Benjamin Pflugmann [EMAIL PROTECTED]; Jeff
[EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 9:32 AM
Subject: Re: Syntax confusion
()) - TO_DAYS(designs.designadddate) = 14
GROUP BY catcode
ORDER BY designfile;
That is unless you are allowing people to enter future dates in the
tables. Unless there is a good reason, I generally have error
routines prevent future dates into the table.
jeff
At 13:01
Try : (on a test table first of course)
UPDATE prodtable SET ProKeywords = REPLACE(ProdID, '-', '');
You may want to look at this page:
http://www.mysql.com/doc/en/String_functions.html
jeff
At 11:57 -0600 3/3/03, Doug Coning wrote:
Hi all,
I want to take the data in a column, modify
tables for the 5th one you created.
So your script needs to do something like:
create database 'Temp';
use 'Temp';
(You need the quotes [or maybe it's the backquotes] if you actually
want a mixed case name.)
I'm sure that if I'm off, someone here will correct me.
jeff
At 12:27 -0500 3/2/03
, but I can connect to it remotely using the normal
tools,...
Thanks,
Jeff
--
Jeff Mao
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
I believe this is close to what I am needing.
Thank you for your time and detail.
My thank you to everyone else for their comments.
Thanks,
Jeff
On Thu, 2003-02-27 at 12:13, Vikash K Agarwal wrote:
We have used procmail and PHP combination to achieve this for our
department mail management
that are up for deletion.
Any ideas?
Thanks,
Jeff
-
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 [EMAIL
How about:
my $sql = INSERT INTO apidbusers VALUES (?, password(?));
--jeff
- Original Message -
From: Jianping Zhu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:48 PM
Subject: Re: mysql encripted password from perl
sth-execute($username, password
anxiously await your responses.
--
Jeff Bearer, RHCE
Webmaster, PittsburghLIVE.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
would like to know if this is not as simple
as I may think.
Thanks for any thoughts on this,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
'%mysearch%' OR )
Many thanks,
Jeff
-
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 [EMAIL PROTECTED
yourself needing to do such queries regularly, you
may want to re-evaluate your database design.
Can I not do:
WHERE CONCAT(Item1,Item2,ItemN) LIKE '%mysearch%'
?
Jeff
-
Before posting, please check:
http://www.mysql.com
business week days.
Of course, and another question to consider, is if you wish to count
holidays or not.
jeff
At 12:58 -0500 2/24/03, Lucas Cowgar wrote:
Can anyone out there help me with a SQL query? I need to find the number of
business days between date a and b? Obviously finding simply
Mysql on and off.
Jeff
At 11:30 AM -0500 2/23/03, [EMAIL PROTECTED] wrote:
I'm trying to install Mysql in Macos X 10.2 following the quick install
steps. I'm a pro in the Unix command line and the configure command show
this error in the configuration:
[Akira:~/mysql-3.23.53] jeffreys% ./configure
and follow the instructions.)
Complete MySQL is available here:
http://www.aaronfaby.com/mysql.php
Complete MySQL should work for you unless you need some unusual
settings (which from your ./configure command it doesn't look like
you're using).
I hope this helps.
jeff
At 11:30 -0500 2/23/03, [EMAIL
:
There are many ways to lookup MySQL metadata. I was used to familiar
with them. Unluckily, I am 'spoiled' by phpMyAdmin recently.
I strongly recommend you to have a try with phpMyAdmin.
--- Jeff Epstein [EMAIL PROTECTED] wrote:
I've only been using MySQL for a few days, but I'm experienced
in the replicate-do-table directive above. Would
specifying matab.list make a difference?
The file I was loading was approx. 5MB and none of the data made it to the
slaves.
Thanks,
--jeff
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent
of this
problem?
Thanks,
--jeff
- Original Message -
From: Guilhem Bichot [EMAIL PROTECTED]
To: Jeff Kilbride [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 1:06 PM
Subject: Re: BUG? 3.23.55 not replicating LOAD DATA INFILE
Hi
.
Jeff Pearson
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
it, the backup folder soon blossoms as it collects a new
backup each day, and I'd like to automate the process more so I'm not
holding on to tons of old backups.
Thanks
Jeff
--
Jeff Mao
[EMAIL PROTECTED]
-
Before
= myisam_sort_buffer_size=64M
# Replication settings
log-bin
server-id = 1
-
Any help is appreciated.
Thanks,
--jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
.
Is there complete access to the meta-data?
(I'm using version 3.23.55, by the way.)
Thanks! :' )
=
:' )
Jeff Epstein
[EMAIL PROTECTED]
http://www.jeffyjeffy.com
..
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http
hello,
does anyone know of a good mysql-matlab release 13 interface? the
standard database connection capability within matlab is a really poor
implementation based on JDBC. JDBC is fine, but not how the matlab
people use it.
thanks
jeff
--
Jeff Mathis, Ph.D. 505-995-1434
I've recently learned that Oracle has the ability to partition table
data, Oracle9i's list partitioning feature.
http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html
I'm trying to find out if MySQL or any open source database has
something equivalent to this.
There is an imposed maximum number of details per enquiry (say 4 for this
example).
Many thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
= (SetField OR 'D');
Thanks,
Jeff
-
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 [EMAIL PROTECTED]
To unsubscribe, e
There is an imposed maximum number of details per enquiry (say 4 for this
example).
Many thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
That would work, but it's not necessary. He should use a
LEFT JOIN, which will produce a row in the output for the
left table, whether or not any right table rows match it.
The syntax is in the MySQL manual.
I appreciate the pointer to LEFT JOIN and have read through the site's
Thanks, Harald. I'll experiment with this approach!
J
--
You need a helper table containing just the numbers 0..N, where N is
greater than the maximum number of days in the query above. For
example:
CREATE TABLE seq (val INT NOT NULL
Thanks for the help, folks.
I see how the reference tables (either for the dates or the possible
number of days in the range) would work -- pretty slick solutions. I
worry about tables like that being able to scale, though, should a user
choose a large date range... I think, instead, I'll use the
a conspiracy?
Jeff
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
Description:
I tried installing mySql on OS X 10.2.3, following the instructions
at http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
password for the MySQL root user , so I typed:
./bin/mysqladmin -u root password 'new-password' (with, of course, a
password in place of 'new
Hi,
if I call:
my $record = $sth-fetchrow_hashref();
then:
$sth-finish();
How valid is it for me to keep referring to my $record hash pointer?
Especially if I use $sth in a subsequent transaction.
Thanks,
Jeff Snoxell
Aetherweb Ltd
http://www.aetherweb.co.uk
NB. I know I asked
Hi,
if I call:
my $record = $sth-fetchrow_hashref();
then:
$sth-finish();
How valid is it for me to keep referring to my $record hash pointer?
Thanks,
Jeff Snoxell
Aetherweb Ltd
http://www.aetherweb.co.uk
[SPAM FILTER FODDER: MySQL, QUERY
NOT RLIKE \bMyNum\b # Where \b is a
word boundary
Many thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jeff Kilbride [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 10:41 AM
Subject: Re: Optimizing Ext3 for MySQL
On Tue, Jan 14, 2003 at 11:33:54PM -0800, Jeff Kilbride wrote:
Are there any
. Here's the info from
show table status:
| list
| MyISAM
| Fixed
| 3786043
|137
| 518687891
|588410519551
|161528832
| 0
|3787110
| 2002-12-20 13:32:41
| 2003-01-15 19:57:16
| 2003-01-14 13:39:39
|
|
|
Thanks,
--jeff
- Original Message -
From: Steven
What about just issuing a PURGE MASTER LOGS TO master-bin.007 on the master
and then starting the slave without a master.info file? I think that will
recreate it for you -- but you should research this before trying...
--jeff
- Original Message -
From: James Fidell [EMAIL PROTECTED
,
--jeff
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
if this is a valid
session id and if not re-direct the user to a page saying unrecongnised
session id or something.
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
in their name (ie if I have set items A,AB,ABC then obviously
my LIKE query searching for an A will have issues).
Or am I missing something?
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php
for the number of records I get
back. Should this be the case? Is it reliable?
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
identify a reasonable point at which it's fair to start logging
some hours down to my client?
Many thanks,
Jeff Snoxell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
.,
etc.
)) .
')');
Which works fine except the \N isn't entered into my database as a null
value. I've also tried '\N' and '' and .
Any ideas how I can solve this easily?
Thanks,
Jeff
-
Before posting, please
+ (record_buffer + sort_buffer)*max_connections = 198985 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
021223 11:22:24 mysqld restarted
Has anyone encounteded this and been able to correct the problem and if so,
How?
Thank You
--
Jeff Hinds - Database Specialist
id's for each recipe, then
'look up' the ingredients.
Jeff Snoxell
Aetherweb Ltd
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
server is remote?
Many thanks, again!,
Jeff
-
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 [EMAIL PROTECTED
What's the best MySQL client for windows? I've tried 5 or 10 shareware ones
that seem ok but all seem a bit chasty (some more than others). Any
recommendations?
Thanks,
Jeff
-
Before posting, please check:
http
server is remote?
Many thanks, again!,
Jeff
-
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 [EMAIL PROTECTED
of table Shirts? It doesn't seem to do anything.
Jeff
-
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 [EMAIL
anything about TRUNCATE TABLE my_table_name.
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
then:
INSERT INTO my_table SET Name='Jeff'
then:
SELECT * FROM my_table
and lo-and-behold, the 'Ref' primary key auto-update field is 37062, not 1
as I hoped.
I am managing
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to ALTER
TABLE my_table AUTO_INCREMENT=1 ... at least according to Paul ... :)
No, I'm using MyISAM I
Hi,
is there an easy way to programmatically backup MySQL database tables using
Perl? My Perl code will be running on a machine remote to the MySQL server.
Ta,
Jeff
-
Before posting, please check:
http://www.mysql.com
record in the interim?
Is this a job for table locking?
Many thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
the query:
DELETE FROM my_table_name
should reset it... but it doesnt'.
What SQL do I use to reset the val.
Ta,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Age 50 AND UPDATE Status = OLD
Ta,
Jeff
-
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 [EMAIL PROTECTED
with a known date/time then
do my select query to select only those records with that time-stamp, and
then do my long-winded processing.
Can't help thinking there must be a nicer way to do it.
Thanks,
Jeff
-
Before posting
but
surely it should be able to accept data entry in non numerical cells?
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
sending UCT (10-digit unsigned
ints) values to an unsigned int field. These work OK for some of my
coulmns/fields but not for others.
Any clues as to what I'm doing wrong?
Many thanks,
Jeff
-
Before posting, please check:
http
on a database. Is record locking
something I definitely need to do?
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
of record
1 in the parent. Thus I can have databases with table structures like:
Customers: Orders: OrderedItems
Without having to always execute complex SQL queries every time.
Can I do anything with MySQL to make it act in the same way?
Many thanks,
Jeff
after trying this it shows mysql as running, but /tmp/mysql.sock as not being created.
i stopped mysql and then started it again, and the same thing happened...still no
mysql.sock? should i just reinstall? what is the best way to go about fixing this
problem? thank you.
jeff
ps -wef
501 - 600 of 828 matches
Mail list logo