Hello,
I'm pretty new in MySql. I would like to know how you can copy a statement
like
mysql> INSERT INTO customers ( firstname, surname, title, phone) values (
'Jhon', 'Campbell', 'Mr', 345 987 5500)
in the MySql console in order to avoid typing it each time you want to fill
a new record.
I tri
Hi,
I found the bug in my servlet ,when I run my application it enter one record
to the database without duplicate values.Now I want to clean my table by
removing all duplicate rows .Any thoughts?
Hello,
I'm using Eclipse 3.3 and I use a model class HandlereplyModel.java to
insert values to a mysql database using mysql5.0 server.When I run my
application, I got duplicate values everytime I enter a record.
my java class is :
import java.sql.Connection;
import java.sql.DriverManager;
import
I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
the mysql command shell,
I got an error 1064 (42000): *You have an error in your SQL syntax*;
Here is my code:
mysql> CREATE TABLE memberDetails
-> *(*
->memberId INT NOT NULL AUTO_INCREMENT,
->