Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebea
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis <[EMAIL PROTECTED]>
===
-BEG
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hi,
I'm "happy" to know I'm not the only one which have this segfault problem.
Do you have any idea of what kind of queries causes those segfault ? (I
unfortunatly have also a nil pointer)
Thanks and regards,
Jocelyn
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To:
Steven,
I assume you are running on Linux, since you were able to resolve the stack
traces. Which distro: rpm or .tar.gz?
I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on
a 4-way Linux-2.4.16-64GB-SMP, and it seems to work.
Your bug is probably query- or platform-spe
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis <[EMAIL PROTECTED]>
===
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French wrote:
> acceptin
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebea
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.
I have a si
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Joel Rees <[EMAIL PROTECTED]>
===
I know I'
Subject: Re: Info on 4.0.x release date
From: Dean Ellis <[EMAIL PROTECTED]>
===
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French wrote:
> accepting this is part of growing up. And while I applaud the honesty =
of
> saying "we won't declare it stable
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French wrote:
> accepting this is part of growing up. And while I applaud the honesty of
> saying "we won't declare it stable until it is stable," surely you can see
> your way clear that if you were explaini
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Joel Rees <[EMAIL PROTECTED]>
===
I know I'm not really involved here, but I would like to suggest a few
things.
> Obviously you don't agree with
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) databas
Subject: Re: Info on 4.0.x release date
From: Joel Rees <[EMAIL PROTECTED]>
===
I know I'm not really involved here, but I would like to suggest a few
things.
> Obviously you don't agree with me and that is something I readily accept. I
> do have difficulty with the fact that you clearly spent
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT. They are (woohoo)
upgrading to a QUBE (linux box) for a server which has my
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT. They are (woohoo)
upgrading to a QUBE (linux box) for a server which has mySQL installed
(and I can upgrade it etc..)
My job therefore is to
a) port MS Access data and
I know I'm not really involved here, but I would like to suggest a few
things.
> Obviously you don't agree with me and that is something I readily accept. I
> do have difficulty with the fact that you clearly spent more time typing
> your response than considering my points, which were intended
Hi,
We are having strange performance problem with mysql on Solaris.Our
application makes JDBC calls to mysql database which resides locally on the
machine.
It takes 3 minutes to execute a piece of code(which involves select,
insert and update queries) on a Windows machine but an ho
I downloaded a copy of 4.0.3 from the download page and it crashes every
five seconds! Resolving the stack trace gives:
0x806ebdb handle_segfault__Fi + 447
0x8261718 pthread_sighandler + 184
0x828cf8f memcpy + 31
0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210
0x80783fd dispatch_command__F19enum_se
Obviously you don't agree with me and that is something I readily accept. I
do have difficulty with the fact that you clearly spent more time typing
your response than considering my points, which were intended to be
constructive.
>> You got the truth. Would you prefer someone lie to you about
Pada Tue, 27 Aug 2002 20:20:33 -0500
"Gerald R. Jensen" <[EMAIL PROTECTED]> menulis :
> Trevor ...
>
> Do you want to drop the tables, or simply delete the data in them and retain
> the table structure?
>
> To delete data ...
> USE databasename;
> DELETE * FROM tablename;
>
> To drop t
I am trying to run Mysql for the first time and it fail.
Any ideas?
Thanks,
Nestor :-)
--
#mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
-
if you just wanna delete everything from the tables you can do
DELETE FROM table_name;
for each table. or you can do DROP table_name; for each one but then you
have to re-create each table that you drop with CREATe TABLE ( stuff here
);
Only use DROP table_name; if you know the structure of ea
Trevor ...
Do you want to drop the tables, or simply delete the data in them and retain
the table structure?
To delete data ...
USE databasename;
DELETE * FROM tablename;
To drop tables ...
DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT |
CASCADE]
If you drop a tabl
Hi
I am very new to mysql, so any help please
how to drop tables from a database from the command line
i have 6 tables in there, and need to be able to flush all the data out, (of
2 tables only) so there might be another way
Thanks
Trevor
I am using PHP with MySQL and have a timestamp field in my db table. What
would be the easiest way to get the newest timestamp out of the db?
Thanks in Advance
Steve
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3
-
Hi!
My guess is that 4.0.3-beta will be released on August 30, 2002.
I guess 4.0 will be labeled as stable in March 2003.
I guess 4.1 will be released as a binary in December 2002.
Let us see how these guesses fare :). Users can speed up stabilization by
using 4.0 and submitting detailed bug r
Hi there,
I have a big table which has 25 rows.And each row has a BLOB field
which stores lots of text. When I search text in this table(using the query:
where CONTENT like '%news%'),the searching speed is quite slow. is there
anybody also have such problem? Any ideas about improving the s
Hi Will,
As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta
as we speak and is likely to be released in the next month. V4.1 will most likely be
released Early Sept in Src form and in Binaries two months later.
4.0.x branch will be allowed to stabalise from th
Joe,
- Original Message -
From: "Joe Shear" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 28, 2002 12:15 AM
Subject: Innodb deadlock printouts in .52
> Hi,
> I'm running mysql 3.23.52 w/ innodb tables, and I started getting some
> deadlocks since upgradi
In the last episode (Aug 27), Chad Arimura said:
> The confusing thing is, I run the query across the EXACT same code on
> a different database (old copy of same database), and it works just
> fine. Are there any ways to peak into what mysql is doing besides
> "mysqladmin showprocesses"?
If the
Hi there,
I have a big table which has 25 rows.And each row has a BLOB field
which stores lots of text. When I search text in this table(using the query:
where CONTENT like '%news%'),the searching speed is quite slow. is there
anybody also have such problem? Any ideas about improving the sp
The confusing thing is, I run the query across the EXACT same code on a
different database (old copy of same database), and it works just fine. Are
there any ways to peak into what mysql is doing besides "mysqladmin
showprocesses"?
Thanks,
Chad
-Original Message-
From: Dan Nelson [mai
On Tue, Aug 27, 2002 at 05:45:07PM -0400, Will French wrote:
> When will 4.0.x finally be released to beta?
>
> The facts as I understand them:
> - 4.0 went alpha in Nov or Dec of '01
> - At the time, Monty and his gang projected stabilization by Jan or Feb
> - More than 6 months have passed sinc
When will 4.0.x finally be released to beta?
The facts as I understand them:
- 4.0 went alpha in Nov or Dec of '01
- At the time, Monty and his gang projected stabilization by Jan or Feb
- More than 6 months have passed since and the product is not yet stabilized
- No meaningful information has b
I'm trying to put together some statistics on our queries and am wondering
what percentage of our queries involve a full table scan. The variable
which kind of tracks this is Handler_read_rnd_next. However, since a
query may cause multiple Handler_read_rnd_next events to occur to get all
of it's
Sounds fair.
I have played with it a bit and found it good.
Just hoping it was be found stable soon as I am keen to use it in
production.
I'll get back to some testing.
Thanks,
Matt
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: 27 August 2002 22:15
To: [EMA
Matt Darcy wrote:
> Does anyone have any idea when Mysql 4 will be classed as stable.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list a
Hi,
I'm running mysql 3.23.52 w/ innodb tables, and I started getting some
deadlocks since upgrading from .51. When I do a show innodb status in
prints out the following:
020826 19:22:15 LATEST DETECTED DEADLOCK:
*** (1) TRANSACTION:
TRANSACTION 0 16655549, ACTIVE 1 sec, OS thread id 87339022 i
Does anyone have any idea when Mysql 4 will be classed as stable.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
use the -f option to ignore the duplicates.
Chris Barnes wrote:
>Hi,
>I have a database which a few tables which have a few fields set with
>auto_increment and i'm having alot of trouble restoring the backup because
>the backup recreates the table with the auto_increment field, but when it
>trie
your date strings are incorrect.
As a string it should be '2002-08-01'
but it can also be treated as a numeric.
try:
and expendituredate between 20020801 and 20020831
kamesh jayachandran wrote:
>Hi Gerald,
>I tried the following query,
>select DATE_FORMAT(expendituredate,"%d-%b-%Y") as expdate,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql,query ...
On Tuesday 27 August 2002 02:30 pm, walt wrote:
> There has been some issues with gcc 3.x if I remember correctly. I know
> RedHat released another beta because of problems with gcc 3.x. Have you
> tried it on a box with gcc 2.9x ?
I'm building a job database with simple invoicing. I have one table called
JOBS and one called INVOICES. In INVOICES there's a foreign key column
called job_id referencing INVOICES to JOBS.job_id.
in a simplified way it looks like this:
(there are a lot of other columns of course)
tabl
Hi,
My opinion:
Personally, i'm not agree with this model of data in a table...but it's
your choice.
Anyway, i think you can try this :
select field1,field2,field3,field4,field5,field6,field7 from YOUR_TABLE
WHERE field2=0 AND field7=15 AND (CASE WHEN field3 like 'john' THEN field3
like 'john' W
Dean Ellis wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote:
> > As soon as it actually *is* stable :)
> >
> > On a more serious note, we are currently working on preparing the first
> > release of 4.0 (4.0.3) that will be declar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 20:05, Scott Pippin wrote:
> I found out my AIX box's maximum file size is 2GB. What can I do if I
> will have MySQL tables that are possibly over 2GB?
You could either use MERGE tables:
http://www.mysql.com/doc/en/MERGE.h
In the last episode (Aug 27), Chad Arimura said:
> The search function for our ecommerce site has worked great up until
> the other day, but now when a search is ran the whole system just
> hangs. Here is what I have found:
>
> A process is started (search.cgi) that stays open until all of the
>
On Tue, 27 Aug 2002, Scott Pippin wrote:
> I found out my AIX box's maximum file size is 2GB. What can I do if I
> will have MySQL tables that are possibly over 2GB?
Hello,
There are basically two things you should consider:
1) Switch to InnoDB tables and create several data files just under 2
Elias,
ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
> I would like to know if it is possible to configure mysql auo increment
> feild to start from a specific number or configure it to have a specific
> character such as a letter inserted infront of it
The search function for our ecommerce site has worked great up until the
other day, but now when a search is ran the whole system just hangs. Here
is what I have found:
A process is started (search.cgi) that stays open until all of the memory is
used up (sometimes two same-named processes). Th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote:
> As soon as it actually *is* stable :)
>
> On a more serious note, we are currently working on preparing the first
> release of 4.0 (4.0.3) that will be declared "Beta" instead of "Alpha".
The
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hello,
If you're using MyISAM tables, shut down your server and run myisamchk
For example, myisamchk \mysql\data\dbname\*.MYI
See the MySQL Technical Reference for detailed syntax and usage
information. However, it seems like your table is corrupted, indeed.
Regards,
Iikka
On Tue, 27 Aug 2002
Frederick,
ALTER TABLE will do the biz:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
> I would like to know if it is possible to configure mysql auto increment
> field to start at a specific number or to configure the auto increment
field
> with a character such as a letter insert
Thomas Spahni wrote:
> On Mon, 26 Aug 2002, Donald J Miller wrote:
>
> > Hello everyone,
> >
> > I am trying to create a mysql table to hold either the entire contents
> > of text or WordPerfect files. I've read about BLOB or TEXT type columns
> > so I've tried creating a table such as:
> >
> >
Scott Pippin wrote:
> Which Operating Systems limit MySQL to a 2GB table size?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
According to the book I'm working from right now, you can't do this directly. What it
suggests is that you insert the first row in your table manually and insert the
integer that you want to start at. AUTO_INCREMENT will then use this number as its
starting point and continue upwards.
I haven'
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
wor
Hi
I have a table that returns the following error message as soon as I run
a query that reads out more then 300 posts from the table
ERROR 1030: Got error -1 from table handler
The strange part is that the table works without any problem except when I
try to select more then 300 posts. I have t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tuesday 27 August 2002 17:17, Scott Pippin wrote:
> When will MySQL 4.0 be released as a stable version?
As soon as it actually *is* stable :)
On a more serious note, we are currently working on preparing the first
release of 4.0 (4.0.3)
I would like to know if it is possible to configure mysql auto increment
field to start at a specific number or to configure the auto increment field
with a character such as a letter inserted infont of it(eg. r1, r2..)
Thanks
F belfon
On Tue, 27 Aug 2002, Will K. wrote:
> hello,
>
> Please dont tell me to RTFM on this one (cause I am already doing that), but
> for clarity's sake... can someone tell me what it means when you use NULL
> and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I
> use them?
Wi
Dear Sir/Madam,
In dos-prompt, I type at c:\mysql\bin>mysql for testing to see if mysql is
connected successful but
the error is : Error 2003: Can't connect to MySQL server on 'localhost'
<10061>
How to solve this problem?
Hope to hear from you soon.
Thank you.
Regards
Ellen
---
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
wor
I would like to know if it is possible to configure mysql auo increment
feild to start from a specific number or configure it to have a specific
character such as a letter inserted infront of it.
Thanks
" I have no respect for reality as soon as it is acknowledged as such. I am
interested
On Tue, Aug 27, 2002 at 09:17:46AM -0600, Scott Pippin wrote:
> When will MySQL 4.0 be released as a stable version?
Where there have been no reported bugs for a sufficient amount of
time.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http:
On Mon, 26 Aug 2002, Donald J Miller wrote:
> Hello everyone,
>
> I am trying to create a mysql table to hold either the entire contents
> of text or WordPerfect files. I've read about BLOB or TEXT type columns
> so I've tried creating a table such as:
>
> CREATE TABLE filetest(fileid int(5) n
Mike Duffy wrote:
> Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
>
> I would like to use the "getGeneratedKeys()" method.
>
> Thanks.
>
> Mike
>
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://financ
> Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
> I would like to use the "getGeneratedKeys()" method.
The mm.mysql driver has been taken over (with it's author), renamed (but
not the author) to Connector/J, and enhanced to 3.0 level. It is still Beta
at the moment, but suppor
Hi Victoria,
May I ask when 4.0.3 will be released?
In addition, I found 4.0.x contains the "max" sqld as well. Are there any
different between the 4.0.x and 4.0.x-MAX version?
Regards,
Michael
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Try MySQL Connector-J 3.0.0 (dev). You can download it from mysql.com.
Regards,
Michael
-Original Message-
From: Mike Duffy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 7:41 AM
To: [EMAIL PROTECTED]
Subject: JDBC 3.0 Driver
Does anyone know if there is a good JDBC 3.0 Dri
On Tue, 27 Aug 2002, Will K. wrote:
> Date: Tue, 27 Aug 2002 01:09:32 +
> From: Will K. <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: NULL ?
>
> hello,
>
> Please dont tell me to RTFM on this one (cause I am already doing that), but
> for clarity's sake... can someone tell me what
Try to remove two 'LIKE' conditions.
query 3:
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
Field7=15 AND Field2=0 AND Field3 LIKE '%John%'
ORDER BY Field6 LIMIT 0,20;
What do you have now???
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL
Ben
It would appear that the deletion of rows may be a problem.
After deleting rows older than 6 months, do you optimize the
table?
As I understand it, mysql does not delete delete, only marks
a bit for every row thats deleted. That way, delete speed is
fast. However, it slows down queries and i
ME> In this case...
ME> Can you try again?
Sure.
query 1 :
> SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR Field5 LIKE
> '% John%' ) ORDER BY Field6 LIMIT 0,20;
query 2:
> SELECT Field1,
When will MySQL 4.0 be released as a stable version?
-
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 <[EMA
Which Operating Systems limit MySQL to a 2GB table size?
-
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 <[
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 4:55 PM
Subject: Re: Slow select query, need some clues to speed it up please ...
> ME> :( That's strange. You removed condition (which can only _incr
Hi:
If my MySQL server updates a table, does the ability exist to inform a
client or clients (observers) that a table has changed. I do not want to
replicate the data, I just want to know the name or names of the tables that
have been updated.
Thank you
Phil Willemann
---
> > As I understand...
> > After removing "Field5 LIKE '%John'" condition the query works much
> faster.
> Nop, sorry i'm not clear, the query works mush slower ...
:( That's strange. You removed condition (which can only _increase_ number
of records in resultset)
and query works much slower...
The server that has the mysql DB, has a control panel adding and
removing new mysql databases and mysql users all of the time. Is there
any possible way to have one global grant table for all of the users
coming from 192.168.1.%? I believe I attempted this a while ago, but I
used an INSERT comm
Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
I would like to use the "getGeneratedKeys()" method.
Thanks.
Mike
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-
Ilyas,
Tuesday, August 27, 2002, 2:45:12 PM, you wrote:
IK> Can I create an integer field which automaticly look after in two
IK> tables to have the biggest id from this tables and increment this
IK> maxid and store it?
Nope.
--
For technical support contracts, goto https://order.mysql.c
Ilyas,
Tuesday, August 27, 2002, 4:55:45 PM, you wrote:
IK> Can I also use a select statement in a create statement. Something like this:
IK> create table mytable
IK> (
IK> id int not null primary key (select max(id) from mytable2),
IK> name varchar(255)
IK> );
Nope.
IK> is thi
Mylin,
Tuesday, August 27, 2002, 8:17:13 AM, you wrote:
MC> I'm a newbie with mysql. I have a few question and would really appreciate
MC> it if you can help me. I'm creating a database for a payroll system. I
MC> actually finish with my entity relationship diagram. What should be the
MC> nex
Andrew,
Tuesday, August 27, 2002, 4:21:29 AM, you wrote:
>>Stuart Low wrote:
>> > Have had continuing issues with trying to actually get LOAD LOCAL INFILE
>> > commands working
>>At 11:45 26/08/02 +0300, Victoria Reznichenko wrote:
>>Did you specified local-infile=1 for client, too?
AM> H
Brad,
Tuesday, August 27, 2002, 7:59:19 AM, you wrote:
BB> is this "tee" or "\T" command supposed to still work in mysql 4.x?
[skip]
BB> should work similarly. but this is what happens:
BB> mysql> tee /tmp/log.txt
BB> No outfile specified!
BB> the --tee=filename argument to the mysql client w
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> As I understand...
> After removing "Field5 LIKE '%John'" condition the query works much
faster.
Nop, sorry i'm not clear, the query works mush slower ...
> But it is different query... :)
> I mean that queries return different results.
Yep ...
>
Hi,
try this:
"create table mytable select max(id),space(1) name from mytable2"
and then this:
"alter table mytable modify name varchar(255)"
Danilo Maurizio
-Messaggio originale-
Da: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Inviato: martedì 27 agosto 2002 15.56
A: [EMAIL PROTECTED]
O
> Can I also use a select statement in a create statement. Something like this:
>
> create table mytable
> (
> id int not null primary key (select max(id) from mytable2),
> name varchar(255)
> );
>
> is this possible or is there an other way to do something like this?
>
> ilyas
>
Hi,
I have a database which a few tables which have a few fields set with
auto_increment and i'm having alot of trouble restoring the backup because
the backup recreates the table with the auto_increment field, but when it
tries to enter the data back into the table it cant because it is trying to
Can I also use a select statement in a create statement. Something like this:
create table mytable
(
id int not null primary key (select max(id) from mytable2),
name varchar(255)
);
is this possible or is there an other way to do something like this?
ilyas
filter: mysql
--
As I understand...
After removing "Field5 LIKE '%John'" condition the query works much faster.
But it is different query... :)
I mean that queries return different results.
On other hand you can't change type of Field5 because you have a row with
51723 symbols in Filed5. :(
So...
question: Do you
Hi Gerald,
I tried the following query,
select DATE_FORMAT(expendituredate,"%d-%b-%Y") as expdate,sum(amount) as
amount from expenditure where userid=11 and expendituredate between
'2002-8-01' and '2002-8-31' group by expendituredate order by
expendituredate;
which is not overriding the expend
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> IMHO the problem is in this condition
ME> ...Field5 LIKE '%John'...
>
ME> Can you remove it from query and try again?
In fact it was Field5 LIKE '%John%',
but "Field5 LIKE '%John'" and "Field5 LIKE '%John%'" don't change query
speed at all excep
Mozzi schrieb:
> Hallo all
> I am setting up replication.
> Now I am sure my servers can connect but I still have a problem.
> I setup my slave server to only replicate one table
> The error I get is copy'd underneath here.
> I am sure it is easey to solve I have just started thinking in loops
Your query overloads expendituredate.
Mysql now has to scqan the whole table to see if the new expenditure
date will
meet the where clause ( which it never will )
try DATE_FORMAT(expendituredate,"%F=%b-%Y) as expdate
and see what happens.
kamesh jayachandran wrote:
>Hi all,
>I have a table na
Hi,
i still have a "little" problem. When i do multiple connections to
my database over network (via mysql) then i get strange errors. I don't
know how to explain this so i'll give you an example.
(it is part of my real prog so it isn't probably the simplest one)
CREATE TABLE TR_TEMP (DELETE_
1 - 100 of 128 matches
Mail list logo
