Jump to content

No primary key


Agent Havixx

Recommended Posts

First, a little bit of info:

 

  • MySQL server version: 5.0.51a (I'm using Windows XP)
  • MySQL Statement is this:
     
    spells112 does not have a primary key.
    Updates to this table will be done using the following pseudo statement:
    UPDATE spells112 SET ModifiedFieldsAndValues WHERE AllFieldsAndOldValues LIMIT 1
     
     
     
  • I'm using Navicat Lite 8.0, if anyone needs to know, don't know how relevant that is though...

 

My problem / question:

 

  • I want to modify the table, and then I need to know how, and I'm not very familiar with Mysql, an example of a query would be highly appreciated.
  • Also, I got one other question: What does (memo) mean? Someone told me it might be long text, but I'm not sure, and are there a process to see what the (memo) is, or how to change it ?

 

Also, if you need any further information like table structure and columns indexes [via SHOW CREATE TABLE is preferred] (From the announcement / sticky with guidelines) please tell me how to find it, or what to do, as I'm pretty new to this.

 

An easy-to-understand guide would be highly appreciated. (Any answer will be  :P) I'm like: ???

Link to comment
https://forums.phpfreaks.com/topic/91467-no-primary-key/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.