Re: Help with a JOIN query please

2005-03-18 Thread Krasimir_Slaveykov
(11) | | | 0 | st> | Mileage| int(11) | |

Re: [Q] INSERT INTO ... SELECT

2004-02-03 Thread Krasimir_Slaveykov
was more than 2GB Hoever, in my 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 PRO

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
g query : H> SELECT pubishers.pub_id, titles.pub_ID H> FROM pubishers JOIN 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 wr

Re: auto number primary key - restarting

2003-07-15 Thread Krasimir_Slaveykov
(auto number 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 un

Re: the number of Rows (records)

2003-07-14 Thread Krasimir_Slaveykov
s a MF> 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 PROT

Re: the number of Rows (records)

2003-07-14 Thread Krasimir_Slaveykov
e of a table plus 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

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

2003-07-14 Thread Krasimir_Slaveykov
gt;> >> Thaks Ge0rge >> >> >> Want to chat instantly with your online friends? Get the FREE Yahoo! >> Messenger http://uk.messenger.yahoo.com/ >> >> -- >> MySQL General Ma

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

2003-07-14 Thread Krasimir_Slaveykov
rest which are in between the Max and Min. SF> 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] --

Re: LIMIT question

2003-07-14 Thread Krasimir_Slaveykov
SBC Yahoo! DSL - Now only $29.95 per month! -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: grouping / sorting etc..

2003-07-14 Thread Krasimir_Slaveykov
rows) CK> I could do the 2nd way then filter out w/ the code... CK> Is there a better way? CK> Thanks CK> Chris -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 9

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

constructing SQL problem

2003-07-10 Thread Krasimir_Slaveykov
rds are excluded 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 lis

Re: Can mysql handle this load?

2003-07-09 Thread Krasimir_Slaveykov
/ Computer Teacher AG> Columbia Grammar and Prep School AG> 212-749-6200 AG> [EMAIL PROTECTED] AG> www.cgps.org -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++

Re: replication / table copy question

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

Re[2]: have a problem

2003-04-02 Thread PandaCoop-Krasimir_Slaveykov
find a reason yourself, you might send the output of the SH> following statement to the list: mysql>> SHOW TABLE STATUS LIKE 'table1'; SH> This might help us find the reason for your problem. -- Best regards, PandaCoop-Krasimir_Slaveykovmailto

Interesting !?!

2003-04-02 Thread PandaCoop-Krasimir_Slaveykov
sslist | ++---++--+-+--+---+--+ 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

have a problem

2003-04-02 Thread PandaCoop-Krasimir_Slaveykov
rver version: 4.0.12 -- 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]

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