3

MySQL 4.1 - Howto convert/cast INT to CHAR/VARCHAR?

view full story
linux-howto

http://www.daniweb.com – Hi, I'm hoping someone out there has the answer to this question: How does one convert a table column's data type from INT to CHAR/VARCHAR? Background: I'm trialing some ID card software and it uses Access as its backend. It has ODBC capability and I'm able to connect to my website's MySQL db alright and even import a number of columns in my table (DATE, other VARCHAR columns). However, whenever I try to import the column that's INT (a two or three digit number), I get a type mismatch (on the ID card end I've chosen every predefined option they offer to no avail) and can't get any further. If I can cast/convert the INT to VARCHAR I think I can get around the ID card software's limited functionality. Can anyone help? Thanks kindly, -creativedynamo (General)

dayu's picture
Submitted by dayu on 03/08/2010 – Made popular on 03/08/2010

Stories similar to MySQL 4.1 - Howto convert/cast INT to CHAR/VARCHAR?

I was asked this on an interview, and would like some feedback...

I have a stored procedure that takes in a varchar parameter IsActive that is either a "YES" or "NO" string.

The stored procedure will query a table that has an Active column with a datatype of bit.

Creating a Simple Shopping cart 3 years 10 weeks ago

Helloo

Im new in Databases. I want to create a simple shopping cart i have a table called product

CREATE TABLE  `products` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `category` varchar(150) NOT NULL,   `name` varchar(100) NOT NULL,   `author` varchar(100) NOT NULL,

Hi I have been having trouble getting the pmadb working in phpMyAdmin v3.2.3 for a while now.

The traditional annoying message below appears:

Quote:

The additional features for working with linked tables have been deactivated. To find out why click here.

When I check whats been enabled all thats not enabled now is:

I want to be able to label the database with a single value, i.e its name, from within the database instead of my application, since it will always be one ID per database.

Table Cleanup Script 2 years 31 weeks ago

I needed some help with a script to fetch and delete all records prior to 3 days from now connecting to sybase from sunos.

Trying to create a table with the script below.

Hi Friends,

I have a file 1

Code: CREATE MULTISET TABLE TEYT_Q9_T.TEST ,NO FALLBACK ,     NO BEFORE JOURNAL,     NO AFTER JOURNAL,     CHECKSUM = DEFAULT,     DEFAULT MERGEBLOCKRATIO     (     XYZ DECIMAL(10,0),       ABC VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,       PQR VARCHAR(20)

MySQL statement 16 weeks 2 days ago

How to create a MySQL statement to check expiry and and deactivate a/c on matched date?

desc mailbox; username varchar pass varchar created datetime expiry datetime active tinyint(1)

I need to expire a/c (username filed) on expiry date which should be active=0

I'm new to MySQL and I have a question about importing data from csv files. I've spent the better part of today googling, trying new solutions, then dropping the table and starting over when a potential solution didn't work.

I have a table, with two columns set as the primary key, and 12 subsequent columns where the data will live for each month.