My configuration:
I am using 4.0.16 compiled with the following configure command on
RedHat Linux 9.0:
> CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql-4.0.16
--enable-assembler --with-mysqld-ldflags=-all-static
I have n
It looks nice. Too bad it's not Linux, yet. Hopefully in 2004.
-Marc
On Fri, 2003-11-14 at 08:51, Daniel Kiss wrote:
> Try SQLyog at www.sqlyog.com
>
> It is pretty good, and full of interesting features.
>
> >I currently use the excellent mysqlfront which is sadly no longer
> >supported.
> >
A HUGE THANK YOU
I had almost given up doing this in a query, it works!
I knew there had to be something like this, just couldn't quite
snag it most of my queries are pedestrian to say the least.
It may be inefficient --and I see why it is-- but would it not be less
so for the dbms to do th
请问，怎么样把文本文件解析出来，然后写入数据库！？就是：C当中的解析器。
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
* Colleen Dick
> This stumped them in PHPbuilder...
>
> I have a table lets call it moms
> each row in the moms table can have many kids,
> and some "kids" have >1 "mom". I have a kid table
> and I have a mxk map table to relate them.
>
> what I want to do is select all the moms and for each mom I
From: Hanon Sinay <[EMAIL PROTECTED]>
Date: Friday Nov 14, 2003 12:24:44 PM America/Los_Angeles
Subject: Unable to open and run "mysqladmin" Mac Os X
File Edit Options Buffers Tools Help
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: wi
* Neil Watson
> I'm thinking about an addressbook database. I would like an opinion on
> my table layout (I still consider myself a mysql newbie):
>
> table user
> uid
> username
> timestamp
>
> table secret
> uid
> secret
> timestamp
You don't mention keys? Why do you want to split the user t
> Finally, if anyone has or knows of a good phone directory already.
> Please point me in the right direction.
Have you considered LDAP? Run it over SSL with TLS - should calm any
security concerns. Outlook (and most any other mail agent for that
matter) can hook into it for address book lookup
* Elisenda
[...]
> The explain select says as follows:
[...]
I re-formatted the query and the EXPLAIN output for readability:
Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio, CE.CE_CP,
CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV, CE.CE_CCAA,
CA.CA_Horario,
PP.PP_Contacto, PP.PP_C
I'm thinking about an addressbook database. I would like an opinion on
my table layout (I still consider myself a mysql newbie):
table user
uid
username
timestamp
table secret
uid
secret
timestamp
table people
pid
uid
firstname
lastname
birthday
timestamp
table address
aid
pid
address
city
provinc
You could try this:
ORDER BY
SUBSTRING_INDEX(TheColumn,'.',1),
SUBSTRING_INDEX(SUBSTRING_INDEX(TheColumn,'.',-2),'.',1)+0,
SUBSTRING_INDEX(TheColumn,'.',-1)+0
It is quite slow though, If possible, I'd suggest splitting that one column
into 3 separate columns. You woudl save space (not deci
On Fri, Nov 14, 2003 at 03:18:49PM -0500, David M. Doggette wrote:
I'm creating a database application for a phone directory for my church.
People are very concerned about security and would like to run the
application locally. Is it possible to distribute a local version of a
How is having a
I'm creating a database application for a phone directory for my church.
People are very concerned about security and would like to run the
application locally. Is it possible to distribute a local version of a
MySQL database without having to install MySQL on the local machine? Or
is there
I've seen this question posted in various forms on the web, but not in
such a way that I have found helpful. I have a column of data in the
following format name.xx.yy where the x's and y's represent numbers.
When selected by mySQL, the column is sorted in an odd way, given by the
following exampl
Can anyone tell me how to structure a query to utilize a subparted index on Innodb?
Haven't found any info on web search. Have an index (AGENT(4),SEARCH_NAME) that works
on the select but breaks on the ORDER BY (using filesort).
To get it to use the index I have to issue something like:
sel
Matt W wrote:
I guess you'll have to see if it's fixed in the next release (4.0.17).
Any clue as to when 4.0.17 will be released?
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can you post the error message you are getting?
-Original Message-
From: Quique Luna [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 4:33 PM
To: [EMAIL PROTECTED]
Subject: Inserting Colons in a Table
Hi,
I'm trying to load some data into a MySql table, but some of the srting
do a show status like 'open_files'
and a show variables like 'open_files_limit'
-Original Message-
From: William Bailey [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: Please help. MySQL Error.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA
Subquerys don't become available until 4.1 Version 3.X does not support
them
>From Mysql.com
For MySQL versions prior to 4.1, most subqueries can be successfully
rewritten using joins and and other methods. See section 6.4.2.11 Rewriting
Subqueries for Earlier MySQL Versions.
Also, if they work
Margrit,
your disk or file system is probably broken:
> InnoDB: Fatal error: cannot read from file. OS error number 17.
17 EEXIST File exists
The error number does not make sense in a file read. Strange.
You cannot remove ib_logfiles from an InnoDB installation. They are as
important as ibdata
Fernando <[EMAIL PROTECTED]> wrote:
>
> In version 3.23.57 when i do a rollback i get this error message and the changes are
> not undone, why?
>
> This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
>
> mysql> SET AUTOCOMMIT=0;
> Query OK, 0 rows affected (0.00
I have a table called journal with the following fields
ID = auto INT
Date = DATE
Order = INT
Entry = TEXT
The table stores journal entries and saves the date that the entry was
entered on. The Order just ells me what order the entries were entered
if there is more than one entry per date.
Margrit Lottmann <[EMAIL PROTECTED]> wrote:
> Why do you refuse to accept my messages.
> I urgently need to send our bug report.
Post bug reports to the bug databse:
http://bugs.mysql.com/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsor
Why do you refuse to accept my messages.
I urgently need to send our bug report.
--
Mit freundlichen Gruessen
M.Lottmann
Otto - von - Guericke Universitaet __ __ _ _ __
Magdeburg / / / / / __ \__ // | / /
---
Am Friday 14 November 2003 14:51 schrieb nm:
> I set a 2-way replication with 2 servers
> One is accessed and used for both select and updates. The other one is
> backup
> set to work through a failover software.. if the first server is down.
> So the backup server can easily update the other serve
Margrit,
fix the problem that leads to OS error number 17.
What does perror tell you about it?
Regards,
Frank.
Margrit Lottmann schrieb:
>
> Following errors we've got by restarting mysqld
>
> 031114 10:26:51 mysqld started
> InnoDB: Fatal error: cannot read from file. OS error number 1
Hi, im using this script to show the query results, basically it shows
multiple results in multiple pages, when more than one result are found it
shows the first one and on the bottom of the pages it shows the number of
pages that remains, but fot some strange reason when you click on the first
or
I am using Innodb Tables but I Like to run this database without
creating any logfiles.
Is there a way that Mysql doesn't create any logfiles at all . I can
recover from a master system so this database can or is allowed to loose
the data
Hi, im using this script to show the query results, basically it shows
multiple results in multiple pages, when more than one result are found it
shows the first one and on the bottom of the pages it shows the number of
pages that remains, but fot some strange reason when you click on the first
Try SQLyog at www.sqlyog.com
It is pretty good, and full of interesting features.
Bye
> I currently use the excellent mysqlfront which is sadly no longer
> supported.
>
> I've tried mysqlcc but it seems non-intuitive, and missing loads of
> features. It also has a problem working with old versi
I set a 2-way replication with 2 servers
One is accessed and used for both select and updates. The other one is
backup
set to work through a failover software.. if the first server is down.
So the backup server can easily update the other server when it comes up
again.
Do you see any collision pos
Following errors we've got by restarting mysqld
031114 10:26:51 mysqld started
InnoDB: Fatal error: cannot read from file. OS error number 17.
031114 10:26:56 InnoDB: Assertion failure in thread 1024 in file os0file.c line 1329
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a deta
Following errors we've got by restarting mysqld
031114 10:26:51 mysqld started
InnoDB: Fatal error: cannot read from file. OS error number 17.
031114 10:26:56 InnoDB: Assertion failure in thread 1024 in file os0file.c line 1329
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a deta
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I am currently getting the following error on one of the mysql servers
im looking after and wonder if anybody knows what specifically it
relates to.
Error in accept: Too many open files
Im currently running MySQL version '4.0.14' under FreeBSD
Roger,
Your help was fantastic. It seems that it goes better. At the end I achieve
some result but not all I need.
The explain select says as follows:
EXPLAIN Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio,
CE.CE_CP, CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV,
CE.CE_CCAA,CA.CA_Hora
Quick question I haven't found in the docs.
I have a column with unicode (utf8 or ucs2) character set.
How can I use a national collation on it? (upper(), lower(), sort order)
None of the examples in the docs work... :(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
I currently use the excellent mysqlfront which is sadly no longer
supported.
I've tried mysqlcc but it seems non-intuitive, and missing loads of
features. It also has a problem working with old versions of mysql
3.23<.47
Or have I missed something, does anyone recommend mysqlcc???
zzapper
--
v
Sohail Hasan <[EMAIL PROTECTED]> wrote:
>
> Is there a possibility that a certain query that is executing in mysql
> by application is not visible by a "show processlist" command. As
> happened in my database a query was taking number of CPU cycles but when
> seen through the show processlist c
"Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> Is is possible to do a select query with a left join from a real table
> to a temporary table?
Yes.
> I'm trying it but keep getting "unkown table
> 'tablename' in field list" error.
Show us you query.
Don't forget that temporary table is visible only
Hi all,
I would like to know who develops and how to obtain libmysql.dll, and is there any
Object Pascal header file for this library, or I have to make my own?
Thanks,
niel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hi All,
Is there a possibility that a certain query that is executing in mysql
by application is not visible by a "show processlist" command. As
happened in my database a query was taking number of CPU cycles but when
seen through the show processlist command nothing was displayed.
shasan
--
Luis Lebron <[EMAIL PROTECTED]> wrote:
>
> I am try to copy a couple of fields from one table to another. Here is my
> query
>
> Insert into users_test (firstName, lastName) Select firstName, lastName from
> users;
>
> The users table has 1,263 rows. However, only 1 row is inserted into
> users_
We used to have a fair amount of data in InnoDB.
Had a few crashes from power failures at a crappy hosting provider.
Everytime the InnoDB engine seemed to detect the crashes and read up its
logfiles and recover.
I've never tried any "manual" InnoDB recovery / data extraction. Are there
methods?
Hi, everyone,
As said in documentation, there is no need to build MySQL with
-rdynamic: "If you want to use an UDF that needs to access symbols from
mysqld (like the methaphone example in `sql/udf_example.cc' that uses
default_charset_info), you must link the program with -rdynamic (see man
Alaios <[EMAIL PROTECTED]> wrote:
> Hi i have just installed the mysql_client
> and i am trying to remotely connect to the database of
> the other pc so i gave the following command
> mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED]
> mysqlshow: Host 'akroneiro' is not allowed to connect
> to this M
Hi,
1.First generate un encrypted certificates. This can be done by using
an Open SSL library. The instructions are available at
http://www.mysql.com/doc/en/Secure_Create_Certs.html
Note: Here un encrypted certificates means certificates that are not
protected by any password. When MySQL code
46 matches
Mail list logo
