Re: column choices for certain data

2004-10-28 Thread Andy B
the matter... tnx for the help... - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 4:00 PM Subject: Re: column choices for certain data - Original Message - From: "An

column choices for certain data

2004-10-28 Thread Andy B
Hi... I have a db that I'm writing. It's for a business directory and one of the fields/columns in the table needs to have a list of business types in it (i.e. retail, auto, computer and so on). Since there may be more than one category that a business fits under I was wondering if "SET" is the

mysql browser

2004-10-27 Thread Andy B
Hi. I was wondering how you can edit/change tables and data inside a table with mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in the help that you can edit/change tables and data inside tables if there is enough identifiable information inside the table. What does that mean a

SET column type??

2004-04-26 Thread Andy B
hi.. i am sort of confused about the SET column type... is there any place that i can go that will give a better example of it and how to use/create it than the manual does?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

create table problems??

2004-04-19 Thread Andy B
hi.. i am trying to create this table: CREATE TABLE rnjresort_events ( Id int(25) NOT NULL auto_increment, Type enum('Annual','OneTime') binary NOT NULL default 'Annual', StartDate varchar(200) binary NOT NULL default '', EndDate varchar(200) binary NOT NULL default '', Name varchar(100)

making mysql work with c++

2004-04-16 Thread Andy B
hi... i was interested in making mysql work with c++... how would i go about doing this? to be more exact i use borland builder 6 and i have databases that i want to use with it and dont know how to use it with c++... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: backup table/restore table question

2004-04-12 Thread Andy B
:syntax error so i usually have to edit/comment out those lines so backup tablename is faster and works better usually... - Original Message - From: "Riaan Oberholzer" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Tuesday, April 13, 2004 2

backup table/restore table question

2004-04-12 Thread Andy B
hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my test server into say c:/db_backup/db_

reindex auto_incroment field in myism table?

2004-04-05 Thread Andy B
would anybody know how to reindex an auto_increment field in a table??

md5 and table field types

2004-04-02 Thread Andy B
hi... what would be the best field type and length for an md5 encrypted password sort of thing??

table dumps and md5

2004-04-02 Thread Andy B
Hi, Is it totally possible that when dumping a db to a text file with mysqldump that any encrypted stuff in the tables will be "lost"? when I mean lost I mean that it isnt the same in a text file as it is when it was originally encrypted. I have a problem with creating a table with encrypted p

table handler errors and lost data

2002-04-03 Thread Andy B. Spencer
>Description: Users enter data from a php based web site and receive no errors or warnings of any kind that something is amiss, but the data isn't entered into the tables. When I go to the mysql command line and run commands i get a table handler error. >How-To-Repeat: this happen