hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and city should be the name of table in example. Thanks :)

Member Avatar
Member Avatar
+0 forum 3

i have two tables [ICODE] Articles id bigint 20 unsigned pk autoinc date_modified datetime name varchar title varchar content text Tags id bigint 20 unsigned pk autoinc name varchar [/ICODE] and i want to create this third table from above two tables [ICODE] Articles_Tags article_id bigint 20 unsigned tag_id bigint 20 unsigned [/ICODE] how this table can be created using mysql query ??

Member Avatar
Member Avatar
+0 forum 1

This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID number PRIMARY KEY, Dept_Name varchar2(25) NOT NULL UNIQUE, City varchar2(50) NOT NULL, Budget_Code char(5) NOT NULL UNIQUE, Mailstop char(3) NOT NULL);[/CODE] The constraints are in all caps. Also, I need to know how to do multiple constraints. Can someone help me on this? The second table I have:[CODE] create table …

Member Avatar
Member Avatar
+0 forum 3

The End.