 | | | MySQL General | | Hi all
I have problem in MYSQL query tool.
Well i put on foreign key on cascade no action
but next time when i edit that table
it said that is on cascade is restrict.
Why is that ?
I use MYSQL Query Geoffrey
>SELECT
> bugs.id bugs.assignee users.username bugs.submitter
>FROM fb_bugs AS bugs
>fb_users AS users
>WHERE users.id bugs.assignee
>My problem is that I also want the users.Is there an easy way to transfer users and their permissions from one
server to another? We are moving databases to a new server and have a lot
of users to move as well.
Thanks in advance!
DonnaHi
I wonder if anyone could explain the rational behind the following
(MySQL-5.0.22)
We have a MyISam table with ~100Gb size.
We start creating an index.
The procedure starts making temporary fileI have a PHP driven site where I have a internal messaging type
system for registered users. Each time a message is sent I create a
log entry in a table with the from and to user id and an id froYou can 't just change the name without changing (or stating) the type.
ALTER TABLE actors CHANGE director_id actos_id varchar(96) default NULL
J.R.
-----Original Message-----
From Mark Sargent [mRunning MySQL 4.0.20 on a RHEL3 box.
Hi
I 'm trying to find the data in a table which is common to two or more
ids. Let 's say my table looks like this...
Craig this is the right place but performance is a pretty broad topic.
I personally highly recommend Jeremy Zawodny 's book 'High Performance
MySQL '. It 's based on 4.1 so the info will be wellSo by using MacOS X you are using a *nix based system.
Everything posted to this list is usually based in code (as in WebApps) or
by the MySQL command line. You need to learn how to use the command
Any idea why libmysqlclient_r.so is not being created when I compile after a configure --without-server?
I did two other boxes this morning and everything went just fine. Now this one (RH 9) is not[snip]
Now when I try to update the rotX rotY and rotZ fields I have to put
a double into it ints don 't work. But then when I print out the
database it looks like this
....
Which clearly indi[snip]
I 'm currently looking for a tool that will take XML and produce a
database
from it. Not really looking for anything in particular at this point
just
sort of scoping around. Anyone know of suHi List!
I 'm a little bit confused with (IMHO) poor query performance.
I have a table with 1 '000 '000 records.
Table consists of 2 service fields and a number of data fields. Service
fields are st[snip]
what type of password algorithum does mysql 5.x uses for encrypting
passwords? and how does these algorithum keeps the password in secure.
[/snip]
Here is some helpful info
http //www.mysqlHello
Is it possible to tell myisamchk where the intermediate files (.TMD) must be created.
Because my database are big and these not enough space in his directory.
I try with --tmpdir but this doe
Hi all
We have a copy of an old version of a database and a huge LOG file ( 9
Gig ) ( not the binary log unfortunately but the GENERAL QUERY LOG )
started when we put this database live.
The onlyBen Clewett wrote
<snip >
> C# has two DateTime constants
>
> DateTime.MinValue '0001-01-01 00 00 00.000 '
> DateTime.MaxValue '9999-12-31 23 59 59.999 '
>
<snip >
>
> MySQL really doHi Rob
> So each of the old rows splits into 30 new rows.
Really 180 rows right?
> The existing table has about 85000 rows equating to over 15 million in the new structure.
> Ways I have tried eHello
I have been using MySQL version 4.0 because I have experienced problems since version 4.1 and later versions...
I tried to update to version 5.0 but problems remain in short....
Due to my sDear ladies and gentlemen
Upscene Productions is happy to announce a new version of
the database developer tool
"Advanced Data Generator " (version 1.6.2)
A fast test-data generator tool that comesOn Mon Jun 05 2006 at 10 16 05PM -0700 Ken Williams wrote
> Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue?
> (http //lists.mysql.com/announce/364)
>
> 4.1 and 5 have been alJason Dimberg wrote
> I am working on an application where data will be collected on laptops
> and then uploaded to a central database once the laptop is able to
> connect to the network after being
Hi all hate to ask a question that probably has a really obvious answer but
does anyone know of the existence of a mysql 5.1 yum repo that I can point my
FC5 box at?
--
brendan bouffler
ArchiteI 'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file. I 'm trying to find out if I change the "basedir " from
Basedir /var/lib
To
Basedir /other/path
Will that moJo?o C?ndido de Souza Neto wrote
> Hi everyone
>
> Someone know if mysql 5 has hierarchical sql?
>
http //www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
> Thanks.
>
>
>
>
--dsa dsad
2006/6/5 MySQL Nexeia <mysql@(protected) >
> I face one problem with mysql4.0
>
> I 've two tables one called company and the other called favorites. The
> relation between those two tables is CO_ID > At 14 02 +0300 1/6/06 Remo Tex wrote
> >If you change the character set when running MySQL you must run
> >myisamchk -r -q --set-collation collation_name on all MyISAM tables.
>
> Hi
>
> My probleOn the same OS X machine that 's having prefpanel trouble with 5.0.22
I find that mysql is not loading the values set in /etc/my.cnf. The
contents of the file is from another Mac that works just fI 'm having trouble with the prefpane in OS X (on a MacBook) with a
fresh install of the standard binary 5.0.22 (i686). It 's completely
broken for me. If the server is running and I click 'stop ' i |
|
|
