I am trying to get VISIO to export a database model, but I can't get it to export the correct things.
I made the connection through the DSN just fine. When I use the export to database wiza...
With a table like this, what i'd like to do is:
Insert a uid, bid, posts and usrnam if they dont exist or else update them with new values.
Hows the SQL Statement to do this.
Also the...
I have a table as shown below, how can I copy the contents from itemName to itemDescb
I need to copy from one column to another column in the same table.
CREATE TABLE `products` (
`PI...
Can somebody please tell me what format I use to insert a date into a table with MySQL? I'm trying to send the query:
UPDATE product SET date_acquired='1982-19-01' WHERE id=2
and I keep ge...
Below is (as simple as I could from a massive data import) a table and one insertion of a record. The problem is that the value going into value1 of 16.7 is getting converted to 9.9
Now, l...
Hiya I have a table with a column called "joined", this is a DATE field and another table with DATETIME.
I will be doing a PHP switch to get each type, so I will do a different query for ea...
I have two tables. One has a bunch of listings.. One has a bunch of votes.. or views or whatever based on Table A.
So Table A has a bunch of listings with Unique ID Numbers.
Table B has info...
Hey all!
I thought I'd have a look at trying to make our update queries more efficient, because our code currently generates multiple update queries when I'd rather just operate on multiple...
hi experts,
is there anyway to clear the screen in mysql command line prompt. Like CLS in windows command prompt
I am using version 5.
thanx in advance
kiranvj
Hello,
I would like to use Visio to "Generate..." a dB for me, and also to "Reverse Engineer..." an existing database.
Currently, I am using MySQL 4.1.12 and Microsoft Visio for En...
Hi X-perts,
I have a date field `Date Listed` formatted as a varchar (string). I need to select all rows from the table where the date is less than N (number of weeks) to the current date.
...
I can not make access remote connetion to mysql.
I have IP adress (xx.xx.xx.xx) and my domain is (www.domain.com)
database name =database_name
user id=user_id
psw=password
pls tell me h...
I have a table called Product with the following fields
product_id, name, description, company, country
where product_id is an automatically generated ID. I have a stored proc to insert ...
Hello Everyone,
I have a question regarding default character set used in mysql. Since now, I have been using latin1 as default character set for mysql. However, I wish not to change it to...
Hi,
I have a problem that i'm not able to drop a table. I did this a lot of times but this time it is throwing me this error as mentioned below and just not letting me to drop the table. Th...
Hi all!
I installed MySQL on debian sarge every thing is ok when i use it localy. but when i try to connect to the server from a other machine in the lan (running sarge also ) A have the f...
I got this error when I try run the command:
ginjas:/# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Can you help me?
BR,
Mário Machado.
When I tried to connect, I got the error below, how to fix it?
ERROR 2003 (HY000): Can't connect to MySQL server on '10.247.5.66' (10060)
I have 5 columns, A,B,C,D, and E.
THere are possible duplicates only in column A and B. I want to create a new table that has only unique values based on A & B, but has all the columns of d...
I'm installing MySQL 5.0.7 on my linux server, and followed the instructions exactly as they are in the MySQL documentation. I installed the server and client RPMs. However, I am getting acc...
I have the following oracle SQL statement. I need it translated into MySQL sql.
Code attached below. Specifically, I don't know the NVL function, Decode and (+) sign in the where clause.
T...
I have XML files ranging from 10Kb to 1.5Gb. They contain product information. (see sample XML file below.) I need to write the product information into a mySQL table using PHP without reading...
for future autoincrements, I want my primary key to start at, say, 5000.
i have tried:
* ALTER TABLE tbl AUTO_INCREMENT = 5000;
* and mysql admin, and flash mysql ad...
Is it possible to get only the datepart from date using mySQL? ie., if I have a date '2003-10-03', is it possible to extract only '03' which is the date part?
I am using a shared hosting service. My application is ASP.NET and I am using MySQL DB V5.0.23-c-nt
I get the error "SELECT command denied to user 'user'@'ip' for table "municipio" when I t...
