Connection to table

Use the MySql command client. Or phpMyAdmin.

Quote:

---

Originally Posted by mburt

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.

MySql makes everything very easy.

Query for creating the table:

Code:

---

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:

Code:

---

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

---

. . . 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?

Quote:

---

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.

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

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