Questions tagged [mysql-5.0]
53 questions
25
votes
2 answers
Using "TYPE = InnoDB" in MySQL throws exception
When I try to execute the following SQL in MySQL, I'm getting error:
SQL:
SQL = "CREATE TABLE Ranges (";
SQL += "ID varchar(20) NOT NULL, ";
SQL += "Descriptions longtext NULL, ";
SQL += "Version_Number int NULL, ";
…
Gokul Nath KP
- 15,485
- 24
- 88
- 126
9
votes
3 answers
What is the best way to store a URL value using MySQL?
I was thinking of storing URL values in my database but I know some URL's sometimes get ridiculously long. I think my MySQL Database is Version 5.0.
I was thinking of using.
VARCHAR(255)
but this will only work for so long. So should I use.
TEXT…
mii
- 601
- 1
- 7
- 8
5
votes
3 answers
How to remove special characters in column with MySQL?
I participate in a project and met a bad design by others,we have a table called task and each task has many users,the task table is as below:
+----------------+---------------+------+-----+---------+-------+
| Field | Type | Null…
flyingfox
- 13,414
- 3
- 24
- 39
4
votes
2 answers
MySql FLOAT datatype and problems with more then 7 digit scale
We are using MySql 5.0 on Ubuntu 9.04. The full version is: 5.0.75-0ubuntu10
I created a test database. and a test table in it. I see the following output from an insert statement:
mysql> CREATE TABLE test (floaty FLOAT(8,2)) engine=InnoDb;
Query…
Gennadiy
- 17,657
- 4
- 26
- 21
4
votes
1 answer
How to write signal function in MYSQL that can be call from Triggers and Stored functions?
In my Database I have a table: Employee with recursive association, an employee can be boss of other employee.
The Table Description:
mysql> DESC Employee;
+-------------+--------------+------+-----+---------+-------+
| Field | Type …
Grijesh Chauhan
- 57,103
- 20
- 141
- 208
3
votes
2 answers
Proper syntax for MySQL 5.0.x FEDERATED table creation?
So I'm trying to create a federated table using the syntax from the docs. Following this, I've created a table like so:
CREATE TABLE `federated_table` (
`table_uid` int(10) unsigned not null auto_increment,
...,
PRIMARY KEY (`table_uid`)
)…
Aurelia Peters
- 2,169
- 1
- 20
- 34
3
votes
3 answers
ERROR 1025 (HY000): Error on rename of .. (errno: -1)
I am using Oracle MySQL 5.0.88 in CentOS 5.7 (64-bit). When i am trying to create an index to the tables means it shows
mysql> CREATE INDEX activity_type_id ON activity_log
(activity_type_id); ERROR 1025 (HY000): Error on rename of
…
Bathakarai
- 1,517
- 6
- 23
- 39
3
votes
1 answer
Adding additional MySQL data folder to server. Ubuntu
Heres the deal. Removed mysql 5.0.xx and neglected to dump a data folder which is on a mounted drive.
I have mySql 5.6.5 now installed and running and the data folder works fine in the default directory. I attempted to switch the data dir in the…
Ben
- 33
- 1
- 1
- 5
2
votes
1 answer
MySQL Show Grants for... is different than mysql.db and information_schema.schema_privileges
I have discovered a difference between show grants for user@host and the mysql.db table. Why is this?
How can I resolve this? We are worried about security.
I ran a show grants against users in mysql.users. In mysql.users the user is…
Alienz
- 118
- 2
- 9
2
votes
2 answers
REGEXP and operator .+
I am trying to use MySql REGEXP to find rows where green and 2012 occurs in the column
I am using .+ in the regexp.
This works:
select 'green 2012-01' REGEXP 'green.+2012'
returns 1
but if I place the '2012' first it returns 0
select 'green…
David Mirwis
- 21
- 1
1
vote
4 answers
Error 1045 access denied for user 'ODBC'@'localhost' (using password no)
I'm absolutely new to this area. I am getting the following difficulty:
When I try the mysql command on the shell, Start->cmd->mysql:
Error 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
I don't know why, because if i…
Aerox
- 669
- 1
- 13
- 28
1
vote
3 answers
Error in SQL Syntax (MYSQL 5.0)
Does anybody know what is wrong in this MYSQL 5.0 syntax?
CREATE TABLE IF NOT EXISTS target (
_id int(11) NOT NULL AUTO_INCREMENT,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
map_id int(11) DEFAULT NULL,
left int(11) DEFAULT NULL,
…
Aerox
- 669
- 1
- 13
- 28
1
vote
1 answer
Cannot start tomcat on port 8080
I have downloaded NetBeans-8.0.1-windows and MySQL 5.0 setup and tomcat 8.5 and successfully installed on win 7 OS.
Now I am trying to start Apache Tomcat but it always shows error like
Starting of Tomcat failed, the server port 8080 is already in…
shital dhanba
- 11
- 1
- 6
1
vote
1 answer
Inserting integer and datetime from PHP to MySQL 5.0 db error
I have tried to find out what's wrong.
The table is conditions_loop. One column is condition_id, and the other one is a datetime type.
the code is this
$dt = date("Y-m-d H:i:s");
mysql_query("INSERT INTO conditions_loop (condition_id, date) VALUES…
DrJonOsterman
- 139
- 9
1
vote
1 answer
