Knowledge Base Contributions

Below is a list of the knowledge base entries that Euan MacInnes has contributed to:

• Why do negative integers (BIGINT) sometimes show up positive through ODBC?
  

• Why do negative integer values, visible properly through MyCC, come through ODBC as positive?
  

• Maybe there are ways to create MS Access applications with direct access to MySQL server? (no odbc)
  

• Storing HTML tags in MySQL data
  

• How can I update more than one record at a time? i.e record 1, 5, 9 Thanks
  

• How can I UPDATE table set field=value where field2 in (select field3 from other_table)?
  

• Does mysql have a rowid that is similar to oracle's rowid
  

• Q: Can i use stored procedures, foreign keys and triggers.
  

• I'd like to set up a foreign key between two tables. Write a string I have to use for me please.
  

• how do i join 3 tables where one of them a map table the other 2 contain actoual data?
  

• calculating vaules in rows ...
  

• How do I update all fields in a column with the value of all fields in another column?
  

• In Active Server Page, we can create DSN-less connection for Access database, How about Mysql?
  

• I have Two tables Contacts and Address. What is the easiest way to reference an address to a contact?
  

• What connection string should be used for connecting to MySQL on Win32 without a DSN?