Re: Help!
Thanks so much to everyone who replied I got it working perfectly you guys rule! Armando On Tuesday 18 September 2001 09:56 am, you wrote: > > I try the following command, and get that error every time: > > > > > > mysql> select company, tele, contact, mariacust.comments > > -> from > > -> customers where tele = mariacust.tele GROUP BY company; > > ERROR 1109: Unknown table 'mariacust' in field list > > mysql> > > > > > > I don't quite understand why this happens since everything exists > > > > Armando > > Everything may exist, but you didn't reference mariacust in your _from_ > statement. > > select customers.company, customers.tele, customers.contact, > mariacust.comments > from > customers, mariacust > where custmers.tele = mariacust.tele > GROUP BY customers.company; > > Or something like that... > > Jay Fesco > > Magical Mystery Words: database,sql,query,table > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help!
I try the following command, and get that error every time: mysql> select company, tele, contact, mariacust.comments -> from -> customers where tele = mariacust.tele GROUP BY company; ERROR 1109: Unknown table 'mariacust' in field list mysql> And yes... the talbe exists. mysql> show tables; +-+ | Tables_in_maria | +-+ | cathycust | | customers | | inventory | | invoices| | mariacust | | salesid | +-+ 6 rows in set (0.00 sec) I don't quite understand why this happens since everything exists Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Overwrite only if it exists HELP please!
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 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 > > INSERT IGNORE > > will ignore the new record if it duplicates an existing record on > a primary key value. > > It's in the manual: > http://www.mysql.com/doc/I/N/INSERT.html > > >TIA > >Armando > > > >- > >Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Overwrite only if it exists HELP please!
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Updating Customer table
Hi I am trying to update a table that is full of customer ID's using another table with the following command update customers set row_id=mc.id where tele=mc.tele; But it give me the error ERROR 1109: Unknown table 'mc' in where clause The table mc does exist I am pretty lost on this one any help would be great Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Adding Customer ID numbers to and already existing table
How would I add customer id numbers which start at 1000 to an already existing table. I need these numbers to auto_increment. Any help would be great Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing auto_increment field in mysql to start at 1000
I tried this: update customers set row_id='1000' where row_id='1'; but that only changed the one field in the table and the other ones stayed the same =(. Could someone please tell me the correct way to do this Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dbf2mysql problem please help
I have problems only converting certain DBF files to mysql with dbf2mysql. Some work but some don't and when they dont' I get the following error bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF Error creating table! Detailed report: You have an error in your SQL syntax near 'DESC varchar(20) not null) ' at line 2 I have no clue why this happens if anyone could help it would be great thanks Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Overwriting records with matching fields with dbf2mysql
What would be the best way to do this because I am working on a mysql replacement to an old foxpro database and I can import the table once but I am worried that if I try to import it again it will make duplicate records. Another issue is that I have added an extra field to the table which is not in the original table but I would like to keep it preserved some how. Any help would be great. Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-server.sh gone in freebsd
HI installed the mysql-server port in freebsd and the /usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before and I fixed it by reinstalling I think but I would like to avoid this. Does anyone know anything about this? Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Converting an old Foxpro dos database to mysql/php
Do you happen to have a url on how to do this especially the foxpro portion I don't know to much about it On Mon, 30 Jul 2001, Christopher R. Jones wrote: > The simplest thing to do is to run the foxpro database and export the > records to a text file. Run the SHOW STRUCTURE command to list the table > structures and then set up a new mysql database that mimics the foxpro > table structure. > > > >I have an old database that is running on foxpro that is used for sales > >and order entry at my work and I was wondering how I would go about > >porting it to a *nix enviorment. The first step is the port the dbf files > >I think so I grabbed a copy of dbf2mysql and tried messing around with it > >and when I do I get an error like this: > > > >bash-2.05$ dbf2mysql CAT.DBF > >Table does not exist! > > > >What I would eventually like to do Is have mysql installed on a freebsd > >box at work and then have all the workstations that run windows be able to > >enter invoices from netscape or internet explorer over the lan. I would > >love if someone could point me in the right direction on where to get > >started and some interesting websites to read about this. I am a newbie > >with all this database stuff. Please CC a reply to my email address > >[EMAIL PROTECTED] because I do not subscribe to the mailing list. > >Thanks in advance for all your help > > > >Armando > > > > > > > >- > >Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > Christopher R. Jones, P.Eng. > 14 Oneida Avenue > Toronto, Ontario M5J 2E3 > Tel. 416 203-7465 > Fax. 416 203-8249 > Email [EMAIL PROTECTED] > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting an old Foxpro dos database to mysql/php
I have an old database that is running on foxpro that is used for sales and order entry at my work and I was wondering how I would go about porting it to a *nix enviorment. The first step is the port the dbf files I think so I grabbed a copy of dbf2mysql and tried messing around with it and when I do I get an error like this: bash-2.05$ dbf2mysql CAT.DBF Table does not exist! What I would eventually like to do Is have mysql installed on a freebsd box at work and then have all the workstations that run windows be able to enter invoices from netscape or internet explorer over the lan. I would love if someone could point me in the right direction on where to get started and some interesting websites to read about this. I am a newbie with all this database stuff. Please CC a reply to my email address [EMAIL PROTECTED] because I do not subscribe to the mailing list. Thanks in advance for all your help Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php