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

Re: column choices for certain data

2004-10-28 Thread Andy B
... 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: Andy B [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday

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

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:

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

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:

Re: backup table/restore table question

2004-04-13 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:20 AM Subject: Re: backup table/restore

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

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

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

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 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 happens