This is my first time using C to access and enter data into a database, so please bear with me. For example, just logging into My SQL and doing SHOW DATASES will print all the Databases in mysql.SHOW TABLES will show all the tables in the database.In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.In turn, those design principles affect how you enter data.SELECT * FROM will list all the data stored in the tables.
| BHXSpecter | | 3 | 0000-00-00 | | Comments | BHXSpecter | | 4 | 2013-05-25 | | I LOVE MY WIFE!!!!!!!!!!!
I'm having trouble getting INSERT INTO to work properly for me.
At first, I kept getting the "Unknown column 'myvariablename' in 'field list', but when I changed the string, I ended up getting the error "Duplicate entry ' ' for key 'Primary' ".
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
Large updates become much easier to perform when you understand some of the basic principles of database design.
To specify a column alias, use the SQL object, and the value has to be converted back to a numeric type before it can be operated on as a number.