How to copy an statement in Mysql console

2009-05-14 Thread jean claude babin
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

How to remove the duplicate values in my table!

2008-11-19 Thread jean claude babin
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?

Duplicate values inserted!

2008-11-17 Thread jean claude babin
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

Creating table syntax error with mysql 5.0!

2008-11-15 Thread jean claude babin
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, ->