MySQL Database Forum

I get that error when I try to update a table in my database This is my table +----+------------+---------+-----------+ | ID | CPRNR | NAME | SURNAME | +----+------------+---------+-----------+ | 1 | 1234567890 | Ole | Hansson | | 2 | 9876543211 | Ulla | Jensen | | 3 | 1234321234 | Ole | Olsson | | 4 |...

Hi, Can any body tell that suppose i have member table in database1 I want to insert data in to this table, getting data from another database table suppose database2 table And is it possible ? Thank you.

I want to make a scheduled task in windows to do a mysqldump. Someone gave me this .bat to run but I'm not able to get it to work. REM @echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time...

how to create a sequence menttioned below..for number generators. CREATE SEQUENCE sequ START WITH 1 INCREMENT BY 1

hi all how do i make a command line connection to a remote mysql server? for local connections i know it is: mysql -u root dbname how do i connect to a remote server with a password? thanks marc

Hi. I'm trying to create a query that would check a couple of fields, and depending on the results, insert a row into the table. This is what I have so far: SELECT IF( (SELECT count(IP) FROM tbl_CounterLog WHERE Date = NOW() AND IP = '172.0.0.1') > 0, 2, (INSERT INTO tbl_Test(IP, Date) VALUES('172.0.0.1', NOW()))

I was looking for information on how to import an excel file or other text file into a MySql database. I have done this with both access and SQL Server and am looking for a way to do this in MySql. I have several hundred items i want to import into a parts database that is currently in an excel file but can be saved as comma separated or...

Hi all and Merry Christmas! I wanted to ask how would I deal with the following problem: Say I have a table : customerid name 1 nick 2 george 3 harry

This is a bit of a newbie question -- I've just installed MySQL 4.1.13 on a Fedora core 3 system. It installed great. It wasn't hard to get it running and create a few databases. But I can't seem to make the client shell run from anywhere but the mysql/bin directory. I've placed the /usr/local/mysql/bin directory in my PATH, but I still...

Hi Folk How do I use the if then else statement in an SQL statement. I tried this: SELECT (IF SSG.ID = SSI.ID then true else false) a, SSG.ID gid, SSG.NAM gnam, SSI.ID iid, SSI.NAM inam, SSI.NAM inam FROM SSG, SSI

Hey folks, I'm curious about how to perform following task: I need to update a MySQL database every day in terms of deleting expired entries.Therefore, I have to fields in the db named 'date' and 'expired' (which is the actual date ... How do I get that again?). So, I want to run a script that compares both fields and deletes respective...

tinyint(3) smallint(5), mediumint(7) int(10) bigint(15) what are the nubers refering to? bits or bytes? that is to say: tinyint(3) means i can store a number between ( 0 and 7 ) or (0 and 1677721) ??

What I'm looking for is a lazy man's way to define a table structure, using the table headings row in a CSV file. I'd be happy to start with all fields being VARCHAR(50) or some such default, and then making appropriate changes via PHPmyAdmin later. The reason for being this lazy is the number of fields that I need to define - the CSV file is...

Hi i have problem with creating new mysql user im using this code : INSERT INTO user (host,user,password,select_priv,insert_priv,update_priv) VALUES ('localhost','abdoelmasry',PASSWORD('341062'),'Y','Y','Y'); i always get the following message: Field 'ssl_cipher' doesn't have a default value

hi.... How to remove the new line character in the left and right side of the sting value in mysql? Can you any one give me the sample query for this? Regards, S.Ashokkumar

Warning: mysql_connect() : Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /webs/sites/monetized.com/includes/mysql_connect.inc.php on line 2 Lost connection to MySQL server at 'reading initial communication packet', system error: 113 I'm receiving the above error whenever trying to connect to my...

I would like to subtract tow fields in table for example Table1 has fields A, B, C I wrote the statement as follows Select A, B, (A-B) as diff from Table1. MySQL is complaining that there is a syntax error near '-' thank you

Hi Guys, I am new to this forum. So if i made any mistake please bare with me. Soon i ll follow all the guidelines as days pass through. I am getting following error when i try to login to mysql prompt. c:\mysql\bin>mysql -u root -p password:***** ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)

We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I need to know else (e.g. Navicat)? Thanks Phil

in my stored procedure i have some if else statements: SET @status = ""; IF (code is invalid... SET @status = "Invalid code."; SELECT @status; END IF;

Hello. I have mysql working. I have change my hostname name(until now i used localhost) and i cannot connect. # mysql -u mail -p -h server.domain.com Enter password: ERROR 1130: Host '196.26.0.3' is not allowed to connect to this MySQL server # mysqladmin -u root -h server.domain.com -p password 'pass'

Having created a table with a longblob column, what is the insert syntax to set the value of the longblob column? The data will be read from a file.

The meaning of REPLACE INTO is clear to me. IF the new record presents new key values, then it is inserted as a new record. IF the new record has key values that match a pre-existing record, then the key violation is ignored and the new record *replaces* the pre-existing record. But what about INSERT IGNORE? Is this a synonym for...

How would a set of related values be stored together in a MySQL db? For example, if I wanted to store a user's buddy list, then the way I can think of would be something like this: user | friend John | Jim John | Bob John | Amy Bob | Jim Bob | Amy

I have two complex subqueries that I need to join. I suspect this problem is due to using aliases instead of table names, but I don't know how to work around it (temporary tables?). Please help. SELECT col FROM (subquery-1) AS t1, (subquery-2) AS t2 JOIN t1 ON t2.col = t1.col; >>> Not unique table/alias: 't1'. SELECT col FROM...