May 23
One example of how to create a new Joomla user using just SQL in LQM.
The example in the LQM forum post isn’t really correct because it only checks the name field, which isn’t part of the jos_users table primary key. In fact the only part of the primary key is the ID field, which is kind of useless. I guess the question then is “what is the natural key”? I’d say the keys to really check for are username, and email address.
In the next part of this article I show the SQL I used to create a user and confirm it will create correctly without errors.
