QL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
List-Unsubscribe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ted
L.
--- End of forwarded message ---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
res.
Thanks a lot
Stefano
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
) UNSIGNED NULL,
c_id INTEGER(6) UNSIGNED NULL,
PRIMARY KEY(pc_id),
INDEX pc_index(p_id, c_id),
);
Or, there is better solution?
Thanks!
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
got a point. And I got the answer.
And "ac_products_categories" table doesn't have any other association.
It doesn't matter who, when, why added a prodcut to particular category.
Thanks Shawn.
[EMAIL PROTECTED] wrote:
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10
OT NULL,
product_id INTEGER(8) NOT NULL,
product_type ENUM('regular','sale') NOT NULL DEFAULT 'regular',
PRIMARY KEY(price_id),
INDEX ac_prices_index1(price)
);
How "close" am I?
:)
[EMAIL PROTECTED] wrote:
"[EMAIL PROTECTED]" <[EMAIL P
course wrinkles multiply as if conjured by a Sorcerer's Apprentice.
Perhaps we should pause here for a breath. Is this the info you need?
PB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No. It doesn't work. First, I found one error: there are two columns for
same thing in ac_products ac_products_product_id and product_id.
Second, ac_extended_prices table doesn't fit with multiple solutions
:(
[EMAIL PROTECTED] wrote:
Thanks guys for really detailed answers.
6
sale price: $5.95
Right now, with "my" solution, administrator has to turn on/off "on
sale". I need to automate this by start and end dates for sale.
Any ideas?
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e_id);
UPDATE prices SET sale_price = '6.83' WHERE price_id = $price_id);
UPDATE prices SET sale_price = '6.75' WHERE price_id = $price_id);
UPDATE prices SET sale_price = '5.22' WHERE price_id = $price_id);
Does it make a sense?
-afan
Peter Brawley wrote:
afan,
Thanks Shawn.
See comments:
[EMAIL PROTECTED] wrote:
Sorry I didn't get back to you earlier today. I have had a busy day.
Comments embedded...
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/20/2005 04:35:30 PM:
Could you please tell me should this work?
CR
Trans_No DESC
LIMIT 100
I'm NOT getting any error but either any result (entry)?
What am I doing wrong?
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s_No DESC
LIMIT 100
It works for me.
Regards!
-----Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 03 de Noviembre de 2005 03:55 p.m.
Para: MySQL List
Asunto: report from two tables
Hi,
I have two table for orders and I have to create a Report with list
help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* only entry no. 13 will be shown.
If I search for *AFAN* only entry no. 14 will be shown.
?!?
Thanks.
-afan
Jasper Bryant-Greene wrote:
[EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Your two statements
: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
give me a solutions.
--
Regards
Abhishek jain.
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a way i can convert the strings converted from old password to
passwords one.So that it become compatible to the passwords one.
--
Abhishek jain
Original Message:
-
From: Ryan Stille [EMAIL PROTECTED]
Date: Wed, 18 Jan 2006 08:03:14 -0600
To: [EMAIL PROTECTED]
Subject: RE
://lists.mysql.com/[EMAIL PROTECTED]
jain
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
? If not, what other approaches could I use, triggers ...?
Kinf regards.
Prueba el Nuevo Correo Terra; Seguro, Rápido, Fiable.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
m running MySQL 5.x on
Opteron machine with FreeBSD 6.0-STABLE.
Ganbold
Thanks
JK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
Can I return a record set from a stored procedure/function in mysql?
Kind regards
Prueba el Nuevo Correo Terra; Seguro, Rápido, Fiable.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
om/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
whether the command timeout has expired or not
and so act accordingly.
I guess I can use some sort of integer in order to represent it as a unix
timestamp, but I would prefer to use a "timestamp".
Any suggestions?
Kind regards
Mensaje original
De: [EMAIL PROTECTED]
Recibido:
PROTECTED] dan [EMAIL PROTECTED]
Maklumat lanjut sila layari http://amagro.blogspot.com
Terima Kasih diatas kesudian anda membaca email ini.
Sudi-sudikan lah forward email ini kepada kenalan yang berminat.
Harap bertemu anda di Melaka
ave: 'no error' (0). Default
database: 'opnser'. Query: 'insert into acc
(method,from_tag,to_tag,callid,sip_code,sip_reason,time,ani,did,dnis )
values
('BYE','3405618788-778336','516B0D10-1448','[EMAIL PROTECTED]
hnl.aloha.net','200
e not all the same length. Are you
> padding them with leading zeroes to five characters?
>
> If you have padded them so that the first five characters are always the
> country code, then you can simply do
>
> SELECT
>
>> -----Original Message-
>> From: Ron [ma
Hi,
What's in the bin-logs? (mysqlbinlog )
cheers,
Doug
Original Message:
-
From: David Giragosian [EMAIL PROTECTED]
Date: Wed, 17 Sep 2008 12:38:01 -0500
To: mysql@lists.mysql.com
Subject: Show Master Status
Hurricane Ike has caused our replication set-up to misb
Thanks a lot for any suggestions
Yannis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
f there is more optimised solution
Thanks a lot
- Original Message
From: Tim Lucia <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Saturday, November 11, 2006 3:56:49 PM
Subject: RE: MAX() and GROUP BY question
How about
select ID, X, Y, Z from USERS order by ID desc limit 1
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
vinstallコマンドでMySQLをインストールできるはずなのですが
インストールはできてもrootでのアクセスができません。
mysqlというユーザではアクセスできますが、rootのパスワードを
リセットしようとすると権限エラーが出ます。
何かこのような場合のヒントをいただけませんでしょうか。
お手数をおかけいたしますがどうぞよろしくお願いいたします。
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
vinstallコマンドでMySQLをインストールできるはずなのですが
インストールはできてもrootでのアクセスができません。
mysqlというユーザではアクセスできますが、rootのパスワードを
リセットしようとすると権限エラーが出ます。
何かこのような場合のヒントをいただけませんでしょうか。
お手数をおかけいたしますがどうぞよろしくお願いいたします。
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it.co.id
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ldn't be rolled back" and
update I execute myself updating the data
Why do it?
I'm use MySQL 4.1.20 and MyISAM tables
Thanks,
Pablo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi list,
I am going to change the type of table to InnoDB
Thank!!
Pablo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql vers 4.0.20
A table "noticeboard" has three test entries.
A unix time from date("U") is stored in the field "published" of type,
bigint20.
I am not able to workout how to select the year. Assuming that the
value from date("U") can be treated as a unixtime value, my latest
unsuccessful e
I am having to operating MySQL 4.0.18, I had heared that I could copy a db
folder out of the mysql/data folder to the same folder on a different machine
running its own local host server and that server would have a copy of the
database. HOWEVER, o some occasions this seemed to work Ok, and on
Yes I had thought I should use tools to copy, but I have had problems with
mysqldump. I successfully created a dump file, but when I execute this file on
an empty database I got:
C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test1.txtERROR 1064 at line
54: You have an error in your SQL syntax. C
I backup a db using mysqldump, but when I come to execute the sql file on an
empty db I get this
C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test3.txtERROR 1005 at line
54: Can't create table '.\db2\shift.frm' (errno: 150)
C:\xampp\xampp\mysql\bin>
I have tried to fix the foreign key constraint (
e`)
) TYPE=InnoDB;
> Original Message
> From: [EMAIL PROTECTED]
> Date: 30/04/2005 13:52
> To: mysql@lists.mysql.com
> Subj: Re: mysqldump generates invalid code
>
> Hello.
>
> Make the dump using --quote-names option for mysqldump. Does it solve
>
I created a mysqldump with --quote-names option, but I get this
error:C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test5.txtERROR 1005 at
line 54: Can't create table '.\db2\shift.frm' (errno:
150)C:\xampp\xampp\mysql\bin>Line 54 is the CREATE TABLE... line of the
following bit of SQL from the fi
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> have you tried some inserts to see if it is an import problem, or just the
> client display ?
>
> Mathias
>
> Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
>
> > Hi,
> >
> > I recently upgraded from 4.0 to 4.1 because of the multilingual support.
alues ('Ceci est un test en Français');
> then :
> select toto from table;
>
> can you read it correctly ? And if the same row is imported, is there any
> difference ?
>
> A bientôt
> Mathias
>
>
> Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
rset-collation-charset.html
>
> mathias
>
> Selon [EMAIL PROTECTED]:
>
> > Salut,
> > i don't see what doesn't work ! Where characters are replaced by ?, since
> > you
> > say that insert,select and import work fine ? is it in the export ?
> >
___
Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ould be helpful. See:
> http://dev.mysql.com/doc/mysql/en/charset.html
>
>
>
>
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I'm trying to import a db dump made on ver. 4.0, on a new 4.1 vers=
> > ion.
> >
> >
stion is how to do it.
The other option is querying the db for every exception-type-table,
which I'd prefer not doing.
TIA,
Stijn Verholen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n the mysql-server each time the
data is "updated"?
* what else must i think of?
thank you very much for your hints!
greetings
hans horwath
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n the mysql-server each time the
data is "updated"?
* what else must i think of?
thank you very much for your hints!
greetings
hans horwath
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
E-Cards!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
http://lists.mysql.com/[EMAIL PROTECTED]
list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e:http://lists.mysql.com/[EMAIL PROTECTED]
scribe:http://lists.mysql.com/[EMAIL PROTECTED]
by MySQL?
Many Thanks
Fabio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Andy Bakun wrote:
On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote:
Hi all,
does anyone know if it's possible to compile MySQL under Linux so that
mysqld doesn't rely upon LinuxThreads, but makes direct call to fork()
or clone() system calls instead?
As far as I know an
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks a lot for your kind and amusing explanation!
I will have a look at MySQL thread layer AND of course wait for kernel
2.6..
Chris Nolan wrote:
On Thu, 2004-01-08 at 21:10, [EMAIL PROTECTED] wrote:
Andy Bakun wrote:
On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote:
Hi
Hello,
For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat (v. 7.2 &
9.0). We use our linux server for one thing: MySQL server.
We are far from linux experts, so Redhat made sense, particularly the ease of
installation and the bugfixes via up2date. Now that Redhat is endi
-
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
pw
With the result that I get asked for a PW and then told I can't connect.
But, I don't have the 4.1.1 client. Where is it? There is no
'...client' in the bin directory.
Thanks,
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: W
ed the a telnet server).
When I move to the shared directory on the PC and try to execute mysql,
I get the error.
Thanks for an assistance.
N. Chris Frost
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e's,release
notes/known issues)
hope this helps
brian
[EMAIL PROTECTED] wrote:
OK. Thanks. Late now, and laptop is off. Client is the mysql.exe
program.
I have to copy the mysql.exe to the laptop (or cd to the server machine
and execute from it. Leave the space out.
Right now, just fooling
cribe:http://lists.mysql.com/[EMAIL PROTECTED]
tdown
3. On NT/2000/XP machines, if you want to change the server
executable (e.g., -max or -nt), it is also necessary to remove the service:
C:\mysql\bin> mysqld-max-nt --remove
--
shrek-m
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to dump an XML file into a database? Can you do the reverse
of
mysqldump X dbname¹
???
R/Tim
; bin/mysqld_safe --user=mysql &
if you are running MySQL 4.x
--
shrek-m
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think we need more info: Table definition, MySQL version etc..
Med venlig hilsen
Lars Geisler
>
> -Original Message-
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> To: "Amit Lonkar" <[EMAIL PROTECTED]>
> CC: "[EMAIL PROTECTED]"
I need to know how to lock single records in a table. I have multiple users
logging on to a web site. I need to keep them from changing data on a
record at the same time.
Thanks in advance...
/T
know what the problem is and I need help.
Tammy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
scribe:http://lists.mysql.com/[EMAIL PROTECTED]
. if no one else experience these symptoms with their
4.1.7 MySQL).
Regards.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
you solve the rollback problem?)
The latter consumes less disk space, performance wise is better.
Do you see any other drawback / advantage?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
somebody know some smart
workaround trick?
Thanks, rinke
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
ecause it
complains about the foreign keys.
and then i think:
how is it possible that i cant do backup, and recover it, of my innodb tables?
thanks for the suggestions
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
dump
output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1."
:).. but dont worry i write the sentences by hand.
thx
d2clon
On Thursday 24 June 2004 11:44, Egor Egorov wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> > i have read multiple websites and post
ight a system cron script stops MySQL, backs
> up the slave XServe, and then restarts MySQL
>
> On Jun 24, 2004, at 7:01 AM, [EMAIL PROTECTED] wrote:
> > thx thx :D
> >
> > thats work right.
> >
> > the only problem is that mysqldump dont write the 'set
> &
he MySQL slave, performs the backup, and
> then restarts MySQL. We have a dedicated XServe running MySQL and we
> use another XServe whose primary function is filesharing to also act as
> a replication slave. Each night a system cron script stops MySQL, backs
> up the slave XServe, and t
+
1 row in set (0.00 sec)
=0
then.. i dont know.. i dont know if i have a unsolutionable problem.. or
something like that..
i only wanted to comment this.. :D
thanks
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FIVE TIMES FASTER!
Only $14.95/ month -visit www.netzero.com to sign up today!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ord:
ERROR 2003: Can't connect to MySQL server on 'linuxready' (111)
Maybe is it possible that I have to configure some attribute in my.cnf?
thanks in advance
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(first: excuse for my english)
On Monday 19 July 2004 15:03, Victor Pendleton wrote:
> Can you telnet port 3306 on linuxready from the remote machine?
nop.. :/ .. i cant do telnet to linuxready 3306 ¡
-
[EMAIL PROTECTED] $ telnet linuxre
lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
b? Are they connected via
> crossover cable?
>
> The connection refused message suggests a firewall somewhere between the
> two machines, I would guess it's most likely running on your host and you
> don't know it.
>
> Lachlan
>
> -Original Message-
>
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Mysql Users,
Could you tell me what should I do to get local (polish) daynames from the following
function:
SELECT DAYNAME("1998-02-05");
thanks,
regards,
Lukasz
Dear MySQL users,
Is it possible to configure MySQL in such a way that the function dayname()
will return the name of the day my local language. (In my case polish).
thank you very much for help,
regards,
Lukasz
fully.";
mysql_close();
echo "";
echo "";
?>
Thanks in advance
Sumit
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
this is the weirdest error I have ever encountered.
We get an error 2013 lost connection when we try to connect via mysql to
another machine having mysql on it as well. The weird part is that when
we change the IP address of the connecting machine to another service
provider it works fin
suggestions
ps: what is a flaky IP address?
Stew
At 03:10 PM 9/9/2003 -0700, Martin Gainty wrote:
Sounds like the First ISP is providing a IP Address that is flaky.
Can you drop the flaky first ISP and go exclusively with the second?
-Martin
- Original Message -
From: <[EMAIL PROTECTED]&
an you
please help
thank you
Stew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 262 matches
Mail list logo
