Hi,
I believe that the query below is correct, but I do not believe that it is
possible in MySQL currently due to it not supporting sub-selects:
UPDATE table1 SET ID=table2.ID, Company=table2.Company,
Modified=table2.Modified FROM table1 INNER JOIN table2 ON
table1.Company=table2.Company WHER
The error logs seem to indicate that the pid file you've specified is not
writable and that the system database tables are not installed properly.
1. make sure that you ran mysql_install_db. If you did, make sure that you
didnt change the my.cnf datadir setting without moving your system files or
It appears that your change to debian was also a change from the current
3.23 mysql version to the old 3.22 version ( major releases ). The old
version, 3.22, does not support MyISAM tables, so you'll need to upgrade to
the new version. Debian stable, aka potato, uses 3.22, but both woody + sid
(
Some people like to use MS Access as a frontend using MyODBC to 'link
tables'. If you have access, you'll need to install myodbc ( available in
the downloads section of www.mysql.com ), configure a datasource connection
with a valid username + password etc, and then in access:
File -> Get Externa
Hi,
Does MySql support Synchronous or asynchronous I/O or
both?
What do they mean when they ask me if
-> copy Db is supported by mysql?
-> version db is supported by mysql?
-> Sync/Async write strategies?
Currently I have been asked to evaluate mysql against
TimesTen. Is there such an comparisi
Hi
I am new to My SQL and have just installed it on a Win 98 machine. can you
recommend any good front end tool to generate reports ? At present the
interface available for both input and output is phpAdmin. Also how does one
import data from excel; is it possible ?
ans
---
7 days are now over
dear God take the souls of the inocent in thy hands.
there is only one question to be answered
Who was the man in the back ground ???
Who payed the for the atak of terrorism ???
the one to put the mony for killers, who was it ???.
The one will now have to pay with somthing
7 days are now over
dear God take the souls of the inocent in thy hands.
there is only one question to be answered
Who was the man in the back ground ???
Who payed the for the atak of terrorism ???
the one to put the mony for killers, who was it ???.
The one will now have to pay with somthing
Hi, Heikki.
Thanks for the info.
I understand your first explanation, I'll try.
> You can probably circumvent the problem by
> adding an extra VARCHAR column where you put
> the first 255 characters of the blob column.
Would you please inform me more externation of second.
Can you give me an
Here's what I'm doing. Appently something is going wrong but I am missing
exactly what.
Any suggestions?
Martin
mysql> INSERT INTO user (Host,User,Password)
VALUES('%','chimbis',PASSWORD('pompeji'));
Query OK, 1 row affected (0.00 sec)
mysql> GRANT USAGE ON *.* TO chimbis@"%" IDENTIFIED B
I must be a moron but I can't seem to figure out what I need to do to get
mysql to work on RH, on Mandrake it just worked straight away.
I read and followed the instructions in the INSTALL-BINARY (inspite of the
fact that the way red hat installed mysql does not even closely resemble the
instruct
I'm having a problem connecting to the server. When I type the:" mysqld--standalone"
from the command prompt does not start the process. Could you tell me the correct
syntax or what I'm doing wrong.
Thanks
Steve
___
GO.com Mail
I was running a mySQL server under slackware for a while, it was
interacting with php on an apache webserver, and everything worked fine.
There were a few times where I would mess linux up and need to re-install,
in which case I would move my database files to my windows partition,
re-install linu
At 5:54 PM -0700 9/17/01, Armando Cerna wrote:
>I understand everything you said except primary key do i need one I have seen
>it before in some fields but have no clue what it is... thanks btw =)
All the more reason to consult the manual! :-)
>
>Armando
>
>On Monday 17 September 2001 05:44 pm,
I understand everything you said except primary key do i need one I have seen
it before in some fields but have no clue what it is... thanks btw =)
Armando
On Monday 17 September 2001 05:44 pm, you wrote:
> At 5:34 PM -0700 9/17/01, Armando Cerna wrote:
> >I need to insert a phone number into a
At 5:34 PM -0700 9/17/01, Armando Cerna wrote:
>I need to insert a phone number into a table. I would do this with the
>insert command except I think that it would create duplicate entries even
>though they are exactly the same is there a way that I can have it not enter
>the data if it exists a
I need to insert a phone number into a table. I would do this with the
insert command except I think that it would create duplicate entries even
though they are exactly the same is there a way that I can have it not enter
the data if it exists already
TIA
Armando
--
Hi there,
I would really appreciate any help someone can give on the following awful problem..
I have been working all day on filling a table with data. (Small records..)
Because I have a table which I filled with some binary data someone asked me how big
this will get..
I looked at the di
Hi there,
I would really appreciate any help someone can give on the following awful problem..
I have been working all day on filling a table with data. (Small records..)
Because I have a table which I filled with some binary data someone asked me how big
this will get..
I looked at the direc
Hi!
On Sep 17, Boris Cownie wrote:
>
> select count(*) from table match field against ('word1')
> select count(*) from table match field against ('word2')
> select count(*) from table match field against ('word2')
> ... etc ..
>
> The bad news is even these are slow if the word is common WHY ?
Thanks for the reply! I can understand the situation with muti statement
transactions, but I'm not using transactions ( at least from my
perspective ); Im only issuing single 'atomic' statements. It would make
much more sense if mysql internally detected the deadlock, released the
locks and tried
Troy,
Have you considered MyODBC? Access works well with linked ODBC tables. Then, within
Access, you can copy the linked table into an Access table.
Hope this helps!
Christopher Reed
Application Analyst
Information Technology
City of Lubbock
[EMAIL PROTECTED]
>>> "Troy Montour" <[EMAIL PRO
Hi!
> "Dana" == Dana Powers <[EMAIL PROTECTED]> writes:
Dana> Certainly I understand how the deadlock can occur, but the question is why
Dana> is this acceptable behaviour? Is the application developer expected to
Dana> handle this case? If so, how? and shouldnt this be included in the manu
I need to convert from Mysql to access for testing reasons.
when I do the Mysql dump it either gives me the query code or it saves a
file with .sql extension.
how do I get this information into access?
I wish I could but can not connect direcly to the mysql server cause of the
way the hoster se
At 3:15 PM -0400 9/17/01, Jay Fesco wrote:
> > Can someone tell me how to reset a column's auto_increment starting point
>> back to 0 in mysql ?
>>
>> Thanks
>>
>> Paul
>>
>According to Paul DuBois on page 169 of MySQL by New Riders (which you
>should buy):
>
>ALTER TABLE t
> DROP i,
>
I have a table with about 3.5 million records with a fulltext index on text
field of about 90 characters.
This has name and address data I'm trying to match against a dirty input
string. I've recompiled
with the following changed in ft_static.c.
ft_min_word_len=2 /* I want to find words like '
>
> Dear Sirs,
>
> I have a database with a lot of information. Can I copy that
> information to
> another server??? It's because I'm gonna change of hosting
> company!!! (I use
> PHP and Perl)
>
>
> Thanking in advance,
> Nuno Lopes
>
MySQLDump is what you need, and is quite well documented (man
> Can someone tell me how to reset a column's auto_increment starting point
> back to 0 in mysql ?
>
> Thanks
>
> Paul
>
According to Paul DuBois on page 169 of MySQL by New Riders (which you
should buy):
ALTER TABLE t
DROP i,
ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY
Ja
Dear Sirs,
I have a database with a lot of information. Can I copy that information to
another server??? It's because I'm gonna change of hosting company!!! (I use
PHP and Perl)
Thanking in advance,
Nuno Lopes
P.S.: When you reply to the list, reply to me too, Thanks!
-
Hello root!
> >Description:
> Can't delete from incredibly fat table.
> >Synopsis: unable to delete table data, running out of disk space for it!
Well, that pretty much wraps it up, doesn't it? This is a hardware
problem, not a software problem.
The software must read the old table and cre
Can someone tell me how to reset a column's auto_increment starting point
back to 0 in mysql ?
Thanks
Paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello Chris!
> I can run safe_mysqld as user "MySQL" to start the mysql daemon.
> However, when I try to use safe_mysqld as user "root", I get the
> message, "Can't change to run as user 'MySQL'." Any hints much
> appreciated. Thanks in advance.
>From rc.local:
su - mysql -c '/usr/local/sbin
I can run safe_mysqld as user "MySQL" to start the mysql daemon.
However, when I try to use safe_mysqld as user "root", I get the
message, "Can't change to run as user 'MySQL'." Any hints much
appreciated. Thanks in advance.
-
On Mon, Sep 17, 2001 at 10:03:29AM -0700, Michael McConnell wrote:
> It certainly does seem that 3.23.40+ take considerably more
> resources to do the exact same thing, than MySQL 3.22.xx
If that's the case, it's worth tracking down so that it can be fixed.
> Is this correct?
I hope not.
Jere
No problems here, Possibly mailing list issues?
Peter Harvey wrote:
>
> Ok... this is getting out of hand. Is it just me or are we getting a posting
> every week on this?
>
> Please keep these postings to majour releases (1.0, 2.0, etc)... at most.
> Post your minor releases to your own maili
Ok... this is getting out of hand. Is it just me or are we getting a posting
every week on this?
Please keep these postings to majour releases (1.0, 2.0, etc)... at most.
Post your minor releases to your own mailing list.
This is a relevant product but we do not want to pollute the list.
Thanks
On Monday 17 September 2001 08:59, powlow wrote:
> when installing with rpm i get:
>
> Number of processes running now: 2
> mysqld process hanging, pid 30887 - killed
> mysqld process hanging, pid 30886 - killed
> 010917 16:04:06 mysqld restarted
> /usr/bin/safe_mysqld: line 273: 30916 Segmentat
It certainly does seem that 3.23.40+ take considerably more resources to do
the exact same thing, than MySQL 3.22.xx
Is this correct?
> On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote:
> >
> > So what your saying is MySQL is supposed to fork a new processes for
> > every conn
Hi Siva,
Were you trying to install from the soure code downloaded from
mysql.com? Or are you using the ports collection (ie
/usr/ports/databases/mysql ) to install? Because if you are
installing fron the download you need to remember to use "gmake" not
BSDi make.
Ken
- Original Message
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (0.92) of MySQL Manager --
A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 0.92?
Mike wrote:
> In working with some non profit groups I need to be able to send a complete
> program that is installed and ran fairly easy.
> To me MySQL is easy in most cases but to someone not familiar with it it can
> be a daughtening task. Is there a way to send a setup program using MySQL?
>
SELL YOUR PRODUCTS AND MAKE
'BIG MONEY' $$$ WITH OUR EMAIL ADDRESSES
1) Let's say you... Sell a $24.95 PRODUCT or SERVICE.
2) Let's say you... Broadcast Email FREE to 500,000 PEOPLE DAILY.
3) Let's say you... Receive JUST 1 ORDER for EVERY 2,500 EMAILS.
CALCULATION OF YOUR EARNINGS BASED ON THE
>Description:
Can't delete from incredibly fat table. When I attempt to delete from table rCamDom in
my database, I get an error: "ERROR 1030: Got error 22 from table handler". This table
is *huge*, biggest one in my database, other deletes work fine.
The table entries begin on Jan 1, 2001. When
Hi Bob!
> I use Caldera Linux and have a 4 machine LAN.
> The Lan includes 3 Linux and 1 WinNT install.
> Now, no matter what I do safe_Mysqld continues to start
> version: 3.22.32-log ..
This is more of a *nix question than a mysql question but whatever. :) I
use redhat but the concepts are
when installing with rpm i get:
Number of processes running now: 2
mysqld process hanging, pid 30887 - killed
mysqld process hanging, pid 30886 - killed
010917 16:04:06 mysqld restarted
/usr/bin/safe_mysqld: line 273: 30916 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD
$defaults --basedir=$M
>>2. Is it possible to let the users by them self change their
>>password? Then they could change it to their UNIX-password. As far
>>as I know only the MySQL admin can change the users passwords. :(
>
>Yes, that's possible. The user connects and issues this command:
>SET PASSWORD = PASSWORD('new
I just upgraded to latest mysql. there was an error when starting the demon
or using the client about not finding the socket file.
i found it in /tmp/mysql.sock and moved it to the directory where it was
looking for it. /var/lib/mysql/mysql.sock
now i get :
ERROR 2002: Can't connect to local M
At 8:27 AM + 9/17/01, Jonas Larsson wrote:
>> > But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why
>>> isn't that implemented? Then it would be easy to transfer the hash...
>>>
>>
>>Yes it definitly would be nice and would have been easier to impliment than
>>the curre
As root:
chown -R mysql /usr/local/mysql
Fernando da Motta Hildebrand wrote:
> I can´t start Mysql (I use Slack and compiled mysql). I´ve
> followed all instructions in INSTALL text, and i´ve got this in the .err
> file:
>
>
>
> 010914 16:19:02 mysqld started
> 010914 16:19:02 /us
I am running MYSQL 3.23.36 on windows NT. I am not
able to connect to the server through a C program
using mysql_real_connect() from another computer. The
other computer is running on Windows 98. My
permissions are alright and I am able to connect to
the server interactively through the command
Chris Thorpe writes:
> My question is how do I query the database to return a valid route(s)
> supplying only a start and end point.
> ie SELECT !!route!! WHERE start=A and end=D,
>
> Personally I don't see how this is possible without code, hence why I am
> querying the brains of the world!!!
[EMAIL PROTECTED] writes:
> If I (admin1) have all privileges with grant option on database 'db1' and
> no privileges in 'mysql', why this does not work
> mysql> grant all privileges on db1.* to aaa@localhost identified by 'aaa';
> ERROR 1044: Access denied for user: 'admin1@localhost' to d
[reaction on joe kaiplings message]
hello Joe,
I'm trying to contact you but my emails to you our bounced each time. Please
give me a valid email address so I can answer your questions in the email you
sent me 10-9.
regards
Rick van Dijk
Datanamic
http://www.datanamic.com
Joe Kaiping schreef:
This is something that has me stumped..
I have a table as follows
EndAEndB
A B
A C
B C
C D
A E
D E
Imagine this as a table that describes potential links across a phone
network. Now supposing I wish to connect from point A to point
Ann Myhre wrote:
>Hi group
>
>Access has a datatype (I don't remember the name) which is a kind of boleaen; it
>represents Yes/No, true or false. When I try to translate that creating a table in
>MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y
>then...(ASP). Do I
Hi group
Access has a datatype (I don't remember the name) which is a kind of boleaen; it
represents Yes/No, true or false. When I try to translate that creating a table in
MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y
then...(ASP). Do I use ENUM right? I have
Hi!
On Sep 15, [EMAIL PROTECTED] wrote:
> Hi list,
>
> I have a question that hopefully someone can help me with.
>
> We have a mysql database which contains 3000 records, and these records need
> to be searched.
>
> The table has 4 fields which need to be searched, so we created a full text
Hi!
On Sep 13, Doug Poland wrote:
One question per line, please !
> Problems is knowning how many columns can be indexed in a table.
max 16 columns per index.
max 32 indexes per table.
so 16*32=512 columns can be indexed in a table, which is less then
max 3398 columns per table.
> Is that num
I do it by setting up a MyODBC databsource which points to my MySQL database
and then export each MS-Access table to that ODBC datasource. It works fine
except that it does not do primary key and index definitions (as far as I
have been able to tell) and things like setting "auto_increment" on fo
I want to import tables from MS-Access to My-SQL.
Please help me out
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Hello people,
mysqldump not dumps MERGEd tables structure
it writes TYPE=MERGE and then UNION() with empty parenthesis
so this """dump""" can not be used.
--
Best regards,
Pedro mailto:[EMAIL PROTECTED]
---
Hi,
I've put here this my problem, but without an answer.
If I (admin1) have all privileges with grant option on database 'db1' and
no privileges in 'mysql', why this does not work
mysql> grant all privileges on db1.* to aaa@localhost identified by 'aaa';
ERROR 1044: Access denied for user:
> > But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX?
>Why
> > isn't that implemented? Then it would be easy to transfer the hash...
> >
>
>Yes it definitly would be nice and would have been easier to impliment than
>the current Password() implimentation (just call crypt()!!).
On Mon, Sep 17, 2001 at 01:02:50AM -0700, francis jeffrey wrote:
> I have recently started using mysql and php. I have created sample
> databases that are working well. My problem came when I started
> using PHP. My php scripts are being executed, the pronlem comes when
> I use the function mysql
I have recently started using mysql and php. I have created sample databases that are
working well. My problem came when I started using PHP. My php scripts are being
executed, the pronlem comes when I use the function mysql_connect to connect to any of
my databases. It returns the folowing mes
Hi all,
Can anyone point me to a good Macromedia Ultradev Extension for live
connection to MySQL?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
66 matches
Mail list logo
