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)**
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
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 to
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.
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 problem
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
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 not
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 do a
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
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 is
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 sorted
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 can
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
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
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
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 executable
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 either
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
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
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
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
did
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
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 WORKS:
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!
cut
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 does,
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 are
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
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:
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.8 host.
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
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 between
REGISTE O SEU DOMNIO GRTIS
Se tem um daqueles endereos complicados do tipo,
http://www.endereo.pt/paginas_pessoais/~minha_pagina/index.html, aproveite esta
oportunidade para criar um endereo mais simples e fcil de comunicar, do tipo,
www.minha_pagina.web.pt, SEM PAGAR NADA.
O WEB.PT Free
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
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 trying
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
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 one,
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
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
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
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
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
Configuring for a
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
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 often
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
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.
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 =
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
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 files,
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
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
their Price
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
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
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
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 query to
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
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, Alpha
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 need to
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_table_name
No
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 #1
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 OS
SGI
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
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.EventLocationID =
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 not
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 than two
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
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
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
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,
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 is
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
Hi,
Thanks for your clue. Please provide me with additional details as to how
should I go about doing this (making Mysql use MacRoman encoding).
1)About compiling a particular character set with mysql, the manual says:
MYSQL MANUAL: shell ./configure --with-charset=CHARSET
CHARSET may be one
Hi,
I think indexing the column(s) can help you. But there are certain
criteria before you use indexs (like number of duplicate values in the
column ..blah blah..)
u can find more on this page
http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06article=mysql
i hope this will help you.
Version 3.23.46-max on a dual Xeon RedHat 7.2 machine with all RedHat
patches and their latest -smp kernel.
I turned on binary logging on a particular database with binlog-do-db= and
later try this:
mysqlbinlog -uroot -pxxxyyy binlogfilename-bin.001
It shows me the inserts and deletes that
HELP!!
Can someone PLEASE help me with this issue?
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 12:47 AM
To: '[EMAIL PROTECTED]'
Subject: FW: compile errors
Anyone able to help with this?
I'd like to know if mysql.sock comes with a linux installation as I have
follwed the instructions to install linux but it always says
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) . but mysql.sock does not seem to be
anywhere
on my linux machine
mysql_query (connection, qbuf); seems to hang if the disk is
full. Surely this isn't right. The command line utility
reports disk full but my poor C program hangs never
to return from this call. What's up with that?
(FreeBSD/Whatever version of MySQL was current this summer)
--
With
Hello,
On the same database, this query works:
$SQL_Exec_String = INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link)
VALUES ('prova titolo','prova descrizione','.gif','prova link');;
$cur= odbc_exec( $cnx, $SQL_Exec_String );
This one gives this error:
ISQL_exec_String = Insert Into
Just a thought. 'Label' might be a reserved name on win as it is/was used to
describe the name of a volume (drive).
But then again, maybe not.
George
- Original Message -
From: mweb [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, December 05, 2001 10:45 AM
OOPS...
of couse the query below doesn't work, it doesn't have the table name
(see below however)
ISQL_exec_String = Insert Into (Artista, Opera, Label, Anno, Nazione,
CDNow, Autore, AutoreNome, Genere, GenereCustom, SulWeb, Autorizzato,
Unico, VALUES ('prova2', 'inedita', 'ignota',
1 - 100 of 112 matches
Mail list logo