David,
- Original Message -
From: "David Griffiths" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, September 19, 2003 4:07 AM
Subject: InnoDB Foreign Key Constraint Issue
> The following constraint is failing:
>
> ALTER TABLE address_list ADD CONSTRAINT FOREIGN KE
Hi Randy,
4.1.1 hasn't been released yet unfortunately. The devs have said that
they've started release testing or whatever it's called. I think they
said it will hopefully be released in 4-6 weeks. :-)
Matt
- Original Message -
From: "Randy Chrismon"
Sent: Thursday, September 18, 2003
SQL
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> >
> > Sorry. I am wrong. Situation is worse.
> > Both tables aren't replicate to the slave.
> > But query try run it on slave :(
> >
> > slave: mysql-4.0.13
> > master: mysql-4.0.14
>
> What replication options do you use?
Full scheme is:
> For LOAD DATA, it works better in 4.1.1, as indicated here:
I read that and immediately went looking on the MySQL site for 4.1.1.
All I can find is 4.1.0-alpha. Where can I get 4.1.1?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Thank you.
So, the Rows in show table status is meaningless.
One more question, the data_length for small table in show table status are
all 16384, even the tabel without any data?
thank you again
Hsiu-Hui
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Here is the corrected version:)
Take a look at Paul DuBois book. Don't use gets. Instead use fgets. That's
safe. I didn't change your gets call:)
hth,
Ganbold
#include
#include
#include
#if defined(_WIN32) || defined(_WIN64)
#include
#endif
#ifdef WIN32
#pragma comment(lib,"ws2_32")
#inc
Hsiu-Hui Tseng wrote:
Hello,
I migrated all my tables to innoDB from MyIsam. After migrated, I ran "Show
TAble Status". Why the row count is change.
In MyIsam table status.rows = 316202
the new InnoDB table status.rows = 287341
When doing select count(*) from TABLE. I go 316202 rows.
Why this hap
Hello,
I migrated all my tables to innoDB from MyIsam. After migrated, I ran "Show
TAble Status". Why the row count is change.
In MyIsam table status.rows = 316202
the new InnoDB table status.rows = 287341
When doing select count(*) from TABLE. I go 316202 rows.
Why this happening? Is there any
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally segfaults with no visible
pattern. Could someone help me figure out why? Or any other comments on the
code to help me make it better?
/* client.c */
#include
#include
int
Thanks everyone, I suspected it was something quite simple.
Sam
Matt W wrote:
- Original Message -
From: "Paul DuBois"
Sent: Thursday, September 18, 2003 8:17 PM
Subject: Re: using OR in select statement with distinct results
At 7:47 PM -0500 9/18/03, Sam Folk-Williams wrote:
Hi,
- Original Message -
From: "Paul DuBois"
Sent: Thursday, September 18, 2003 8:17 PM
Subject: Re: using OR in select statement with distinct results
> At 7:47 PM -0500 9/18/03, Sam Folk-Williams wrote:
> >Hi,
> >
> >I keep having this fundamental problem. It seems like this should be
> >e
Won't putting the first OR in parenthesis, fix it up?
SELECT t1.title, t2.auth_name FROM t1, t2, WHERE (cat_id = 1 OR cat_id = 2)
AND t1.auth_id = t2.auth_id
KL
Sam Folk-Williams wrote:
> Hi,
>
> I keep having this fundamental problem. It seems like this should be
> easy enough, but whenever I
At 7:47 PM -0500 9/18/03, Sam Folk-Williams wrote:
Hi,
I keep having this fundamental problem. It seems like this should be
easy enough, but whenever I have a query where I'm using OR in the
WHERE clause and the query is performed on multiple tables, I get
strange results. For example:
SELECT
> Have you seen this?
>
> http://www.sklar.com/page/article/myphp
>
Man this is a filth idea, there is potential here until stored procs come
into effect, can it be used to create php stored procedure functions at
all ?
Like is there a better example than that, like its obvious its creating a
fun
> Hi,
>
> No, ROLLBACK doesn't work with MyISAM. Jeremy meant that you can add
> logic/code between LOCK/UNLOCK to "simulate" ROLLBACK. e.g. queries
> that "undo" what you did if something goes wrong. Of course this won't
> cover you if mysqld dies, is killed, or you lose the connection etc. as
> r
Hi,
I keep having this fundamental problem. It seems like this should be
easy enough, but whenever I have a query where I'm using OR in the WHERE
clause and the query is performed on multiple tables, I get strange
results. For example:
SELECT t1.title, t2.auth_name FROM t1, t2, WHERE cat_id =
The following constraint is failing:
ALTER TABLE address_list ADD CONSTRAINT FOREIGN KEY (address_type_id)
REFERENCES address_type (address_type_id);
The address_list table looks like:
mysql> desc address_list;
+--+--+--+-+-+---+
| Field
I have several fields in which I will be strong text. Various categories,
and for each category, its related subcategories. Each subcategory then
contains various items.
My question is, for performance, would it be better to assign each
category/subcategory pair a unique ID number and then anyti
On Fri, Sep 12, 2003 at 03:35:55PM +0200, Mikhail Entaltsev wrote:
> Hi,
>
> IMHO it's nice idea...
>
> http://www.ashleyit.com/blogs/brentashley/archives/000339.html
Have you seen this?
http://www.sklar.com/page/article/myphp
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Maga
On Thu, Sep 18, 2003 at 01:47:04PM -0400, [EMAIL PROTECTED] wrote:
> I have a database called abc-100 which seems to cause problems with
> replication and importing sql files created with mysqldump.
>
> First, if on the master we create a temporary table (because we
> don't have subselects yet) it
On Thu, Sep 18, 2003 at 10:07:22AM +0200, Franky wrote:
> Jeremy Zawodny wrote:
>
> > On Tue, Sep 02, 2003 at 05:34:12PM -0500, Lewis Watson wrote:
> >
> >>I currently have three mysql machines replication from A-B-C-A type
> >>fashion. I need to replace A. I am thinking that I could add D and ha
On Thu, Sep 18, 2003 at 11:38:17AM +1000, electroteque wrote:
> rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
> try.
No. That's what I meant about having to put extra smarts in your code.
It needs to be able to undo its actions.
> On Fri, 2003-09-19 at 08:01, Jeremy Zawo
Righty, so if error unlock table hehe, i have found i need to produce my
error first then do a rollback for an error to display in php as it wouldnt
show a mysql error after a rollback, i guess i could add an unlock table in
my trigger error function too.
> At 11:38 AM +1000 9/18/03, electroteque
>
> No rollback does not work on myisam Jeremy was stating that you don't
> have to do what you suggested to implement a correct ROLLBACK in mySQL.
> Use INNODB.
>
> http://www.mysql.com/doc/en/COMMIT.html
>
>
Hmm if you got my other post i am trying to simulate innodb in myisiam for
projects tha
Hi,
No, ROLLBACK doesn't work with MyISAM. Jeremy meant that you can add
logic/code between LOCK/UNLOCK to "simulate" ROLLBACK. e.g. queries that
"undo" what you did if something goes wrong. Of course this won't cover
you if mysqld dies, is killed, or you lose the connection etc. as real
transacti
At 5:14 PM -0500 9/18/03, <[EMAIL PROTECTED]> wrote:
I'm not quite sure why I haven't run across this in the past, but now that I
have I am stumped. I am needing to update a table based on criteria found in
it and one other table, but I am uncertain how to proceed. If I had
subselects I would run t
At 11:38 AM +1000 9/18/03, electroteque wrote:
rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
try.
Rollback *doesn't* work with MyISAM, that's why Jeremy said you have
to put the necessary logic in your application if you want to achieve
the same effect.
At least, that's wha
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: electroteque [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, September 17, 2003 6:38 PM
-->To: [EMAIL PROTECTED]
-->Subject: Re: Lock t
I'm not quite sure why I haven't run across this in the past, but now that I
have I am stumped. I am needing to update a table based on criteria found in
it and one other table, but I am uncertain how to proceed. If I had
subselects I would run the query as follows, I believe:
UPDATE suppliercatl
Harald,
How often do you read 200 rows by key in a daya to day application?
How often do you insert 350768 rows in an application that you're
considering Win98 as the platform?
I've never deployed MySql on Wintel, except for developing on my laptop. I
always use Solaris or Redhat for serious
At 4:56 PM -0500 9/18/03, Allen wrote:
DISTINCT key_field is fine. I don't think it will make a
difference. My example was using only one field.
Your example was using three fields by my count.
DISTINCT field1 is likely to yield a different result than
DISTINCT field1, field2, field3. What form
rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
try.
On Fri, 2003-09-19 at 08:01, Jeremy Zawodny wrote:
> On Thu, Sep 18, 2003 at 03:00:17PM +1000, [EMAIL PROTECTED] wrote:
> > Hi there i have a couple of projects which required fulltext searching so
> > was unable to setup
On Thu, Sep 18, 2003 at 02:53:29PM -0400, Gabriel Ricard wrote:
> Is there any way to see what MySQL is storing in memory? Like, for
> instance, what is stored in the query cache, or at least what tables
> have data stored in the query cache, and how much they have stored?
Nothing other than wha
On Thu, Sep 18, 2003 at 01:57:17PM +0300, Mikko Noromaa wrote:
> Hi,
>
> Is it possible to configure MySQL so that it would allocate a large amount
> of extra space for the MYD/MYI files, and then use this space as necessary?
I don't know of any.
> This way the files would need to be grown only
At 1:43 PM -0400 9/18/03, Randy Chrismon wrote:
Here's a snapshot from a mysql environment:
mysql> LOAD DATA LOCAL INFILE 'c:/mysql/miamibilling-Cash.txt'
-> REPLACE INTO TABLE ln_cash
-> FIELDS TERMINATED BY '|'
-> ENCLOSED BY '~'
-> LINES TERMINATED BY '\r\n'
-> ;
On Thu, Sep 18, 2003 at 03:00:17PM +1000, [EMAIL PROTECTED] wrote:
> Hi there i have a couple of projects which required fulltext searching so
> was unable to setup innodb on these. I was wondering if lock tables is a
> secure way to make the transaction on these tables and does this prevent
> bein
DISTINCT key_field is fine. I don't think it will make a difference. My example was using only one field.
Paul DuBois wrote:
At 4:22 PM -0500 9/18/03, Allen wrote:
Ok. I looked through google and saw a couple examples of how to find
the duplicates in a table that looked like this...
SELECT
At 4:22 PM -0500 9/18/03, Allen wrote:
Ok. I looked through google and saw a couple examples of how to
find the duplicates in a table that looked like this...
SELECT date, time, id, count(*) as n from session GROUP BY date,time,id
HAVING n > 1;
Ok. So I tried it. I have a table of 13,128,178 r
Ok. I looked through google and saw a couple examples of how to find the duplicates in a table that looked like this...
SELECT date, time, id, count(*) as n from session GROUP BY date,time,id
HAVING n > 1;
Ok. So I tried it. I have a table of 13,128,178 rows (not a small example). I ran a DIST
On Thu, Sep 18, 2003 at 01:14:47PM -0400, Christopher Ferry wrote:
> We're running bi-directional replication between two servers running
> MySQL 3.23.56.
>
> One server being active the other a hot standby.
> Wanting to switch to the hot standby I noticed that replication had
> ceased on the HS s
Hi,
I have a server which has been running for about a year now. It
started with kernel 2.4.19 and mysql 3.x it has since been continually
upgraded so that it is now kernel 2.4.20 and mysql 4.0.13. The server is
a Compaq server with dual Pentium II (Deschutes) 400MHz 512Kb cache
CPUs, 320Mb RAM an
I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field
SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size
SEPARATOR ";") as sizes,Item_Img,
Description,Category,Retail_Price,Short_Desc,Product.Item_Color
FROM Cat_Items,Product
WHERE cat_code ="BoltTech" an
Sometimes I get this error on a slave... for unknown reasons
Error 'Incorrect key file for table: 'hasit'. Try to repair it' on query
'REPLACE INTO hasit
If there is a wish list could the error report 'db.table'?
Also why doesn't mysql automatically fix the error itself when the error
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
several binary packages of the initial release of MySQL 4.0.15 did not
include the embedded server library "libmysqld.a", because of a
compile/linking error with the compilers used on these platforms. As a
workaround, the creation of the embedded
On Thu, Sep 18, 2003 at 12:44:10PM +0100, Haydies wrote:
> I have only one thing to say really on this. Data never has any meaning at
> all. It is simply data, and not information. Information is extracted from
> data and is then given meaning by the viewer of the data.
True. We were arguing about
Is there any way to see what MySQL is storing in memory? Like, for
instance, what is stored in the query cache, or at least what tables
have data stored in the query cache, and how much they have stored?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
FYI
I want to share this with others JIC you didn't know. I asked a question
about slave compatibility between masters and slaves of different
versions. Here is the compatibility matrix chart found.
http://www.mysql.com/doc/en/Replication_Implementation.html
Master
Master
Master
Maste
I'm not normally one to panic, and I know I can revert back to an old
3.23.57 version, but this is concerning and was hoping a guru could tell me
what is wrong here. After the rpm upgrade, all my databases show up (ie. In
phpMyAdmin for example), but they all show (-) for the tables -- in
otherwor
The same thing happens whether or not I use the PHP script or a standard
SQL script as described in my original post, so I don't think it is a
PHP problem. Below is two snapshots, one @ 2:06 and the second @ 2:11,
if this is hard to read due to formatting let me know and I can send it
to you as an
Yes, you are correct. I was thinking that wouldn't be the case, but it makes sense now. I added indexes and then the query returned in a few seconds. Definitely have to have indexes.
Thanks!
Dan Nelson wrote:
In the last episode (Sep 18), Allen said:
I have two tables. One table is 13 milli
I have a database called abc-100 which seems to cause problems with
replication and importing sql files created with mysqldump.
First, if on the master we create a temporary table (because we
don't have subselects yet) it causes the slave to die with the
following.
Relay log says:
DROP /*!40005
Here's a snapshot from a mysql environment:
mysql> LOAD DATA LOCAL INFILE 'c:/mysql/miamibilling-Cash.txt'
-> REPLACE INTO TABLE ln_cash
-> FIELDS TERMINATED BY '|'
-> ENCLOSED BY '~'
-> LINES TERMINATED BY '\r\n'
-> ;
Query OK, 16374 rows affected (20.83 sec)
Recor
What do you mean it doesn't release itself? Can you provide some free
examples of before and after then 5 min after that?
The indication from the content of the below message is that the PHP
version in use has a memory leak. 1st you need to make sure that the
memory is not being put into a cache p
Somebody suggested that I create the cron job as a php scripts, so I
did:
include("dbinfo.inc.php");
$connect = MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable
to connect to the database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$insert = "INSERT INTO sys
Well I figured out what was going on, MS uses a LF,CR instead of just a Line
feed. The was corrupting the first column. I added a LINES TERMINATED BY
statement and put in the '\r\n'. Now everything works fine.
Thanks again.
- Original Message -
From: "upscope" <[EMAIL PROTECTED]>
To: "MySq
We're running bi-directional replication between two servers running
MySQL 3.23.56.
One server being active the other a hot standby.
Wanting to switch to the hot standby I noticed that replication had
ceased on the HS server. The show slave status:
| 192.168.1.10 | mysql_replicator | 3309
Are these numbers still valid? Those documents are quite old - well
before the time of 4.0 being declared production ready and before the
inclusion of InnoDB tables. Since then, the Windows port has had a lot
of work done on it and many of the "TODO" sections at the bottom have
been taken care of.
"Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> wrote:
>
> I tried
> SELECT * FROM WHERE LIKE '%?%';
> to find out if german umlauts (???) are imported.
>
> In the resultset where some ds with '?' and some with 'y'.
> So the charset itself seems to be OK but why did I get 'y'.
> They sound some
Recently, the great Heikki said that the following directive should also
defragment your InnoDB tables:
ALTER TABLE table_name TYPE=InnoDB;
How was it put...ah yes, a "table no-op".
Regards,
Chris
On Fri, 2003-09-19 at 01:32, Gustavo A. Baratto wrote:
> from the manual:
> -
> 7.5.12.3
Thank you,
I have checked all of the above. I have set the max connections to 200, but
that didn't help any. The connection per hour is not a factor because it
doesn't lock out the user, it just fails to authenticate, but as soon as you
refresh the page or try to connect via the command line to go
"Chris" <[EMAIL PROTECTED]> wrote:
>
>Quick question... I need to be able to send a query like:
>
> select cd,fid,s_from,s_to from ima where '3355443200' between s_to and
> s_from
>
> Thats fine and all, but when I get my results I pull 2 records:
>
> MA smith 335544320 352321535
> BS m
On Thu, Sep 18, 2003 at 12:49:09PM -0300, Gustavo A. Baratto wrote:
> I already use linuxthreads for freebsd...
Ah, okay. Most don't, which is why I mentioned it.
> Do you think mysql would run well with the new threads for freebsd 5.XX?
> Did anybody try it?
In theory, yes. In practice, not
At 11:17 AM 9/18/2003, you wrote:
It's not a continued access denied, because it can accept connections all
day long, but randomly it will just deny one, but the accept it on the next
try.
I've googled this problem to death, I don't know what else I can do
James,
Are you sure it's not something si
It's not a continued access denied, because it can accept connections all
day long, but randomly it will just deny one, but the accept it on the next
try.
I've googled this problem to death, I don't know what else I can do
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wedn
"Tore Bostrup" <[EMAIL PROTECTED]> wrote:
>
> MySQL 3.23.36 (yeah, I know it's getting old...):
>
> What permission do I need to run the following query:
>
> REVOKE ALL
> ON mydb.* FROM 'sdaf'@'%';
>
> I get an error 1044:
> "Access denied for user: 'Admin@' to database 'mydb'"
>
> My user ha
In the last episode (Sep 18), Gustavo A. Baratto said:
> I already use linuxthreads for freebsd...
>
> Do you think mysql would run well with the new threads for freebsd
> 5.XX? Did anybody try it?
I've been running mysql 4.1 on a -current box with likse threads and
haven't had any problems. I
Allen wrote:
I have two tables. One table is 13 million rows the other is about
250,000. I am trying to join the two to find users. The tables are not
indexed and I know that will effect the speed, but the join never
completes. I let it run for about 10 hours and the process was stuck in
th
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>
> Sorry. I am wrong. Situation is worse.
> Both tables aren't replicate to the slave.
> But query try run it on slave :(
>
> slave: mysql-4.0.13
> master: mysql-4.0.14
What replication options do you use?
>
>>
>> I have 2 servers. 1-st is master, 2
I already use linuxthreads for freebsd...
Do you think mysql would run well with the new threads for freebsd 5.XX?
Did anybody try it?
thanks
Jeremy Zawodny wrote:
On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote:
no problem for me... 1000+ DBs on RH linux (ext3 fs), then mov
In the last episode (Sep 18), Allen said:
> I have two tables. One table is 13 million rows the other is about
> 250,000. I am trying to join the two to find users. The tables are not
> indexed and I know that will effect the speed, but the join never
> completes. I let it run for about 10 h
On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote:
> no problem for me... 1000+ DBs on RH linux (ext3 fs), then moved it to
> freebsd 5.1 (almost 1500). Linux is probably faster because of the
> kernel based thread, but I like BSD.
If you use LinuxThreads on FreeBSD, it's nearly
On Thu, Sep 18, 2003 at 08:20:00AM -0700, Scot Campbell wrote:
> O.K., I understand. And I have always coded in this manner.
>
> Throw the data at the system and see if it sticks. In most cases it will.
>
> However, when it does fail, it would be nice to determine the error w/o
> issuing more
from the manual:
-
7.5.12.3 Defragmenting a Table
If there are random insertions or deletions in the indexes of a table,
the indexes may become fragmented. By fragmentation we mean that the
physical ordering of the index pages on the disk is not close to the
alphabetical ordering of the
from the manual:
-
7.5.12.3 Defragmenting a Table
If there are random insertions or deletions in the indexes of a table,
the indexes may become fragmented. By fragmentation we mean that the
physical ordering of the index pages on the disk is not close to the
alphabetical ordering of the
I have two tables. One table is 13 million rows the other is about 250,000. I am trying to join the two to find users. The tables are not indexed and I know that will effect the speed, but the join never completes. I let it run for about 10 hours and the process was stuck in the "sending" state
Hi all,
for myisam tables we have "optimize table" that can be cronned to run at
night, but is there something like this for the innodb table type as well?
Franky
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
O.K., I understand. And I have always coded in this manner.
Throw the data at the system and see if it sticks. In most cases it will.
However, when it does fail, it would be nice to determine the error w/o
issuing more calls.
So, the school solution is, "When a unique constraint is violated,
Hi, All!
SQL, mysql
Sorry. I am wrong. Situation is worse.
Both tables aren't replicate to the slave.
But query try run it on slave :(
slave: mysql-4.0.13
master: mysql-4.0.14
>
> I have 2 servers. 1-st is master, 2-d - slave.
> But slave store only some tables of master.
> For example, master h
Alec,
My point was that in a 40,000 row database, server speed is irrelevant -
it's going to be sub second on anything more powerful than my mobile phone.
Cost of ownership is much more important for this application, and that
depends on the particular circumstances.
Andy
> -Original Messag
> I don't see anything in there that is relevant to the original posting.
The tables headed "Speed difference between different SQL servers (times in
seconds)"
The top row of each table shows times for the same operation on Linux and
Windows, showing that for both operations tested, Linux achi
Hello
I hope you can help with this enquiry.
I have a small access db split front and back end used by a small group. I
would like to convert it to MySQL but my only knowledge is with access. I
would also like to investigate the possibilty of producing small db for
other people. I accept that i w
Tormod,
I feel your pain brother! Actually, I do this allot more than I'd prefer to
admit.
I assume when you say MS SQL you mean SQL Server 2000. When you say MySQL,
you mean MySQL 4.0.x. Scripting the database/tables from query analyzer
doesn't produce files, which are immediately executable in
I am using the following command to load a table:
LOAD DATA LOCAL INFILE "email.txt" INTO TABLE email;
The command works and the second and third column go in correctly. But the
first column is not loading correctly. I am using Notepad on WIN ME to
generate the txt file.
JohnDoe[EMAIL PRO
I'm pretty sure you need to sync the entire database (all tables) to all
slaves before starting replication..Your servers are technically
already out of sync..
And no wonder it crashes, tables are missing in it's view..You need to
hit the initial replication setup manual pages..
On Thu,
no problem for me... 1000+ DBs on RH linux (ext3 fs), then moved it to
freebsd 5.1 (almost 1500). Linux is probably faster because of the
kernel based thread, but I like BSD.
You definetely have to tune your my.cnf... use thread and query cache,
increase the key buffer, optimize tables very oft
Most likely you'd need to do some datatype mapping changes to the
script...
Everyone I know who's had to do this has typically used something like
sqlyog (search google) and used the ODBC import cabability to transfer
data from MSSQL -> MySQL..
On Thu, 18 Sep 2003, Tormod Halvorsen wrote:
> Hi
Hi, All!
SQL, mysql
I have 2 servers. 1-st is master, 2-d - slave.
But slave store only some tables of master.
For example, master has tables A, B
But slave has only A table
The problem:
query: UPDATE A,B SET A.a=B.a WHERE A.c=B.c;
the result: crash replication on slave;
Is it right?
Best
Hi all!
(My apologies if this has been beaten to death allready, but I *did*
search the archives without much luck.)
I'm moving from MS SQL to MySQL. Before jumping from the old server, I
scripted out the definitions for tables and their fields, thinking I
might just run them into MySQL. Guess
I don't see anything in there that is relevant to the original posting.
Andy
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
> Sent: 18 September 2003 14:04
> To: [EMAIL PROTECTED]
> Subject: Re: Platform vs. Performance
>
>
> In article <[EMAIL PROTECTE
Patrick Shoaf <[EMAIL PROTECTED]> wrote:
> I have a table name product defined as follows:
> Item_Code
> Item_Size
> Item_Color
> Item_img
> Description
> Cost
> Retail_Price
> Category
> and other non-essential items, such as qty based on code,size,&color
>
> The data is as follows:
> j2400 S
Hi All,
I'm designing a rather large database, and I'm concerned about performance.
Was wondering if anyone had any comments/advice?
The particular table I'm concerned about will have about 10 million lines,
each referencing a physical item I need to track. Each item in the table
will have a auto
Hi Jamie:
Thank very much you for your help.
EDWIN LIMACHI N.
DATACOM - Instalaciones
TSE - INFONET BOLIVIA
Phone. 591-2-2123978
Movil: 591-715-29967
Fax: 591-2-2123975
"James M Kupernik" <[EMAIL PROTECTED]>
17/09/2003 21:01
Por favor, responda a
<[EMAIL PROTECTED]>
Para
<[EMAIL PROTECT
Hello,
I started getting this error since I upgraded from mysql 4.0.13 to 4.0.15:
030918 7:17:13 InnoDB: Error: page 12412 log sequence number 0 670697749
InnoDB: is in the future! Current system log sequence number 0 186563990.
InnoDB: Your database may be corrupt.
any idea how to get rid of t
> The main table is rather huge, it has 90 columns and now after
> three month it has 500.000 records... but in the end it has to store data of
> 36 month.
Hmm, I think you had better look at normalizing your data, and creating
indexes. Start with the indexes since that won't force you to make an
I have only one thing to say really on this. Data never has any meaning at
all. It is simply data, and not information. Information is extracted from
data and is then given meaning by the viewer of the data.
In the case of NULL I have always thought of it is simply "undefined". Thats
what Orecal s
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,&color
The data is as follows:
j2400 S BLK j2400blk.jpgBlack Jacket12.00 24.00 Jacket
Piko,
Please see http://www.mysql.com/doc/en/String_functions.html for more
information about String functions in the SELECT. The function you're
looking for is CONCAT or CONCAT_WS.
Harald
- Original Message -
From: "Michael Piko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursd
Abs,
On Thu, Sep 18, 2003 at 08:35:25AM +0100, Abs wrote:
> --- Daniel Kasak <[EMAIL PROTECTED]> wrote:
> > Abs wrote:
> >
> > >mysql and php question:
> > >the magic_quotes_gpc is set to 1. when i echo it to
> > >the browser, it shows the added slashes. i inserted
> > >these same values into a
Do you use indexes?
See http://www.mysql.com/doc/en/CREATE_INDEX.html.
In my system a retrieval from a 24 million records table (3 columns) with a
result of 25 records only took 0.09 sec and 24 million records table with 5
columns 0.25 sec
Harald
- Original Message -
From: "Schonder, M
Hi,
Someone asked me if it were possible to do the following SELECT
statement in MySQL.
I am sure we need a workaround for this.
Can someone please offer any clues or even answers?
The statement:
SELECT ename, empno, mgrnr, job
FROM emp
START WITH job = PRESIDENT""
CONNECT BY PRIOR empno = mg
1 - 100 of 121 matches
Mail list logo
