I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure that I can run.

Any help will be appreciated,
Thanks.

Hi all,

I’m am still learning mysql so please excuse anything I may not understand.

I need to update 12k records in a mysql table (about 5 fields per record) twice a day, and it needs to be done automatically (probably with curl).

My data source is a comma delimited text file. I would prefer to use php. I am working in a LAMP environment.

If anybody has some pointers it would be a great help.

Hi All! First, I have two tables in different Database , I want to coppy all data from Table 1 to table 2. Two tables have the same fields. I program in VBA 6, How can I use a SQL command to do it.
Second, I want to creat a crystal report 4.6, Where can I start? Thanks for Answers : pretty:

While i was importing .sql file in my database i got this error #1064.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `att_poll_log` (
`id` int(10) unsigned NOT NULL au’ at line 4 

The actual code written in .sql file is:

CREATE TABLE IF NOT EXISTS `att_poll_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `news_id` int(10) unsigned NOT NULL default ‘0′,
  `member` varchar(30) NOT NULL default ”,
  PRIMARY KEY  (`id`),
  KEY `news_id` (`news_id`,`member`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=19 ;

Please help this out.