according to sql buddy

the mysql is 5.0.75

when I try to create a table i get the following error

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 'charset latin1 auto_increment primary key, `comp` varchar(30)) CHARSET latin1' at line 1

I also tried creating a table through a query, which also created an error.

any ideas anyone?

Can you please share the query you gave ?

use following query

mysql> CREATE TABLE example_innodb (
id INT,
data VARCHAR(100)
) TYPE=innodb;

I think it should be something like the syntax $variable="CREATE TABLE address(ID int(7) NOT NULL auto_increment, name varchar(50) NOT NULL, PRIMARY KEY (ID) )"; mysql_query($variable); Then you update the tables with new values. But connect to the database first. I don't know if this is really your problem, but that's how to create a table

I have no I idea about the Mysql but I know the Sql.

Create the table

create table table name
(
declare the column like
column_name datatype;
)

Now the next question is why would you create a table in a procedure. Unlike t-sql, oracle almost never needs temporary tables

Please change the table name of query then Execute the Query again..
create table tablename
(

column_name datatype;

)