MySQL Database Forum

Hi all, I have a curious problem with the ERROR 1044 and 1045: -system: OS X 10.4.3 (bash shell) -bash schell prompt: /~ kssun$ -I have set passwd to 'kssun' -I set path: PATH=${PATH}:/usr/local/mysql/bin - symptom 1

It looks like mysql doesn't have the ability to set a query timeout. Is this true? So in the mean time I created the following perl DBI script to do it for me. #!perl # DBI service name use constant DSN => "dbi:mysql:ABC:localhost"; # database username

You want to check scheduling conflicts and you have a record like: appointments(table): apptID beginningDate endingDate beginningTime endingTime It's easy enough to check if a time is within that record. Say you want to

How can you show SUBTOTALS in the same column as the data, NOT in a separate column? I need to SUBTOTAL in the same column as one of the the data columns, like the subtotals 700 and 800 under Field 3 below (I really have 21 columns). Also I must show one blank row after each resulting group: Field1 Field2 Field3 Field4 entry1 ...

Hiya, I have a series of data in a text file which contains date and rainfall. I want to load the text file into my rainfall table into the database. The text file is 1-Jan-89 1 2-Jan-89 0 3-Jan-89 2 4-Jan-89 0

Suppose I have a MySQL 5 table with a DateTime field in it. The table has two records where the time is blank. Running: SELECT CAST(DateTimeField AS TIME) FROM MyTable shows two records with NULL as the resultset. Running: SELECT * FROM MyTable WHERE CAST(DateTimeField AS TIME)=NULL

Is it possible to append text to the end of an existing record I know of UPDATE sysntax but i want to be able to add additional text to a record eg column text = "hello" amended ist time = "hello world" amended 2nd time "hello world - how are you?"

Hello, Here's my problem. I cannot connect to mysql database using odbc string connections or dns. I keep getting a "cannot connect to mysql server localhost." I'm running windows XP Pro and have installed IIS as my server. I have installed Mysql 5.0 and mysql ODBC driver 3.51.12 in their default locations. Database is up and running...

Hi, Is there a way to recover the deleted rows? We do have a backup but not for all the rows that got deleted. Appreciate some quick help on this. Thanks.

This is the talble user http://i11.tinypic.com/3yegf84.png I tried to insert some value here is the output of the query http://i14.tinypic.com/3yxkghz.png then i tried to change default value .. and here's the output

Using MySQL 5.0 on a xP platform I have a longtext column in my table. Somehow a character has been inserted (or transformed) into some of the records where the carriage/line return strings should be. I should have in hex format 0D 0A. But instead what I have is AC 0A. Is there a way to search for the AC and replace it with 0D?

I installed the latest mysql release on my server today (gentoo linux) and tried to start the mysql server after installation: ------------------------------- /etc/init.d/mysql start *you don't appear to have the mysql database installedyet. *please run /usr/bin/mysql_install_db to have this done. /usr/bin/mysql_install_db *Neither host...

Hi, I want to change DateTime format in MySQL Database Table in dd/MM/yyyy format. Its possible so please provide guidance. Thanks

Hello, Hi am trying to use the --defaults-file with a compiled version of mysql on a Feodra Core 2 based on Linux-2.6.5 I type the following command : /usr/local/mysql4src/libexec/mysqld --basedir=/usr/local/mysql4src --datadir=/usr/local/mysql4src/data --user=mysql4 --pid-file=/usr/local/mysql4src/data/mysql.pid --socket=mysqld.sock...

Hello, My hosting company has MySQL 5 and so do I on my local Fedora Core 5 Linux machine. However, when I import a dump file from their enviornment into mine, I get this error ERROR 1064 (42000) at line 21428: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...

í'm transferring my local files to the remote site. but i just found out that there's no phpmyadmin on my remote.. so what should i do to install it there so that i could copy and transfer my data.

I have tables where I usually store boolean values as tinyint(1) I want to do a query that will display 'Yes' in the place of '1' and 'No' in the place of '0' How to do that? Thank you Mostafa

Please help! I am hunting high and low for an equivalent function for MSSQL's DATENAME function. Here's the spec on the function from MSSQL's Books Online: DATENAME Returns a character string representing the specified datepart of the specified date.

Hi all, new to this ng and trying to run MySQL for the first time ever. The box runs Slackware 9.0 on a Duron, the version MySQL is "mysql-3.23.56-i386-1" as supplied with the distro. Starting mysqld with # /usr/bin/safe_mysqld & gives me

It's taking forever to upload 400,000 records to the database through access/odbc, and I've tried phpMyAdmin's interface but it seems to timeout during import of a CSV file. Is there a better way to import 400,000+ records?

hi all, is there a guid available in mysql? "select newid()" in sqlserver will give a global unique id - uniqueidentifier is the datatype... looks like this: {453A731A-9449-4246-BFE9-6096B9D791C7} thanks, chester

Hi folks, I've searched high and low for solution. Here's the skinny: MySQL Server 5.0 on Windows Server 2003 I have a 156MB sql file I'm trying to import using mysql -uusername -p database < dump.sql I get an error response of: Error 2006 <HY000> at line 145: Mysql Server has gone away. I already increase the max_allowed_packets to...

Hi I am having problems with the HAVING clause. I know it can use aliases but the alias I am using has a space in it, eg 'Device ID' My querry looks like (simplified, devID is a calculation) SELECT devID AS 'Device ID' FROM tblDevice HAVING 'Device ID' = '123' and it does not work

I want to get data which are enter to the database during last 24 hours. This is my query and it is not working. Could anyone please tell me what is wrong in this? SELECT FROM rainfall WHERE Date < DATE_SUB( NOW(), INTERVAL 24 HOUR)

How to get the last inserted id in a table in mysql ? There is a query as $query="select last_insert_id()"; .. But i don't know exactly..