Hi,
I'm new on this list, so a very short intro about me: I'm Andras Barthazi,
a Hungarian web developer. I like MySQL very much, I'm using it since 3.x
versions, so I think I know it very well. But...
So, I started learning, how MySQL 5.0 handles character sets. It is, what
I think about it
When this limit will be removed ?
from 5.1 manual (13.1.4)
"An index_col_name specification can end with ASC or DESC. These keywords are
allowed for future extensions for specifying ascending or descending index
value storage. Currently they are parsed but ignored; index values are always
store
On Thu, 2005-10-27 at 21:22 -0700, Scott Haneda wrote:
> on 10/27/05 6:34 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
>
> > Right now, my update works as follows, and works fine, however, I want to do
> > a condition to say if products.ship_status = 1 then set
> > cart_test.shipping_status to 'no
on 10/27/05 6:34 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
> Right now, my update works as follows, and works fine, however, I want to do
> a condition to say if products.ship_status = 1 then set
> cart_test.shipping_status to 'now' else set it to 'soon'
>
> UPDATE cart_test, products
> SET ca
I think there are four cases to consider (hopefully the "picture" will
come through okay).
starttime|--|endtime The time span in consideration
*-* Case 1: ta has mtg that
starts before starttime, mtg ends between starttime and endtim
My table products has ship_status INT, where it is either 1 or 0. I have
been moving those style fields to enum('now', 'soon') because it makes more
sense to me to be able to see the real values.
The problem is this is a live DB, and I am working on a dev site against the
live db, as much as I wa
Hi C.F.
I'm new to the list, so please excuse me if I'm
answering out-of-turn from the pro's here.
I think the answer is to also check if the
BusyTime_start is between start and end of the
attempted scheduled.
ie:
WHERE
(TAID = 1) AND
(('2005-10-27 17:30' BETWEEN starts AND ends) OR
('2005-10
On Thu, 2005-10-27 at 13:05 -0500, T.J. Mahaffey wrote:
> Does this have something to do with the OLD_PASSWORD issue in MySQL
> 5? (I didn't think OSXServer 10.4 included MySQL v.5... )
>
> My setup:
> Entropy PHP 4.3.11
> MacOS X Server 10.4
> 10.4's default MySQL install
The following command
Hello all,
I have a TA table to record TA UNAVAILABLE times.
This table is quite simple. It has a TAID number, a start date and an
end date.
tbl_schedule {
TAID integer,
starts datetime,
ends datetime }
A valid entry would be a TA whose id is 1 and between 17:00 and 18:00 he
is busy.
So:
On Thursday 27 October 2005 03:51 pm, [EMAIL PROTECTED] wrote:
> hy! I've been trying to find this piece of information in the manual, but
> seem to have some trouble. so I'm asking it out loud: I'd like to know
> whether mysql 4.0.25 supports utf-8 as an internal encoding. Because a
> server I lik
I'm installing MySQL 4.1.14 on a new Gentoo box. When I try to connect
to the mysqld daemon, it crashes and restarts itself, which just doesn't
seem right. I enter these commands:
cd /usr; /usr/bin/mysqld_safe &
mysqladmin -u root password 'foobar'
and get this response:
mysqladmin: connect
Jeff Smelser escribió:
On Wednesday 26 October 2005 04:24 pm, LMS wrote:
Hi,
I have this structure:
---
CREATE TABLE tabla (
id int(10) unsigned NOT NULL auto_increment,
nombre varchar(100) NOT NULL default '',
because your defaulting it to ''.
hy! I've been trying to find this piece of information in the manual, but
seem to have some trouble. so I'm asking it out loud: I'd like to know
whether mysql 4.0.25 supports utf-8 as an internal encoding. Because a
server I like has this version and I need to deploy an international
applicatio
T.J. Mahaffey wrote:
> "Client does not support authentication protocol requested by server;
> consider upgrading MySQL client"
>
> Does this have something to do with the OLD_PASSWORD issue in MySQL 5?
The password format changed between MySQL 4.0 and 4.1. I have no
idea what:
> 10.4's defau
Oops, you are correct. I missed a "not" in the original post.
-Sheeri
On 10/27/05, Brent Baisley <[EMAIL PROTECTED]> wrote:
> You would want to do a left join and only keep the null values.
>
> SELECT tableA.*
> FROM tableA
> LEFT JOIN tableB ON tableA.recordID=tableB.recordID
> WHERE tableB.rec
On Wednesday 26 October 2005 04:24 pm, LMS wrote:
> Hi,
> I have this structure:
> ---
> CREATE TABLE tabla (
>id int(10) unsigned NOT NULL auto_increment,
>nombre varchar(100) NOT NULL default '',
because your defaulting it to ''.. so null = ''
Hi,
I have this structure:
---
CREATE TABLE tabla (
id int(10) unsigned NOT NULL auto_increment,
nombre varchar(100) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY nombre (nombre),
UNIQUE KEY id (id)
) ENGINE=MyISAM;
SELECT * FROM tabla
++
You would want to do a left join and only keep the null values.
SELECT tableA.*
FROM tableA
LEFT JOIN tableB ON tableA.recordID=tableB.recordID
WHERE tableB.recordID IS NULL
On Oct 27, 2005, at 6:35 AM, Christopher Molnar wrote:
If I have two similar tables, with identical columns how would I
Wow, it seems like you are going to extremes. To jump from myisam to
heap is a big step. Did you try using InnoDB? It would handle locking
issues much better since it doesn't lock the table. Heap tables can
be pretty dangerous since it's all in memory. If the machine crashes,
you'll lose th
*head smack*
Apologies for my newbie-ish first post to the list. (I know better
than to exclude key details like *gasp* an error message.)
Thanks to Michael's brilliant suggestion, I now have my error:
"Client does not support authentication protocol requested by server;
consider upgrading
Hi,
I am currently using a replication setup on two servers with mysql
4.1.13-standard-log (master/slave each a P4 2.4ghz, 3GB RAM, Hardware
SCSI-RAID).
I have a table that has lots of updates and selects. We converted this table
(along with other tables) from a myisam to a heap-table 6 months
T.J. Mahaffey wrote:
It seems my MySQL privs aren't working properly.
Symptom is that PHP scripts themselves won't authenticate to MySQL
*unless* the script uses the root MySQL login/pw.
I've verified that my added MySQL logins are set up and working in the
command line and they show up pro
It seems my MySQL privs aren't working properly.
Symptom is that PHP scripts themselves won't authenticate to MySQL
*unless* the script uses the root MySQL login/pw.
I've verified that my added MySQL logins are set up and working in
the command line and they show up properly in phpmyadmin, b
mysqladmin -u root password
Curtis
sheeri kritzer wrote:
> Hi Alaister,
>
> Your root password is not actually set. If you do
>
> mysql -u root -p
> and it fails, it means that the password is not
>
> if you do
>
> mysql -u root
>
> the mysql client will parse as the database you're trying
Hi Alaister,
Your root password is not actually set. If you do
mysql -u root -p
and it fails, it means that the password is not
if you do
mysql -u root
the mysql client will parse as the database you're trying
to use -- that's just the syntax of the mysql client. Which means
that your pas
Tom Brown wrote:
Hi, I am trying to run mysqldump on a bugzilla database that is stored
on a remote server. I have access to that shared folder
and I have no problem backing up with MySQL Admin. With mysqldump
using a batch file (Windows) I get the following:
mysqldump: Got error: 1045: Acce
Hi, I am trying to run mysqldump on a bugzilla database that is stored on a
remote server. I have access to that shared folder
and I have no problem backing up with MySQL Admin. With mysqldump using a batch
file (Windows) I get the following:
mysqldump: Got error: 1045: Access denied for use
Thanks guys!
J.R.
-Original Message-
From: JamesDR [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 27, 2005 9:21 AM
To: mysql@lists.mysql.com
Subject: Re: MSSQL-MySQL Compatibility Question
J.R. Bullington wrote:
> Hi All,
> Quick question -- I have a client who co-owns a serve
J.R. Bullington wrote:
Hi All,
Quick question -- I have a client who co-owns a server with me. I am
a die-hard MySQL guy, they are MSSQL. They have some proprietary
Access-frontend/MSSQL-backend financial system that they want to continue to
use (i.e. pigheaded and won't convert).
Can
Yeah, it's perfectly ok to run both on the same machine at the same
time, though with MS SQL you're limited to Microsoft OS.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
Quick question -- I have a client who co-owns a server with me. I am
a die-hard MySQL guy, they are MSSQL. They have some proprietary
Access-frontend/MSSQL-backend financial system that they want to continue to
use (i.e. pigheaded and won't convert).
Can MS-SQL and MySQL run on th
Aleksandra wrote:
Jigal van Hemert wrote:
I assume that you use Full-Text searches (but somehow you have managed
to change the default minimum word length to three).
As far as I understand what you've written - if I change the minimum
word length to 4, I won't get any result with the word 'and'
Stefan Kuhn wrote:
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
I'm using it with four machines (geographically separate) and it works
fine. Stefan
And can writes on each server in simultaneous time ?
Hi, I am trying to run mysqldump on a bugzilla database that is stored on a
remote server. I have access to that shared folder
and I have no problem backing up with MySQL Admin. With mysqldump using a batch
file (Windows) I get the following:
mysqldump: Got error: 1045: Access denied for user '
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
> Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
> > I'm using it with four machines (geographically separate) and it works
> > fine. Stefan
>
> And can writes on each server in simultaneous time ?
I don't under
Jigal van Hemert wrote:
Aleksandra wrote:
I've written a search machine. It's working quite well, but I have
two problems:
1. When I give the following syntax : cat and dog , as a result I
get everything with at least one of the words: 'cat', 'dog' but also
'and'.
What can I do, so that
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
> I'm using it with four machines (geographically separate) and it works fine.
> Stefan
And can writes on each server in simultaneous time ?
--
Raphaël 'SurcouF' Bordet
http://debianfr.net/ | surcouf at debianfr dot net
--
My
Eldon Ziegler wrote:
We have a geographically dispersed system with a database of student
status information that needs to be replicated in as near to real time
as we can get. The MySQL master-slave method of replication doesn't seem
applicable as students can login to any server and pickup whe
We have a geographically dispersed system with a database of student
status information that needs to be replicated in as near to real
time as we can get. The MySQL master-slave method of replication
doesn't seem applicable as students can login to any server and
pickup where they were before.
Hi Paul,
I'm sure there are no spaces or other blank characters. I run exactly
this query (I deleted the row and tried again):
INSERT INTO tab_p (d_id, name) VALUES (20602, 'Machico');
INSERT INTO tab_p (d_id, name) VALUES (20602, 'Funchal');
SELECT * FROM tab_p WHERE d_id = 20602 AND name LI
Tom Brown wrote:
hmm i'm not entirely sure i fancy adding another data file on the fly -
Can you give me a brief run down about how you would go about this?
My collegue the sysadmin usually takes care of keeping the databases
happy. But AFAIK it's a matter of modifying the setting in the .cnf fi
If I have two similar tables, with identical columns how would I
select rows that are not duplicated between both tables? Any easy way
to do this?
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
Wenca wrote:
SELECT * FROM tab_p WHERE d_id = 20602 AND name LIKE 'Machico'
-> no results
Try it with ...AND `name` LIKE '%Machico%';
I have encountered it once when there were non printable characters in
front of or after the text itself. Very frustrating!
You can see what extra characters
Le jeudi 27 octobre 2005 à 01:12 +0300, Gleb Paharenko a écrit :
> Hello.
>
>
>
> In mysql-5.0.15 it works. Put, say, default_time_zone='+10:00' in
>
> [mysqld] section of your file.
This option works too under MySQL 4.1.11:
[mysqld]
default_time_zone=UTC
mysql> SELECT @@global.time_zone, @@
Aleksandra wrote:
I've written a search machine. It's working quite well, but I have two
problems:
1. When I give the following syntax : cat and dog , as a result I get
everything with at least one of the words: 'cat', 'dog' but also 'and'.
What can I do, so that it's not looking for the wor
Hi!
I've written a search machine. It's working quite well, but I have two
problems:
1. When I give the following syntax : cat and dog
, as a result I get everything with at least one of the words: 'cat',
'dog' but also 'and'.
What can I do, so that it's not looking for the word 'and' or s
Hi all,
I've got a problem that I don't understand and that is driving me mad.
I have a table 'tab_p' with this structure:
nametype
---
p_idmediumint(8) AUTOINCREMENT NOT NULL PRIMARY KEY
d_idsmallint(5) NOT NULL
namevarchar(50) NOT NULL
An
Hi,
I found this morning that the slave replication thread seem to have hung.
Below I have pasted in my show slave status, it seems to be stuck trying to
connect to the master.
To fix this I issued a stop slave and start slave, my slave is about 3 weeks
behind now.
I have a script checking for wh
Hello all,
I just installed MySQL 5 on Mac OS 10.3.9. Now when I try to create a
user using any method it does not work. I read I may have to run the
mysql_install_db script so I did, but I get these results:
mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
mkdir:
Hi Alastair,
You don't have a password for root set. The syntax for mysql (the
client) would put your #mysql -u root as setting the database
to .
If you use the -p option, even if you don't supply a password, it will
be rejected if no password is set.
You may like to check out
http://dev.mysql.
Thanks for your reply I think this is the issue I don't think root is
allowed to login from local host I created another user called web user and
changed the script, that works fine, next question is how do I set the
permissions for root in mysql to allow root to login, if I use
#mysql -u root I
Hello.
> The server was installed with Utf8 so that is not the issue and the
>server from before dumped was utf8 as well.
Complete UTF8 support has appeared only in 4.1 branch.
> The problem with this one seemed to be when the dump would get put
back in,
> it would throw this error on a
Hello.
I'm a bit sorry, but my English doesn't allow me to clearly see your
problem. Could you repost your message and include the output of the
following statements:
SHOW SLAVE STATUS
SHOW MASTER STATUS
SHOW TABLE STATUS
Execute SHOW TABLE STATUS both on the Slave and Master. Use as m
Hello.
In mysql-5.0.15 it works. Put, say, default_time_zone='+10:00' in
[mysqld] section of your file.
Raphaël 'SurcouF' Bordet wrote:
> Hi,
>
> I want to set up a different timezone that my operating system for MySQL
> upper to 4.1. According to this article[1], timezone system var
Michael Stassen wrote:
Daniel Bowett wrote:
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/>...Total sales for ever would be a simple GROUP BY query with a
>sum on the sales - but I cant see how I am going to get this info.
>Do I need to use nested queries? /
Y
55 matches
Mail list logo
