Connection to table

[mburt]

Use the MySql command client. Or phpMyAdmin.

[Jas]

Use the MySql command client. Or phpMyAdmin.

But is there nothing else? Can I not just have it read through a table or something? MySql will be a pain for me to manage if I have as many users as I am hoping to have on my new site.

[mburt]

MySql makes everything very easy.

Query for creating the table:

CREATE TABLE users (id int(6) auto_increment NOT NULL,username varchar(15) NOT NULL,password varchar(15) NOT NULL,other fields,PRIMARY KEY(id),UNIQUE id(id),KEY id_2(id))

Then insertion would be as easy as:

INSERT INTO users VALUES('','username','password','other values')

[Jas]

. . . In this case, I'd rather not have to use that. Is that a "no" to my question?

A second idea: is there a way to impot a table into MySQL?

[mburt]

A second idea: is there a way to impot a table into MySQL?

Yes. But it is complex. Try searching the forums, I remember there being something about this before.

[Jas]

That's excellent news! I'll check and see if this solves things for me. It's still not ideal, but oh well. . .

[boxxertrumps]

When i switched from windows to linux, i just copied the mysql data directory into the new directory on linux...