dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Insert to MySQL Crate Table... Problematic code!

  1. #1
    Join Date
    Jun 2006
    Posts
    290

    Insert to MySQL Crate Table... Problematic code!

    connTacts.Execute "Create Table '" & txtUName.Text & "' (`contacts` VARCHAR (32) NOT NULL)"


    any idea where im going wrong with the syntax on that one?

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    For CREATE TABLE you do not need the single quotes around the table name or the field name
    Code:
    "Create Table " & txtUName.Text & " (contacts varchar (32) NOT NULL)"

Similar Threads

  1. Can't INSERT into MySQL with PHP
    By hnmcc in forum Database
    Replies: 0
    Last Post: 08-23-2010, 05:41 PM
  2. Microsoft's C++ bigotry
    By Phil Weber in forum .NET
    Replies: 632
    Last Post: 10-01-2003, 12:00 AM
  3. insert records w/ sql(with code)
    By Nejla in forum VB Classic
    Replies: 2
    Last Post: 07-23-2001, 07:31 AM
  4. Replies: 1
    Last Post: 02-09-2001, 09:42 PM
  5. Multi Table Insert
    By Sal in forum Database
    Replies: 1
    Last Post: 11-30-2000, 11:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center