Rhino wrote:
From: "Ravi Malghan" <[EMAIL PROTECTED]>
Hi: I am building perl scripts which can insert data into a database
independent of the type of database. The following query works in
postgresql, but I am getting the following error when I run sql query in
mysql
mysql> SELECT ipaddress FRO
On 27-Apr-2004 Paul DuBois wrote:
> At 13:29 -0400 4/27/04, Keith C. Ivey wrote:
>>On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
>>
>>> OK, I understood it, but I didn´t understand why is there an
>>> option
>>> TINYINT(n)
>>
>>See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
>>
>>| Ano
On 27-Apr-2004 zzapper wrote:
> On Tue, 27 Apr 2004 22:26:16 +0100, wrote:
>
>>I only use mysql with php so all I need is
>>
>>php code:
>>$result = mysql_query($sql) or die(mysql_error());
>>
>>This always tells me what I did wrong in the query. You could easily
>>put
>>together a very short s
hi,
i have a small table with one field that i created to test.i took a backup
of database using this stmt:
>mysqldump --user= --password= db> db.sql
now i am trying to run this sql file in oracle sqlplus and i am not able to .
it doesnt create the table again and i get syntax errors.
H
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 April 2004 01:40 pm, zzapper wrote:
> Hi,
>
> Anyone designed a MySql database for family history?
>
> Any ideas,recommendations, problems ?
I know I've seen a few people with Gedcom to mysql stuff. So I'd use that as
a basis for searc
- Original Message -
From: "Ravi Malghan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 6:34 PM
Subject: sql error
Hi: I am building perl scripts which can insert data into a database
independent of the type of database. The following query works in
postgre
Hi: I am building perl scripts which can insert data into a database independent of
the type of database. The following query works in postgresql, but I am getting the
following error when I run sql query in mysql
mysql> SELECT ipaddress FROM ip_via_pingsweep WHERE ipaddress NOT IN (SELECT ipadd
I'm trying to compile 4.0.18 version on Aix 5.2 ML2 (IBM 7044-270 with Two
cpu Power3-II), with gcc-2.95 with this parameters(note in mysql.com):
CC="gcc -pipe -mcpu=powerpc -Wa,-many" \
CXX="gcc -pipe -mcpu=powerpc -Wa,-many" \
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti" \
/configur
If I'm using mysqldump to dump a database with referential integrity in place, does
MySQL build the information in such a way that the referenced tables are loaded first
to avoid invalid inserts into a table with a foreign key in place? I'm trying to find
an option for mysqldump, and the closes
But I think the collation set only applies to MySQL
4.1, doesn't it? I'm using MySQL 4.0.16.
I found no "character_set_server" system variable.
Only "character_set".
http://dev.mysql.com/doc/mysql/en/Charset-map.html
Thanks.
--- Jochem van Dieten <[EMAIL PROTECTED]>
escreveu: > Ricardo wrote:
Ricardo wrote:
Which collation are you using in MS SQL Server? And
in MySQL?
MS SQL Server 8
Collation = Latin1_General_CI_AS
MySQL 4.0.16
character_set = latin1
The charset determines which characters can occur. The collation
determines the sort order. What is the collation in MySQL?
http://dev
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 2:02 PM
Subject: urgent: how to increase the database size
[snip]
> Moreover if someone can provide me the maximum size of the database which
> is possible.
>
Have you tried looking i
Here is a basic question I am struggling to find an answer. I want to run
mysql under solaris. Security is not a great concern to me and only one
application accesses the database locally. I don't have and can't get the
root access to the machine. Also, I can't create mysql user and groups on
t
On Wed, Apr 28, 2004 at 02:51:50PM -0400, Mihail Manolov wrote:
> Does anybody knows if User Conference' presentations were published
> somewhere on the web? I was told that it will be done shortly after
> the conference, and it is more than a week after the conference
> end...
They will be publis
Hello,
Does anybody knows if User Conference' presentations were published
somewhere on the web? I was told that it will be done shortly after
the conference, and it is more than a week after the conference
end...
Thank you,
Mihail Manolov
___
Solutions Architect
Government Liquidat
jim wrote:
One solution would be to use a variable:
SELECT @latest:= MAX(dateCreated);
Here I am getting the errors:
mysql> SELECT @latest:= MAX(dateCreated);
ERROR 1054: Unknown column 'dateCreated' in 'field list'
mysql> SELECT @latest:= MAX(user.dateCreated);
ERROR 1109: Unknown table 'use
> Which collation are you using in MS SQL Server? And
> in MySQL?
>
> Jochem
MS SQL Server 8
Collation = Latin1_General_CI_AS
MySQL 4.0.16
character_set = latin1
__
Yahoo! Messenger - Fale com seus amigos online. Instale agora
Hi,
I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone can provide me the maximum size of the databa
> jim wrote:
>
> > Hi,
> >
> > The task is to find users whose accounts have not been validated for the
> > last 10 days. This SELECT accomplishes that:
> >
> > SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <=
> > DATE_SUB(CURDATE(), INTERVAL 10 DAY)
> >
> > But, using curdate()
jim wrote:
Hi,
The task is to find users whose accounts have not been validated for the
last 10 days. This SELECT accomplishes that:
SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <=
DATE_SUB(CURDATE(), INTERVAL 10 DAY)
But, using curdate() is dangerous. What if the system time is
I would suggest using mysqldump to ensure that you get all the data. Install
a new version of MySQL then run mysql < dumpFile.sql
-Original Message-
From: Thomas Carrié
To: [EMAIL PROTECTED]
Sent: 4/28/04 11:09 AM
Subject: Can I backup mysql db file directly ?
Hi,
I would like to backu
Open the port in the firewall
...
GRANT SELECT ON database_name.table_name TO user_name@'%' IDENTIFIED BY
'some_password';
...
If you are going to do this, may I suggest starting MySQL with a non
standard port number?
-Original Message-
From: shaun thornburgh
To: [EMAIL PROTECTED]
Sent: 4
Thanks for the message. I should rephrase - the data set is millions of
rows, but the tables are indexed, and an EXPLAIN looks like it is using
indexes effectively. The query produces the exact same results both
times (with and without LOCKing). Is there a reason that by calling the
query vi
Hi,
I would like to backup a mysql database called foodb
Supposed that I have backuped just the file /var/mysql/foodb and that I
have completly lost my hard drive.
Can I recover data from the foodb file ?
If yes, how ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
I'm afraid I don't understand. From your first message, it appears you want
a list of rows from table1 whose ids do not appear in table2. The query
Egor sent you does just that. Did you try it? If, as you say here, that
isn't what you want, could you please describe what you do want?
Michae
On Tue, 27 Apr 2004, Scott Switzer wrote:
> Hi,
>
> I am having a difficult time with a query. My environment is MySQL
> v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
> Basically, I am running a query of the form:
>
> INSERT INTO temp_tbl
> SELECT c1,c2...
> FROM t1,t2,t3,t4
> WHE
Hi,
The task is to find users whose accounts have not been validated for the
last 10 days. This SELECT accomplishes that:
SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <=
DATE_SUB(CURDATE(), INTERVAL 10 DAY)
But, using curdate() is dangerous. What if the system time is messed
up?
Ricardo wrote:
The order should be:
fa
Fa
fá
Fá
fâ
Fâ
fã
Fã
As I get in MS-SQL Server.
Which collation are you using in MS SQL Server? And in MySQL?
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Tom,
More specifically, find out what the error messages means by using the
`SHOW INNODB STATUS` command. This will give a description of the last
error message generated by InnoDb. In your case, its definitely the
foreign key that is causing the problem. As far as what it is
specifically, I'd
Thanks! Now I can get it to work just the way I want it.
... and learned how to use IF and CASE statements with MySQL at the same
time! :)
Oh, and it's actually precisely because FIM doesn't exist anymore that I
want to convert it to euro. ;) (And SEK just comes along for the ride.)
Harald Fuch
The order should be:
fa
Fa
fá
Fá
fâ
Fâ
fã
Fã
As I get in MS-SQL Server.
> --- Victor Pendleton <[EMAIL PROTECTED]>
escreveu:
> It does not appear to respect the ascii values.
> Should the order be?
> fa
> fá
> fâ
> fã
> fa
> fá
> fâ
> fã
It does not appear to respect the ascii values.
Should the order be?
fa
fá
fâ
fã
fa
fá
fâ
fã
-Original Message-
From: Ricardo
To: [EMAIL PROTECTED]
Sent: 4/28/04 10:05 AM
Subject: RE: SELECT DISTINCT returns an incorrect result with special char
acters
- The sort order gets incorrect:
SE
Hi,
I have installed mysql 3.23 on our Windows 2000 Server machine. How can I
configure the database such that anyone on the internet can connect to this
database? I know this sounds dangerous but once this has been configured we
will install VPNs on this machine and any machine that we permit
latin1
>--- Egor Egorov <[EMAIL PROTECTED]> escreveu:
> What is the character set of the data? What is the
> character set of MySQL server?
>
>
>
> --
> For technical support contracts, goto
> https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net
> http://www.ensita.net/
- The sort order gets incorrect:
SELECT DISTINCT BINARY(MyField)
FROM MyTable
WHERE MyField LIKE 'f%'
ORDER BY MyField
+-+
| BINARY(MyField) |
+-+
| fa |
| Fâ |
| fá |
| Fa |
| fã |
| Fá
I'm trying to build RPMs from Mysql Cluster, yes the alpha version, but I
run into this problem... no .so -files. What I'm missing here? I'm using
redhat 9 source rpm as my starting point.
Harri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Why can you not write
SELECT DISTINCT BINARY(col)
FROM table1
WHERE BINARY(col) LIKE 'criteria'
ORDER BY col
?
-Original Message-
From: Ricardo
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 4/28/04 9:33 AM
Subject: RE: SELECT DISTINCT returns an incorrect result with special char
acters
Ricardo <[EMAIL PROTECTED]> wrote:
> I have a problem with SELECT DISTINCT if the target
> field contains special characters.
>
> Example:
>
> select MyField from MyTable
> +--+
> | MyField |
> +--+
> | f? |
> | F? |
> | fa |
> | Fa |
> | f? |
>
Thanks Mr. Pendleton.
But I cannot change the behaviour of the LIKE operator
and the ORDER BY clause, which are going to be
affected by both of your suggestions.
--- Victor Pendleton <[EMAIL PROTECTED]>
escreveu:
> Try
> SELECT DISTINCT BINARY(col)
> ...
> Or declare the column as binary
___
Try
SELECT DISTINCT BINARY(col)
...
Or declare the column as binary
-Original Message-
From: Ricardo
To: [EMAIL PROTECTED]
Sent: 4/28/04 9:02 AM
Subject: SELECT DISTINCT returns an incorrect result with special characters
I have a problem with SELECT DISTINCT if the target
field contain
I have a problem with SELECT DISTINCT if the target
field contains special characters.
Example:
select MyField from MyTable
+--+
| MyField |
+--+
| fá |
| Fá |
| fa |
| Fa |
| fâ |
| Fâ |
| fã |
| Fã |
+--+
select dist
Hi Andy,
The best way to accomplish this is at an application level, setup a
lock table and put your locks in there. There are many methods for
handling application locks. Choose one that work for you. With a
database level lock, when the connection terminates the lock is
released.
Persistant c
Andy Ford wrote:
I have a perl cgi script that needs to lock the tables. Unfortunately,
as HTTP is a one shot protocol, once the cgi script completes execution,
the tables are unlocked.
I need it to stay locked until another cgi script unlocks them!
Is there any other way of achieving this!?
You c
I have a perl cgi script that needs to lock the tables. Unfortunately,
as HTTP is a one shot protocol, once the cgi script completes execution,
the tables are unlocked.
I need it to stay locked until another cgi script unlocks them!
Is there any other way of achieving this!?
Thanks
Andy
--
Dyego Souza Dantas Leal <[EMAIL PROTECTED]> wrote:
> Hello Guys !!!
>
> I'm want to solve this problem with the replication :
>
>
> MASTER <- SLAVE OF MASTER <- SLAVE OF SLAVE 1
>
> The replication on MySQL supports this "schema" ?
>
> Exists a possibility to use Slave of Slave on Replication
Can you run a find and replace to double up the backslashes?
\ --> \\
-Original Message-
From: Hans van Dalen
To: [EMAIL PROTECTED]
Sent: 4/28/04 3:46 AM
Subject: mysqlimport and "\" as data
Hi Group,
Does anybody have any expierence with mysqlimport and a comma separated
file with data
This daisy-chained master scenario is possible.
-Original Message-
From: Dyego Souza Dantas Leal
To: [EMAIL PROTECTED]
Sent: 4/28/04 6:47 AM
Subject: The MySQL Replication...
Importance: High
Hello Guys !!!
I'm want to solve this problem with the replication :
MASTER <- SLAVE OF MASTER
Have the ib* files been removed or damaged? Depending on your configuration,
these coulde exists in your mysql data directory.
-Original Message-
From: Ville Mattila
To: [EMAIL PROTECTED]
Sent: 4/28/04 5:28 AM
Subject: Repairing InnoDB table
Hello,
I have a database using a few InnoDB t
The backslash, `\` is an escape character. Four backslashes, path will
be recognized as \\path in MySQL.
-Original Message-
From: Nik Belajcic
To: [EMAIL PROTECTED]
Sent: 4/28/04 1:38 AM
Subject: load strips first character
Hello,
I am loading data from a text file where filed3 is a
Hello Guys !!!
I'm want to solve this problem with the replication :
MASTER <- SLAVE OF MASTER <- SLAVE OF SLAVE 1
The replication on MySQL supports this "schema" ?
Exists a possibility to use Slave of Slave on Replication ?
The Insert is STORED on MASTER and REPLICATED to SLAVE1 and REPLIC
Thanks your help, but I would like to do the following:
If I have is ONE same ID between the two tables, than the result it must
be "empty".
Egor Egorov <[EMAIL PROTECTED]>
2004-04-28 12:10 PM
To: [EMAIL PROTECTED]
cc: (bcc: Zoltan Gyurasits/GYO/COMP/PHIL
Hello,
I have a database using a few InnoDB tables. The database has not been
in use for a while and now I noticed that all InnoDB tables in the
database cannot be opened and used at all. Whatever I try to do, I got
"Can't open asiakkaat.InnoDB (errno: 1)" error. I'd like to know, how
could I
[EMAIL PROTECTED] wrote:
>
> I have a query problem. I want to make a query
>
> SELECT*
> FROM table1
> INNER JOIN table2 ON table1.id NOT IN table2.id
>
> But I can't use the "NOT IN" expression here.
>
> What can i do?
>
> I have the MySQL version 4.x I can't use subquery :(
>
If I
Hi,
Deeply appreciated your helps.
(See attached file: failed_mysql_report)
S.C. Lin 林聖哲
Taiwan Semiconductor Manufacturing Company, Ltd.
No. 6, Li-Hsin Rd.6, Science-Based Industrial Park Hsin-Chu, Taiwan 300-77,
R.O.C.
Tel: 03-666
Ext: 4770
[EMAIL PROTECTED]
--
MySQL General Mailing List
Hi,
I have a query problem. I want to make a query
SELECT*
FROM table1
INNER JOIN table2 ON table1.id NOT IN table2.id
But I can't use the "NOT IN" expression here.
What can i do?
I have the MySQL version 4.x I can't use subquery :(
Thank you in advanced,
Zoli
A Z <[EMAIL PROTECTED]> wrote:
> the following raises error:150. Does this mean we
> cannot do this in INNODB format?
>
> create table t1 (a1 integer not null, b1 varchar(36),
> primary key (a1), foreign key (b1) references t2(b1)
> on delete cascade) TYPE=INNODB
>
Column b1 must be indexed.
the following raises error:150. Does this mean we
cannot do this in INNODB format?
create table t1 (a1 integer not null, b1 varchar(36),
primary key (a1), foreign key (b1) references t2(b1)
on delete cascade) TYPE=INNODB
regards
_
Hi there,
I'm trying to compile the MySQL 3.23.52 source distribution on
Slackware 9.1. I'm using g++ (GCC) 3.2.3 and, I think, I've got all
the required shared libraries installed. `./configure' exits OK, but
`make' exits with an error while building the mysql client:
|mysql.o(.text+0x1b29): In
>Description:
I'm experiencing a Linux-related only problem with a simple UDF which call
mysql_real_connect()
>How-To-Repeat:
A very simple function:
#include
#include
#include
>is it possible to suppress (i.e. not display) the column names
>from the resultset of a select statement? if so, how?
What about only selecting the columns you need?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Producti
Hi Group,
Does anybody have any expierence with mysqlimport and a comma separated
file with data wich contains field data with a: \. For example I have the
data in de column path: C:\temp.
When I import this I got something like : c:||emp ...
Does anybody know how to solve this problem? This \
"Tom Roos" <[EMAIL PROTECTED]> wrote:
> is it possible to suppress (i.e. not display) the column names from the resultset of
> a
> select statement? if so, how?
For command-line mysql client use --skip-column-names (-N) option:
http://dev.mysql.com/doc/mysql/en/mysql.html
--
For techn
Andy Jefferson <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm using MySQL 4.0.15 and have been trying to use EXISTS/NOT EXISTS ...
> with no success - getting "You have an error in your SQL syntax".
>
> I've got 2 tables A and B and am trying something like this
>
> SELECT THIS.A_ID FROM A THIS
> WHE
"zzapper" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> On Tue, 27 Apr 2004 15:47:19 -0400 (EDT), wrote:
> >>Anyone designed a MySql database for family history?
This http://members.shaw.ca/pythiangenealogy/ site has a MySQL based
genealogy program. The program is shareware, but
> Does EXISTS exist in 4.0.15 ? or is it introduced in 4.1.*. If it does
> exist, what is incorrect in the syntax above ? (it matches the MySQL
manual
> example from what I can see).
Subqueries (http://dev.mysql.com/doc/mysql/en/Subqueries.html) were only
introduced in version 4.1, so I don't thin
On Tue, 27 Apr 2004 15:47:19 -0400 (EDT), wrote:
>>Hi,
>>
>>Anyone designed a MySql database for family history?
>>
>>Any ideas,recommendations, problems ?
>
>You can try asking the GRAMPS team (http://www.gnu.org/directory/gramps.html). I
>seem to remember that they are playing around with usin
Hi,
I'm using MySQL 4.0.15 and have been trying to use EXISTS/NOT EXISTS ...
with no success - getting "You have an error in your SQL syntax".
I've got 2 tables A and B and am trying something like this
SELECT THIS.A_ID FROM A THIS
WHERE NOT EXISTS
(SELECT THIS_ITEMS.B_ID FROM B THIS_ITEMS WHE
'lo
is it possible to suppress (i.e. not display) the column names from the resultset of a
select statement? if so, how?
tks
tom
Disclaimer
http://www.shoprite.co.za/disclaimer.html
68 matches
Mail list logo