PRIMARY 0 duplicate problem

[globus102]

Witam mam maluski problem zrobilem rejestracje i wg no i teraz przy rejestracji kolejnego wyskakuje komunikat

 

"DUPLICATE ENTRY "0" for KEY PRIMARY

 

A o to kod

Imports MySql.Data.MySqlClient

Public Class Form2
    Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Form1.Show()
        Me.Hide()
    End Sub

    Private Sub Button_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim con As New MySqlConnection("server=localhost;userid=root;password=;database=login_table")
        Dim cmd As New MySqlCommand
        Try
            con.Open()
            cmd.Connection = con
            cmd.CommandText = "INSERT INTO login_table.users(username, password) VALUES ('" & TextBox1.Text & "' , '" & TextBox2.Text & "')"
            cmd.ExecuteNonQuery()
            MsgBox("Zarejestrowano pomyślnie!")
            TextBox1.Text = ""
            TextBox2.Text = ""
            con.Close()
        Catch ex As MySqlException
            MessageBox.Show(ex.Message)

        Finally
            con.Dispose()

        End Try


    End Sub
End Class

[globus102]

no to teraz chciałbym dowiedzieć sie jak to naprawic

[globus102]

ale w mysql?

[Gość]

Dodaj AUTO_INCREMENT do key.

[globus102]

do key?

no i dalej po wpisaniu "alter table nazwa AUTO_INCREMENT=500" dalej nic nie trybi wyskakuje blad z primary