hi everybody
i want to take diff of datetime format columns.
Is it possible using direct '-' arithmatic..
It gives result as:
2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126
2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350
First row is clear but i'm not getting second row's
diff.. **((63)50)** h
Anyone able to help with this? Or am I just stuck...?
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 6:47 PM
To: '[EMAIL PROTECTED]'
Subject: compile errors
trying to compile mysql-3.23.46, getting this error. Can't find any
reference to i
Hi!
On Dec 05, Tobias Crush wrote:
> Hi All,
>
> We am currently investigating the possiblity of migrating a legacy app from
> Informix C-ISAM files to MySQL. To do this we are looking to be able to
> retain the core application code as unchanged as possible.
>
> What we want to do is be able
Hi!
First: please reply to the list, not directly to me.
Then:
I need a repeatable test case. That is
CREATE TABLE ...
INSERT INTO ... VALUSE (...),(...)...
SELECT * FROM ... WHERE ... <= it works
SELECT * FROM ... WHERE ... ORDER BY ... <= it does not
On Dec 04, Mark J. Degalli
Hello list!
We have a dual-CPU machine with FreeBSD 4.1.1 (well-known problem with
MySQL, eh? ;)) Yesterday, after our server died 4 or 5 times during 8
hours, I compiled MySQL with LinuxThreads. It works pretty cool now,
but two things annoy me very much:
1. MySQL dies when I try to CHECK TABLE
> CREADE INDEX myDateField_Index
> ON tblTabel
> (
> DATE_FORMAT(myDateField,'%Y%m%d')
> );
>
> This may or may not work, but it's worth a shot, if you prefer your query
in
> the format it was in before.
It did not work with MySQL 3.23.32, it whould have been very nice, because i
still have a pro
> > CREADE INDEX myDateField_Index
> > ON tblTabel
> > (
> > DATE_FORMAT(myDateField,'%Y%m%d')
> > );
> >
> > This may or may not work, but it's worth a shot, if you prefer your
query
> in
> > the format it was in before.
>
> It did not work with MySQL 3.23.32, it whould have been very nice,
be
> I am not sure I quite understand your problem, but doen't the BETWEEN ...
> AND operator
> solve your problem? All you have to do is to format the limits in a way
> that MySQL understands
> to be a timestamp, and it should then do a proper date comparison.
Nope, the BETWEEN AND operator does no
On Wednesday 05 Dec 2001 09:30, Emil Rasmussen wrote:
> > CREADE INDEX myDateField_Index
> > ON tblTabel
> > (
> > DATE_FORMAT(myDateField,'%Y%m%d')
> > );
> >
> > This may or may not work, but it's worth a shot, if you prefer your query
>
> in
>
> > the format it was in before.
>
> It did not wor
I have a problem with my regional setting.
I want to insert into my database a decimal number, using comma instead of dot like in
this example:
11,45
not like
11.45
If possible, i wouldn't change my regional settings.
Can you help me ?
Thanks
-
Hello guys.
I'm using mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) at the
server of my hosting provider.
My English is bad but I'll try to describe my problem.
I'm using ukrainian language filling the database. The next problem
occured: when i'm using "LIKE '$text' " at the
On Wednesday 05 December 2001 18:48, Emil Rasmussen wrote:
> > I am not sure I quite understand your problem, but doen't the BETWEEN ...
> > AND operator
> > solve your problem? All you have to do is to format the limits in a way
> > that MySQL understands
> > to be a timestamp, and it should then
Hi,
This happens on MySQL 3.23.44
CREATE TABLE ttble (
`k1` varchar(100) NOT NULL default '',
...
`k2` varchar(65) NOT NULL default '',
...
PRIMARY KEY (`k1`, `k2`)
...
) TYPE=InnoDB
When k1 is compared to a string with only one known letter...
EXPLAIN SELECT * FROM ttb
On Wednesday 05 December 2001 16:40, you wrote:
> hi everybody
> i want to take diff of datetime format columns.
> Is it possible using direct '-' arithmatic..
> It gives result as:
>
> 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126
> 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350
>
> First row
> You have to include the full format to make it work, i.e. including the
> MMDD section of the MMDDHHMMSS format. The above query will
probably
> yield no results because you have no data in the given range (year ).
Yes i know, but i want the data from all years, months and days sort
> If your field is a standard MySQL DATE/TIME field then
>
> HOUR(myfield) will extract the hour portion from myfield.
>
> Thus you can have
>
> WHERE HOUR(myfield) = 14
Yes, that is what i am doing now, but that is really slow, because all the
dates, have to converted to strings, before MySQL
Hi,
how big is the result set in your 2 queries (compared to the number of
rows in the table)?
Seems that in the 2nd case the query was much more selective than in the
first case. Therefore using an index in the first query might have been
considered not advantageous.
But try this also with 'sel
Hi, I am looking to export a PHP/MySQL application I have written. As far as
the MySQL side goes I am unsure if I should simply send a MySQL folder (copied
from the MySQL/Data directory) or a php file that would create all the
neccessary MySQL tables the first (and only) time it ran. I can ap
mysql> use protodel;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'access'
Didn't find any fields in table 'document'
Didn't find any fields in table 'document_access_log'
Didn't
MySQL - spam bypasser
> myisamchk --keys-used=3D0 -rq
> You can enable/disable keys from command line in 3.23.
While that would disable the key before the load,
how do I re-enable them afterwards?
-
Before posting, please
> WHERE myfield LIKE 'HH'
>
> However this query will probably not use your index either :)
Yeah, it works, but still, it does not use my index as long as it is
working
with strings. But neat trick anyway.
It sounds to me as if you need to change your table design. You want to
sea
Ian writes:
> Here is the 2.8 package I just downloaded from one of your mirror sites.
>
> [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> ls mysqld
> mysqld*
> [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> file mysqld
> mysqld: ELF 32-bit MSB exe
Emil,
You might try to split the time stamp into separate date and time columns. That would
allow you to cretae and use an index on time alone.
At 14:24 2001-12-05 +0100, Emil Rasmussen wrote:
>>
>> WHERE myfield LIKE 'HH'
>>
>> However this query will probably not use your index
Hi Sinisa and Colin,
Sinisa the PR database (Problem/Resolution Database) for freebsd is
a more formal version of
http://www.mysql.com/doc/B/u/Bugs.html .
In FreeBSD eash problem is assigned a number in a database tracking
who submitted the bug, the date, the priority, and details about the
bu
Hi Husri,
you are low on memory (as the error says). try this, first remove the
file config.cache from the mysql source directory then rerun config
and add --with-low-memory to the list of commands: I use a shell
scripte with this:
rm config.cache
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-O3 -fe
On Wednesday 05 December 2001 05:51 am, Ian Moss wrote:
> System: Linux proserver 2.2.14 #1 Sat Mar 25 00:45:35 GMT 2000 i686 unknown
> Architecture: i686
>
> Basically its all a lie that linux is more stable than windoze.
> I've run mysql on pc's over the last year with no problems at all.
> The
Ken Menzel writes:
> Hi Sinisa and Colin,
> Sinisa the PR database (Problem/Resolution Database) for freebsd is
> a more formal version of
> http://www.mysql.com/doc/B/u/Bugs.html .
>
> In FreeBSD eash problem is assigned a number in a database tracking
> who submitted the bug, the date, the p
>
> It sounds to me as if you need to change your table design. You want to
> search by hours only,
> so you should have an hours column in your database. Either you should
> break the date up into
> DATE and TIME fields
I have been thinking on doing that, but there was something about it, that i
Hi Konstantin,
You don't mention what version of MySQL you are using so I will
assume that you are using the most recent. There were many problems
with the threads libraries and even some compiler bugs on 4.1 and 4.2.
The are resolved by 4.3 and 4.4 (and soon to be 4.5) Is there any
chance tha
Hello everyone..
I know that you can write the sql scripts into a text file and redirect it
to the mysql from command line.. Is there any way to add shell/system
commands to automate process? PArticularly, I am looking for a way to echo
files and put them in a blob column.
I am also wondering
> -Original Message-
> From: Michael Widenius
> Yes; Our Solaris binaries are currently 32 bit.
>
Hi,
> The main reason for this is that I haven't seen any reports that gcc
> should be able to produce production quality code on 64 bit sparc.
>
I've been involved with 64bity stuff h
> First: please reply to the list, not directly to me.
> Then:
>
> I need a repeatable test case. That is
>
> CREATE TABLE ...
> INSERT INTO ... VALUSE (...),(...)...
> SELECT * FROM ... WHERE ... <= it works
> SELECT * FROM ... WHERE ... ORDER BY ... <= it does not
THIS QUERY WO
Hello list!
I have installed MySQL 3.23.39 on Compaq Tru64 UNIX V5.1. I need to run two
servers on the same machine, one as master and another as slave. The
database used is InnoDB, I need to replicate only one database.
I start successfully the master. When I start the slave it go up and down.
On Wed, Dec 05, 2001 at 05:05:54PM +0200, Michael Widenius wrote:
>
> Hi!
>
>
> Yes; Our Solaris binaries are currently 32 bit.
>
> The main reason for this is that I haven't seen any reports that gcc
> should be able to produce production quality code on 64 bit sparc.
>
the sun compiler d
Hello !
I often use that common scheme to parametrize my queries.
#!/bin/bash
#check parameters most commonly (only number of parameters)
if [ $# !=NUMBER_OF_PARAMETERS_NEEDED ];
then echo "Too few parameters";exit 1;
fi
# these are queries in my "transactional" procedure
# $1...$N ar
Hello the list,
Is it possible to import ODBC data into a mysql database ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
>mysql ... which would prevent index usage. If your kind of query is
> frequent and slow, you could split your DATETIME column into two
> separate columns for DATE and TIME and put an index onto TIME.
Ok, thanks for the help!
Regards Emil
--
Emil Rasmussen
http://noget.net
-
If you need a timestamp that is automatically updated when a record is
inserted, replaced, or updated, declare one field in the record as
TIMESTAMP:
create table mytable (
myvalue int default 0,
mytime TIMESTAMP
}
INSERT INTO mytable VALUES( 123, NULL );
-Original Message-
From: *Himer
Hmmm,
Good thinking. However, the files needed (autoconf) is in /usr/local/bin -
which is in my $PATH. a which shows autoconf so I know it can be seen
without any problems. There is no ld.conf.so under solaris 2.6.
Any more suggestions as I am having big problems with this.
Thanks,
Matt.
---
Hello !
With M$ Query it's achieved just by executing any modification query
(insert,update,create etc).
Check the permissions for user from who the ODBC connections is performing.
Goodbye.
Dannis.
On Wed, Dec 05, 2001 at 04:46:22PM +0100, TOMASSONI Dominique wrote:
> Hello the list,
>
> Is it
> > Ok, I followed your advice and removed the soaris built gcc from
> > sunfreeware and downloaded the source instead. How ever now I am
> > getting this message when I try to compile gcc:
> >
> > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> > Configuring for a sparc-sun-solaris2
Raffaella,
try to compile the latest version 3.23.46 on your system with the gcc -g
flag. MySQL AB does not have a ready binary on Tru64, so you have to compile
yourself. If it still crashes, run the slave inside gdb and do bt full, so
that we see where it crashes.
Regards,
Heikki
http://www.in
Okay, I've finally gotten around to trying to create an InnoDB database.
I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the
--with-innodb parm. Everything installed wonderfully.
When I start up mysqld, the datafiles and logfiles are created just fine.
But, when everything is done
Andrew Kharchuk writes:
> I'm using ukrainian language filling the database. The next problem
> occured: when i'm using "LIKE '$text' " at the 'SELECT" SQL statement
> with some 2 letters in ukrainian letters in $text, mysql server regard them
> as another letter (it make no distinction be
REGISTE O SEU DOMÍNIO GRÁTIS
Se tem um daqueles endereços complicados do tipo,
http://www.endereço.pt/paginas_pessoais/~minha_pagina/index.html, aproveite esta
oportunidade para criar um endereço mais simples e fácil de comunicar, do tipo,
www.minha_pagina.web.pt, SEM PAGAR NADA.
O WEB.PT Fre
Dammit, never mind. I figured it out.
Maybe someday I'll be able to ask an intelligent question here...
--Walt
-Original Message-
From: Weaver, Walt
Sent: Wednesday, December 05, 2001 10:09 AM
To: [EMAIL PROTECTED]
Subject: Error trying to create InnoDB database. HELP
Okay, I've fina
Did you run the 'mysql_install_db' script after installing MySQL??
the database 'mysql' should be located within the datadir, along with the other
databases that are created.
>>On Wed, 5 Dec 2001 10:08:38 -0700 , "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
>>Okay, I've finally gotten around to
Yup, somehow I must've missed that. Thanks...
--Walt
-Original Message-
From: Mike(mickalo)Blezien [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 10:22 AM
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Subject: Re: Error trying to create InnoDB database. HELP
Did you run the 'my
At 10:08 -0700 2001/12/05, Weaver, Walt wrote:
>When I start up mysqld, the datafiles and logfiles are created just fine.
>But, when everything is done the following error appears:
>
>/usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host'
>doesn't exist
This may be an obvious on
Hey people,
I've just set-up mysql on a redhat version6.1 of linux. I am new to both.
If i log into the machine as root I can run mysql.
If I log into the machine as a normal user I can't run mysql.
Is it a case of permissions in linux?
I need to be able to run mysql through a telnet window on
Hi,
How do I start an autoincrement field at a certain value, say 1000?
I have a field as:
ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID)
How do I modify it to start at 1000?
These all generate errors:
modify mytable ID AUTO_INCREMENT = 1000;
modify mytable ID = 1000;
modify mytable ID AUTO_INCR
In General Terms:
Most default linux installs do not allow root user to telnet in to the
machine, this is good as a default.
You need to add the user that you do logon as to the MySQL permissions. This
can be found in the manual.
To access your MySQL db from Access, all you need to do is install
Hi I get the following errors on start-up;
011205 12:53:25 mysqld started
/usr/local/libexec/mysqld: File './melges-bin.1' not found (Errcode: 13)
011205 12:53:25 Could not use melges-bin for logging (error 13)
011205 12:53:25 /usr/local/libexec/mysqld: Can't create/write to file
'/usr/local/v
Although Samba is not needed for what you need, I suggest that you install
it. I use it to easily share files (without FTP) on my home systems:
RH Linux 7.0, Win98
be prepared to tinker around with the samba configuration files, though.
-Original Message-
From: Faizal Mangera [mailto:[E
Sun 450
Solaris 7
3 CPU
MySQL binary install
50 million record table. Initially tested on dual
CPU Intel Linux, now trying on Sun.
During index create (via alter), it copies the base
file (as documented). It spins the CPU at about 31%,
with 7 threads active. There is almost NO iowait (fast
f
quoted from: http://www.bitbybit.dk/mysqlfaq/faq.html#auto_increment
In latter versions of MySQL, you can specify AUTO_INCREMENT=n as a table
option. This will tell MySQL to use n for the initial value. Any new rows
added will increment the counter by 1, as usual. This value is lost if you
delet
In 3.23 or later: Just specify an ID of 1000 when you insert your first
record. If every record thereafter is INSERTed with ID = NULL (or just
not specified), then AUTO_INCREMENT will automatically bump up each ID
field by one after the first one. If you are loading data from
mysqlimport or
BLOCKED DELIVERY OF EMAIL FROM [EMAIL PROTECTED]
Our email scanner has detected a file type (or content) which we are not
permitting through our systems.
These namely include movies, executables and large pictures.
Your email has been stopped. The intended sender will receive
George Horvath wrote:
>
> > > Ok, I followed your advice and removed the soaris built gcc from
> > > sunfreeware and downloaded the source instead. How ever now I am
> > > getting this message when I try to compile gcc:
> > >
> > > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> > >
Hello,
I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED]
(using password: YES)"
errors. I'm connecting to this MySQL server from a remote site.
I don't see any reason for this. I KNOW that my password is correct. In
the user table, the "Host" is set to % for the "mysql" user
I didn't know where else to turn, but I'm wondering the simple (and
stupid) question of how do I get started using and learning MySQL.
I recently switched to a hosting company that supports MySQL, but what
do I need to get started using it and learning it?
Does the MySQL only exist on a web ho
go to http://www.mysql.com
Get documentation, such as MYSQL Manual. Read it.
No, you do not need MYSQL on your local system, but helps when testing, and
learning. MYSQL is available for Unix/Linux and Windows systems.
There ae many good books. The "bible" is Paul DuBois book, MYSQL. He ofte
> Hello,
>
> I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED]
> (using password: YES)"
> errors. I'm connecting to this MySQL server from a remote site.
>
> I don't see any reason for this. I KNOW that my password is correct. In
> the user table, the "Host" is set to % for th
For some reason the binary install install of mysql on redhat linux is
putting the database files in /var/lib/mysql instead of
/usr/local/mysql/data. The data dir is present and holds mysql and test
databases, but when we populated the data base the new databases where put
into /var/lib/mysql. W
I have a database with 12 tables. I am running a query to select certain
fields
from 3 of the tables, like this -
select Title, Details, StartDate, City, State
from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
where phpCalendar_Details.EventLocationID = phpCalendar_EventLoca
On Wed, Dec 05, 2001 at 04:28:58PM -0500, David Hudgins wrote:
: For some reason the binary install install of mysql on redhat linux is
: putting the database files in /var/lib/mysql instead of
: /usr/local/mysql/data. The data dir is present and holds mysql and test
: databases, but when we popu
I'm looking for a new commerce package, something run of a MySQL database.
it's gotta have bulletproof (well, as close as you can get) session
management. I wonder what others on the list are using and like? input is
appreciated!
thanks!
-
Hi,
- Original Message -
From: "Michael Tam" <[EMAIL PROTECTED]>
> I am using MySQL 3.23.41 under Win2000. I wonder what is the easiest
> way to upgrade the MySQL to 3.23.46 with my existing data and grant table?
>
>From what I see is that I need to dump the data tables as file
Hello,
I'm having trouble determining what's going wrong with a MySQL query that
I'm doing from PHP.
I have a table with the following columns:
id (int)
name (varchar 20)
starttime (int)
duration (int)
now, i have a row that has a starttime of 60, when i attempt to do the
following update with
Using mysql-3.23.33-4 on SuSE Linux 7.1:
root@fluorite:/usr/sbin > uname -a
Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown
We've been using MySQL for a while and we're trying to test InnoDB. According the
InnoDB page all we need to do is untar the package and ove
René,
> I want to select about 25 rows from a table, and sort them by two
> criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
> "Predator", "Millennium" are the various Series, and the order I'd like
> the rows in the array). Within each Series, I'd like the rows sorted by
Whenever I try to do anything with a specific table in my db, I get an
error. Here's the list of tables:
mysql> show tables;
++
| Tables_in_acv2 |
++
| company|
| group |
| internet |
| knowing|
| person |
| personality|
Hello everyone,
I've rewrote our existing our existing software to be compatible both for Oracle 8i
and MySQL databases.
I wanted to know, does MySQL support auto-extending of it's tablespace?
I know how to manually do it, by adding data files, and restarting the server.
Also, how could I chec
Chip,
> I have a database with 12 tables. I am running a query to select certain
> fields
> from 3 of the tables, like this -
>
> select Title, Details, StartDate, City, State
> from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
> where phpCalendar_Details.EventLocationID =
I have this SQL query:
SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
(well, maybe there are more than two columns selected, and maybe a
little more than two tables, but you got the idea...)
The tables have 5...10 columns, every column is an in
group is a reserved word, use groups as table name
-Original Message-
From: Alex Pukinskis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 11:39 PM
To: [EMAIL PROTECTED]
Subject: queries on particular table produce errors
Whenever I try to do anything with a specific table
Yes, group is a reserved word (think GROUP BY). See
http://www.mysql.com/doc/R/e/Reserved_words.html
I believe you can make this work by putting the table name in quotes, e.g.
Select * FROM 'group';
but you will probably find it easioer to rename your table.
Michael
On Wed, 5 Dec 2001, A
On Wednesday, December 5, 2001, at 03:44 PM, Philippe Parmentier wrote:
> group is a reserved word, use groups as table name
That being the case, how do I drop or rename a table called "group"?
-Alex
--
Alex Pukinskis
Internet Consultant
aboutChange
http://aboutchange.com
http://aboutcreati
"DL Neil" <[EMAIL PROTECTED]> on 12/05/2001 11:35:46 PM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject: Re: select statement group by unusual results
Chip,
> I have a database with 12 tables. I am running a q
At 14:45 -0800 2001/12/05, Florin Andrei wrote:
>The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
>it run over night, in the morning i still didn't got any results, so i
>killed the query).
Hi Florin,
It would help if you could also provide:
the hardware and OS
the a
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>> group is a reserved word, use groups as table name
>
>That being the case, how do I drop or rename a table called "group"?
Try:
ALTER TABLE 'group' RENAME new_table_name
HTH,
/Rob
~
Robert Alexander, A
Hi everyone,
I'm using InnoDB tables, and I would like to turn the auto commit off.
I do SET AUTOCOMMIT=0 in my.ini file.
And when I restart the server, it won't start.
Does anyone know why?
Regards,
Oganes Demirchyan
Motorola Life Science
757 S.Raymond
Pasadena, CA 91105
Tel: 626-584-5900
Hi!
On Dec 05, JW wrote:
> Using mysql-3.23.33-4 on SuSE Linux 7.1:
> root@fluorite:/usr/sbin > uname -a
> Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown
>
> We've been using MySQL for a while and we're trying to test InnoDB.
> According the InnoDB page all we ne
On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote:
> At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>>> group is a reserved word, use groups as table name
>>
>> That being the case, how do I drop or rename a table called "group"?
>
> Try:
>
> ALTER TABLE 'group' RENAME new_ta
Well, I got around the problem by replacing the old mysql/english directory with a new
one from the tarball. I hope that was an o.k. thing to do.
At 04:35 PM 12/5/2001 -0600, you wrote:
>Using mysql-3.23.33-4 on SuSE Linux 7.1:
>root@fluorite:/usr/sbin > uname -a
>Linux fluorite 2.4.0-64GB-SMP
> I don't think it's a version problem because the R
PM was mysql-3.23.33-4 and the tarball is mysql-max
-3.23.46-pc-linux-gnu-i686.tar.gz.
33 != 46
I'd be surprised if that's not the reason for the problems
you're having, especially considering how much has changed
since 3.22.
//C - points to
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote:
> At 14:45 -0800 2001/12/05, Florin Andrei wrote:
> >The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> >it run over night, in the morning i still didn't got any results, so i
> >killed the query).
>
> the hardware and
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir = /var/lib/mysql/innodb
innodb_data_file_path = indb1:200M;indb2:200M
that of course gives us 400M total.
I have not yet found in t
Florin Andrei writes:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
> tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
>
> The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> it run over night, in the morning i still didn't got any results, so i
> killed the query).
Chip,
> > I have a database with 12 tables. I am running a query to select certain
> > fields
> > from 3 of the tables, like this -
> >
> > select Title, Details, StartDate, City, State
> > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
> > where phpCalendar_Details.Event
Alex Pukinskis writes:
> mysql> ALTER TABLE 'group' RENAME groups;
> ERROR 1064: You have an error in your SQL syntax near ''group' RENAME
> groups' at line 1
It should be ` (backtick) rather than ' (apostrophe/single quote). This
is explained i the manual section on table/column names if I'm
Hi Florian,
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
> I have this SQL query:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
> tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
> (well, maybe there are more than two columns selected, and maybe a
> little more t
Ah, I finally found mention of this in the manual.
Sorry to bother everyone.
Thanks.
---
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir =
I can't speak for other table formats but in MyIsam tables you can take your
database down, rename the table's files (.frm .MYI .MYD), and restart the
server. I'd make a backup if you are going to try it, though.
Jon Gardiner.
> -Original Message-
> From: Alex Pukinskis [mailto:[EMAIL P
Hello,
I created the entries by adding them manually to the table (not using
GRANT). And yes, I did run FLUSH PRIVILEGES. Anything else I should try
doing? The MySQL manual didn't really provide much help.
Thanks!
Tyler
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECT
Hi,
If I have a SELECT that returns a large number of results, say > 1000, then
returns the results for the SELECT takes much over an order of magnitude longer
than if the results set had been, say, 100.
Now, is there any way I can quickly return the length of the result set withotu
actually ret
Hi all,
I have written to this mailing lists twice before, but nobody seems
responds. Please help, this charset problem is very disturbing.
In my case I need to import text files with "MacRoman encoding" into mysql.
I am working on Mac OS X. How do we get support for this encoding?
Regards,
K
Hi again Florin,
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
> SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
> event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
> tcphdr.cid AND tcphdr.tcp_flags = '2';
Your only search condition i
Hi,All:
I need your help, When I compile the Msql-Mysql-Modules, I got errors, I am
running Redhat7.1 with perl5.6.1, the whole process is just as follows:
[root@wappy local]# cd Msql-Mysql-modules-1.2218
[root@wappy Msql-Mysql-modul
I downloaded and installed the new patch from Borland that allows Kylix to
use versions of MySQL 3.23 and newer. Most of the errors on connection
stopped and it seems to connect. What I am getting now is a
"username/password invalid" error. I have connected with Webmin, MySQL at a
prompt and kmys
1 - 100 of 122 matches
Mail list logo
