SQL Question.

[roaddog]

Hey..

How to avoid having multiple values in a column?

When I store the data in SQL, it most likely get me multiple values in the column.

Like I store an account, it can allow me to have 2 or more same account. how to avoid this?

In short, No same values in table.

I hope you get this.

Thanks

[xXMADEXx]

I'm not too good with SQL, so I'm not sure if you can do it only with SQL. However, within Lua, you can run a SELECT query (SELECT * FROM tableName) and check to see if the value you're about to insert is already in the table.

[JR10]

Use the UNIQUE constraint. It would save you having to check first if it exists.