Question about Sun MySQL

1 Answer

Insert rows to MySQL

Trying to insert a few hundred rows into MySQL, & every time I get an error message, but if I try to do it 50 in a times, I get an error message only once in a while.

What is the best way to insert rows into MySQL?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 71 Answers

Could you give me more info plz

Posted on Jul 30, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Mysql> desc contact_info -> ; --------------


Hi David,

It looks like you're missing two more null's in the third record, the column count is only 21 and you have 23 fields in your destination table.

All your data matches up to the columns, but you'll need to insert ", null, null" before the last paren to cover CompanyURL and companyPhone):

('Karson', 'B', 'Campbell', null, 'Dr.', 'Chief Resident', 'Pediatrics', 'kbc232@mvch.org', null, null, '585-544-1212', 'home', '1955-01-05', 'Wife: Molly Kids: Cassidy, Justine, and Cory.', 'Mountain View Hospital', null, null, null, null, null, null, null, null, null, null )

Sep 06, 2013 | Sun MySQL

2 Answers

Php counter


You might want to note that this is not the most effective manner of creating a counter in PHP. On a few of my websites, I find it is much more effective to simply create a text file, eg. counter.txt and have PHP read that every time the page is loaded, instead of running a MySQL query. Then, have PHP also update the counter.txt file by adding 1 to the number already listed in the file and read to the user.

Mar 19, 2009 | The PHP Group PHP

1 Answer

Mysql database tables+find new inserted or update row using java


After you add the new record into table A, you can use the LAST_INSERT_ID() function to retrieve the value of the auto_increment PK field. Look here for more information on this function: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html

Mar 02, 2009 | Sun Java Programming Language (cdj-275)

1 Answer

Type mismatch in MSFlexGrid Control


type mismatch error occours when there is a mismatch between the value which you are trying to assign to a variable which is dimensioned to store values of another, first you check if the datatypes match each other by applying the break.

Dec 19, 2008 | Microsoft Visual Basic 6.0 for PC

2 Answers

MYSQL Access denied


Hi Buddy,

Try this option....

mysql -u root -p

mysql will then ask you for the password give the proper password.

For changing mysql root password

mysqladmin -u root -p password <<newpwd>>

then mysql ask you to give password this is the old password and now the new password for the root will be newankush.

Sep 10, 2008 | Sun MySQL

1 Answer

MySQL Error


This error means that mysql doesn't have sufficient memory to store the entire query result, so far no rocket science, the first thing you have to do is check your query it might be wrong, is it reasonable that it would return so many rows?

Aug 26, 2008 | Sun MySQL

1 Answer

MySQL Auto Increase


Try this -


CREATE TABLE users (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
login TEXT NOT NULL,
password TEXT NOT NULL,
PRIMARY KEY( id )
);

INSERT INTO users VALUES ( null, 'bob', 'mypassword' );
INSERT INTO users VALUES ( null, 'bill', 'pass' );
INSERT INTO users VALUES ( null, 'sean', '1234' );

Aug 04, 2008 | Sun MySQL

1 Answer

MySQL can't connect Error


Guess you are referring to this error message -

cdfc6ee.jpg

Check your username & password, and make sure that you are authorized to access the server.

If your password & username are correct, there might be a network problem that prevents you from connecting to the machine where the MySQL server is running. To make sure that they are no network failures, click on the "ping" button.

This will "Ping" the MySQL server host. If the host is available (no network failure), you will

receive a message similar to this -

Reply from 127.0.0.1: Time=0ms TTL=128
Reply from 127.0.0.1: Time=1ms TTL=128

If you don't it means there's a problem with the network.

Jul 27, 2008 | Sun MySQL

4 Answers

MySQL Error Messeage


When you install MySQL for the first time, no password is set for root user.
Move to the installation directory of mysql (cd/usr/local/mysql) Set the password for user, using the following command -
./bin/mysqladmin -u <username> password

Enter your password. Then you can connect to the mysql client as
./bin/mysql -u <username> -p <password>

Jul 27, 2008 | Sun MySQL

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

85 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Justin
Justin

Level 3 Expert

2072 Answers

Are you a Sun Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...