Re: Help with a JOIN query please

2005-03-18 Thread Krasimir_Slaveykov
| st | Mileage| int(11) | | | 0 | st ++--+--+-+++ st 8 rows in set (0.00 sec) mysql -- Best regards, Krasimir_Slaveykov, 18 Ìàðò 2005 ã., 12:54:56 mailto: [EMAIL PROTECTED] [EMAIL PROTECTED

Re: [Q] INSERT INTO ... SELECT

2004-02-03 Thread Krasimir_Slaveykov
case I found desicion to read and insert data record by record. Slowly, but success. -- Best regards, Krasimir_Slaveykov, 03 Ôåâðóàðè 2004 ã., 15:49:27 mailto: [EMAIL PROTECTED] [EMAIL PROTECTED

SQL and productivity

2004-01-30 Thread Krasimir_Slaveykov
table, filling data and then create indexes? -- Best regards, Krasimir_Slaveykov mailto: [EMAIL PROTECTED] [EMAIL PROTECTED

Re: Unable to perform Inner Join

2003-07-17 Thread Krasimir_Slaveykov
pubishers ON pubishers.pub_id = titles.pub_id H It keeps giving me the following error : H Error Code : 1066 H Not unique table/alias: 'pubishers' H Can someone tell me what I am doing wrong ? -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel

Re: auto number primary key - restarting

2003-07-15 Thread Krasimir_Slaveykov
key) to start numbering from beginning after deleting all the records from the table. MI thanks -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: grouping / sorting etc..

2003-07-14 Thread Krasimir_Slaveykov
regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Getting all values between a max and a min value

2003-07-14 Thread Krasimir_Slaveykov
Somebody help me out..i can't use subqury or union as i am using Mysql 3 -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re[2]: How to copy records in one table?

2003-07-14 Thread Krasimir_Slaveykov
! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: GC http://lists.mysql.com/[EMAIL PROTECTED] -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL

Re: the number of Rows (records)

2003-07-14 Thread Krasimir_Slaveykov
Row Length more information. How can we find these MF table information? MF Thanks -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731

Re: the number of Rows (records)

2003-07-14 Thread Krasimir_Slaveykov
table has? phpMyAdmin shows the number of records ( Rows ) when shows the MF structure of a table plus Row Length more information. How can we find these MF table information? MF Thanks -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL

Re: Can mysql handle this load?

2003-07-10 Thread Krasimir_Slaveykov
[EMAIL PROTECTED] AG www.cgps.org -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731 -- MySQL General Mailing List For list archives: http

constructing SQL problem

2003-07-10 Thread Krasimir_Slaveykov
from results. I needed them nevermind they have record in TABLE3 or not. Anyone help? -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

2 or more LEFT JOIN?

2003-07-10 Thread Krasimir_Slaveykov
... how to write in SQL statement? Thanks. -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: replication / table copy question

2003-07-03 Thread Krasimir_Slaveykov
, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

have a problem

2003-04-02 Thread PandaCoop-Krasimir_Slaveykov
-- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Interesting !?!

2003-04-02 Thread PandaCoop-Krasimir_Slaveykov
| ++---++--+-+--+---+--+ 5 rows in set (0.01 sec) Your MySQL connection id is to server version: 4.0.12 -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re[2]: have a problem

2003-04-02 Thread PandaCoop-Krasimir_Slaveykov
: mysql SHOW TABLE STATUS LIKE 'table1'; SH This might help us find the reason for your problem. -- Best regards, PandaCoop-Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Need help about SQL sintax

2003-03-05 Thread PandaCoop-Krasimir_Slaveykov
-- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive