Hi Everyone,
I've read the GPL and LGPL and all the crazy legalese that ensues and it's
still not clear - I might be a bit dense. I would like to release a commercial
application that uses Connector/J to connect to a client's own mySQL server
(this I don't provide). I provide only the jav
Mark Sargent wrote:
Hi All,
I get the following message when opening phpmyadmin,
The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration
file!
The mbstring PHP extension was not found and you seem to be using
multibyte charset. Without mbstring extension phpMyAdmin is unable to
sp
Hi All,
I get the following message when opening phpmyadmin,
The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!
The mbstring PHP extension was not found and you seem to be using
multibyte charset. Without mbstring extension phpMyAdmin is unable to
split strings correctly
Mister Jack wrote:
>Hi,
>
>I was wondering if there is any query cache code/lib somewhere to
>cache certains queries ?
>I'm always doing the same queries, (and the result never change, so I
>could spare the round-trip to the server), but caching each tine the
>data for it is a bit of work.
>Thanks
Jeff Smelser wrote:
On Friday 08 April 2005 10:38 am, Chris Scheller wrote:
i have replication going between 2 boxes. the master crashed a few days
ago, and this morning i noticed that the slaves slave thread errored
out. the binary log and offset had changed on the master and the slave
couldn't sy
Hi:
I have this data:
ventas_encabezado_historico_sat Query
VEH_EMPRESA
VEH_TIENDA
VEH_FECHA
VEH_STATUS
VEH_TOTAL
VEH_HORA
DLC
T01
6/1/2003
V
30
8:31:05 AM
DLC
T01
6/1/2003
V
114.28
8:38:44 AM
DLC
T01
6/1/2003
V
63.2
8:41:13 AM
DLC
T01
6/1/2003
V
8.75
8:42:47 AM
dlc
T01
6/1/2003
V
12.35
You can use an IF in a SUM if you add them based on special conditions:
e.g.: SUM(IF(field = 1, field_to_sum, 0))
-Original Message-
From: Kendall Bennett [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 14. April 2005 23:55
To: mysql@lists.mysql.com
Subject: Multiple sums in a single select
Hi Guys,
I am trying to work out if it is possible to create a select statement
that will sum table data into columns with different criteria and have
it all in one select statement. For instance I have the following that
computes the quantity of a product sold within the last 60 days:
select o
One way would be to build a "count" table with one column starting with
value 1 and incrementing by 1 up to say 500 rows or how many your max y
value is. Then just
select seq,val from wibble,count where val between x and y
create table count (val INT unsigned default '0' not null primary key)
I have had this same exact problem. It has forced me to use cancel when
it prompts for the table and input the SQL manually. Basically I connect
to the datasource and hit cancel to the next screen to allow me to enter
the SQL.
I would love to know why this happens as well.
David Norman
Wells F
Hello,
I have a mysql ODBC driver 3.51.11.00 installed on a xp machine in order
to connect to mysql server (on unix) remotely via the ODBC driver. The
ODBC driver was working well. What I am trying to do is to import one of
the mysql table into excel through New Database Query option in Excel.
How
Often times when my replication breaks, it is a quasi monumental task to
re-sync.
Luckily, my replication is occurring on a data warehouse, where the
tables represent each days worth of data. If replication fails, I can
usually, get replication back on track by fixing whatever occurs in the
data/.
On Friday 08 April 2005 10:38 am, Chris Scheller wrote:
> i have replication going between 2 boxes. the master crashed a few days
> ago, and this morning i noticed that the slaves slave thread errored
> out. the binary log and offset had changed on the master and the slave
> couldn't sync up. i got
C.F. Scheidecker Antunes wrote:
Hello all,
I now have disabled my SELinux and so it should work.
However it still does not work.
I have a bunch of errors now on my .err file that I am copying bellow.
I've tried to create the tables again by issuing mysql_install_db and
then
tried to run the daemon
You could probably save a bit of processing time by changing:
concat(date_format(from_unixtime(time), "%d/%m/%Y")," - ",
time_format(from_unixtime(time), "%H:%i"))
to:
date_format(from_unixtime(time), "%d/%m/%Y - %H:%i")
This would mean half the date conversions would be executed.
Separating o
Dear MySQL List,
Is order important when issuing grant commands?
Linux, Fedora Core 3
MySQL server version: 4.1.11-standard, installed via RPM.
perl DBI module installed from CPAN on top of this version.
I am trying to allow all privileges to a given user to a given
database from inside my local
hi,
can MySQL engine connect to databases in any other
database engine ???
i have read that this can be done but i was not
successful with it!! can u tell me how to connect to
such databases. i am trying it through c++ code and
also if the OS will effect that...
regards
sujata
__
At 20:32 +0930 4/14/05, David Lloyd wrote:
David,
Can anyone recommend this book? Or, if not, what book can you
recommend for a newbie.
I always recommend Paul Dubois' New Riders Book:
* http://www.kitebird.com/mysql-book/
Paul's probably lurking on the list. I bought the 1999 edition and I
stil
Fernando Henrique Giorgetti <[EMAIL PROTECTED]> wrote on 04/14/2005
02:34:30 PM:
> Hi Folks!
>
> Here, I have the following table:
>
> CREATE TABLE `accesses` (
> `time` varchar(15) NOT NULL default '',
> `duration` int(10) default NULL,
> `user` varchar(25) NOT NULL default '',
> `ipad
Check out "MySQL Tutorial" by Luke Welling (MySQL Press). It's easy to
understand and not overwhelming.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mahmoud,
>Are these values atomical?
>My other question is what are the repercussions of
>not putting a table in 2nd and 3rd Normal Form.
Your 'choice1-subchoice1' etc are combined values, so they aren't
atomic. From your three example dropdown values, it looks as if
'choice' and 'subchoice'
On Thursday 14 April 2005 20:52, [EMAIL PROTECTED] wrote:
>
> You have to disable those links (or just not present them as options)
> until the user has filled in enough information to create a valid Product
> record.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
Th
It sounds like you are looking to do an INSERT SELECT.
http://dev.mysql.com/doc/mysql/en/insert-select.html
It allows you to insert into one table based on a select from another
table. That will take care of creating your history. You then need to
do an update on the main table. It's still a two
Andy Pieters <[EMAIL PROTECTED]> wrote on 04/14/2005 12:55:20 PM:
> Hi all
>
> I will first set out what I need and then why I need it. Since I'm
currently
> implementing I can still change stuff.
>
> I have a product input form that stores the information in a table.
> The product can be ass
Hello,
I have two questions:
I would like to know whether I am violating the principle of atomicity in
doing the following:
I have a form which has a field with the following options: Choice1, choice2
and choice3.
Each of the above choices have two further subchoices : subChoice1,
subchoice2.
From: Fernando Henrique Giorgetti [mailto:[EMAIL PROTECTED]
> Hi Folks!
>
> Here, I have the following table:
>
> CREATE TABLE `accesses` (
> `time` varchar(15) NOT NULL default '',
> `duration` int(10) default NULL,
> `user` varchar(25) NOT NULL default '',
> `ipaddr` varchar(15) NOT N
From: Fernando Henrique Giorgetti [mailto:[EMAIL PROTECTED]
> Hi Folks!
>
> Here, I have the following table:
>
> CREATE TABLE `accesses` (
> `time` varchar(15) NOT NULL default '',
> `duration` int(10) default NULL,
> `user` varchar(25) NOT NULL default '',
> `ipaddr` varchar(15) NOT N
Hi Folks!
Here, I have the following table:
CREATE TABLE `accesses` (
`time` varchar(15) NOT NULL default '',
`duration` int(10) default NULL,
`user` varchar(25) NOT NULL default '',
`ipaddr` varchar(15) NOT NULL default '',
`result` varchar(30) default NULL,
`bytes` int(10) default N
I am running MySQL-server-4.1.8-0 without problem on FC3.
This could also be hardware related.
Joey
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 1:24 PM
To: Mysql List
Subject: Still having problems with MySQL 4.1 on Fedora
Hello all,
I now have disabled my SELinux and so it should work.
However it still does not work.
I have a bunch of errors now on my .err file that I am copying bellow.
I've tried to create the tables again by issuing mysql_install_db and then
tried to run the daemon.
Is there any ideias on how to f
Hello,
I am currently looking at moving some of my FoxPro tables to a MySQL
implementation and I am hoping someone can help me with how to do the
following.
In my current code, whenever anyone makes a change to a row the original
value of the row is written to a history table with the same name w
Hi all
I will first set out what I need and then why I need it. Since I'm currently
implementing I can still change stuff.
I have a product input form that stores the information in a table.
The product can be assigned different categories and what categories it is
assigned is saved in the pro
Sounds like this is what you want:
http://dev.mysql.com/doc/mysql/en/handler.html
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Wed, 13 Apr 2005, Homam S.A. wrote:
> Is there a way to use dirty reads (that acquire no
> read locks on the table) with MyISAM tables?
>
> I want to avoi
"A. Clausen" <[EMAIL PROTECTED]> wrote on 04/14/2005 12:19:05 PM:
> I'm running MySQL 3.23.58 on a Win2k server with multiple IP addresses
and
> I'm wondering whether there is a way to limit the MySQL server to
answering
> on just one IP address.
>
> --
> A. Clausen
>
>
Yes. http://dev.mysql
In your my.cnf, put a "bind-address" directive:
bind-address=xxx.xxx.xxx.xxx
Christian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Graham Anderson <[EMAIL PROTECTED]> wrote on 04/14/2005 11:51:58 AM:
> many thanks
> that was exactly what I needed.
>
> Building upon the initial question:
> Is there a way to get Match statements to do partial word
> searches...like %LIKE% ?
>
> For example, if the below Match Against que
I'm running MySQL 3.23.58 on a Win2k server with multiple IP addresses and
I'm wondering whether there is a way to limit the MySQL server to answering
on just one IP address.
--
A. Clausen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
many thanks
that was exactly what I needed.
Building upon the initial question:
Is there a way to get Match statements to do partial word
searches...like %LIKE% ?
For example, if the below Match Against query with 'chris' does not
bring up anything...
AND MATCH (
media.name, media.product
)
> I have successfully configured mysqld_multi to have mysql 4.1.11 and
> 5.0.3 beta running on the same machine:
>
I would like to see how you configured mysqld_multi to do that, if you could
send me the information off list I'd appreciate it.
> # mysqld_multi start &
> # exit
> % mysqld_multi re
Hi All,
I've installed phpmyadmin and have a snort database in mysql, but, it
doesn't appear in phpmyadmin. I know it's there, because base is using
it to display info from snort on the machine. Why wouldn't it appear in
phpmyadmin. It appears with the same set up on my work test machine.
What
We have a large OS X MySQL deployment on multiple servers and we have
experienced a range of weirdness with table corruption that I was never able
to fully determine the cause for.
Moving to G5 Xserves (from G5 Towers and G4 Xserves) has seen all the
problems go away as if a switch were thrown. I
Ludovic Coumétou wrote:
Hello,
I have been googling and asking on several forums with no luck, so I'm
coming here for the ultimate answer :) eheh
Is there a way to spell check a mysql column (or at least table)?
Thanks in advance
Ludovic
Several.
1. Dump - spell check - reload.
2. Write a progra
Dana Terrell wrote:
I am new to MySql and I am having troubles getting the primary keys to do
what I want. Here is the situation.
I am building a database where there are 2 types of users that can access
and change information. Because each type of user will be accessing a
different part of the d
Hello,
I have been googling and asking on several forums with no luck, so I'm
coming here for the ultimate answer :) eheh
Is there a way to spell check a mysql column (or at least table)?
Thanks in advance
Ludovic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
Perl and GD would do the trick.
Take a look at how RDDtools does it!
Andy
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 11:08 PM
To: prathima rao; mysql@lists.mysql.com
Subject:Re: graphs
prathima rao wrote:
>hello,
>
>
Yemi Obembe wrote:
learnt SQL_BIG_RESULT in the select syntax builds a temporary table
on the result (if I'm right). What will the Select statement to
access such temporary table look like?
This is an internal temporary table, the result is returned in the
normal way, and the temporary table is de
Yemi Obembe wrote:
If for example I have a table with the 3 columns: name,age,sex & I
build an index table
"index table" ? There is no such thing.
on the column 'name'. how can i get result of
the other rows (i.e age and)
other rows? You mean other columns?
from the main table
What main tabl
hi list,
im a newbie around here. i'v gone through some parts of the mysql
documentation. however, i'd like to know the meaning of spatial, clustered and
unique table types. or is it column types?
-
A passion till tomorrow,
Opeyemi Obembe | ng.clawz.com
On Thu, 14 Apr 2005 11:57:50 +0100
"Andrew Braithwaite" <[EMAIL PROTECTED]> wrote:
> Thanks for the idea,
>
> Unfortunately I can't do that as the ranges involved are unknown and
> will be from 1 to several billion at lease. I can't have another table
> that needs to be augmented each time my ra
I am new to MySql and I am having troubles getting the primary keys to do
what I want. Here is the situation.
I am building a database where there are 2 types of users that can access
and change information. Because each type of user will be accessing a
different part of the database, I wanted
If for example I have a table with the 3 columns: name,age,sex & I build an
index table on the column 'name'. how can i get result of the other rows (i.e
age and) from the main table if i 'select' a name from the main table?
In short, what is the structure(or should i say syntax?) of a select
If for example I have a table with the 3 columns: name,age,sex & I build an
index table on the column 'name'. how can i get result of the other rows (i.e
age and) from the main table if i 'select' a name from the main table?
In short, what is the structure(or should i say syntax?) of a select
Not sure if your query works. But what should work is
SELECT * FROM table WHERE c LIKE "%word1%" and c LIKE "%word2%" and c LIKE
"%word3%";
But might be slow ...
Am Thursday 14 April 2005 13:53 schrieb Micha Berdichevsky:
> Hi group.
> I have a table with a varchar(250) column in it (let's call
learnt SQL_BIG_RESULT in the select syntax builds a temporary table on the
result (if I'm right). What will the Select statement to access such temporary
table look like?
-
A passion till tomorrow,
Opeyemi Obembe | ng.clawz.com
---
I think that if you explode your words with AND it should work in any order:
SELECT * FROM table WHERE c LIKE '%word1%' AND c LIKE '%word2%' AND c LIKE
'%word3%';
but there's maybe something better to do!
From: Micha Berdichevsky <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: LIKE questi
Micha Berdichevsky <[EMAIL PROTECTED]> wrote on 14/04/2005 12:53:31:
> Hi group.
> I have a table with a varchar(250) column in it (let's call it c)
> I want to select values that contain a number of given words in them
> (three or more), in any words order
> I currently use
> SELECT * FROM table
Thanks for the idea,
Unfortunately I can't do that as the ranges involved are unknown and
will be from 1 to several billion at lease. I can't have another table
that needs to be augmented each time my ranges change.
Any other ideas?
Cheers,
Andrew
-Original Message-
From: Paul B va
David,
> Can anyone recommend this book? Or, if not, what book can you
> recommend for a newbie.
I always recommend Paul Dubois' New Riders Book:
* http://www.kitebird.com/mysql-book/
Paul's probably lurking on the list. I bought the 1999 edition and I
still refer to it :)
DSL
--
MySQL Gen
I, for one, don't have the time to work my way through your entire note;
there's just too much involved to be able to spare that much time from more
urgent work.
May I suggest that you resolve the problem *indirectly* by paring the
situation down to the absolute smallest and simplest model you can
Hi group.
I have a table with a varchar(250) column in it (let's call it c)
I want to select values that contain a number of given words in them
(three or more), in any words order
I currently use
SELECT * FROM table WHERE c LIKE "%word1%word2%word3%";
I was wandering if it is possible to use a qu
Hi,
I was wondering if there is any query cache code/lib somewhere to
cache certains queries ?
I'm always doing the same queries, (and the result never change, so I
could spare the round-trip to the server), but caching each tine the
data for it is a bit of work.
Thanks, for your suggestions
--
M
Hi,
In SQL you need to define the data that you want to work with:
create table z ( z int(5) not null primary key);
insert into z values
(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22);
If you need more values you could use a simple perl loo
I use = 0. It works for me.
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Emil Wilmanski" <[EMAIL PROTECTED]>
To:
Sent: Thursday, April 14, 2005 11:19 AM
Sub
Hi...
I have problem with update query. Select query with the same "where" is
OK.
mysql> select AcctStartTime,AcctSessionTime from radacct where
AcctStopTime is null;
+-+-+
| AcctStartTime | AcctSessionTime |
+-+-+
| 20
> > Hi,
> >
> > I'm a newbie and looking for a book to help me learn mysql. I have come
> > across a book called "Beginning MySQL" by Robert Sheldon and Geoff Moes.
> >
> > Can anyone recommend this book? Or, if not, what book can you recommend
> > for
> > a newbie.
If there is a big college near
Hi David;
I can recommend any Paul Dubois books but especially the
Certificate study guide which basically is free if you consider taking
the exam. The book comes with a 50$ voucher for the exam if I remmember
that correctly + it is one of the best books to get up and running as fast
as possibl
It's official. I need help ;)
Let's do the table structures quickly.
mysql> DESCRIBE FlightData;
+---+--+--+-+-++
| Field | Type | Null | Key | Default
| Extra |
+-
Hello.
What is in error log? See:
http://dev.mysql.com/doc/mysql/en/error-log.html
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Jason Johnson <[EMAIL PROTECTED]> wrote:
> I am running MySQL 4.1.8 on Windows 2000. Sporadically, the service
> will stop. It does no
68 matches
Mail list logo
