473,385 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

mysql damage result set

Hello

I make an regexp select statement over two tables. The Result set comes
Back without errors. But If I look into the resultSets sometimes the
ColumnName is Missing. Anyone knows about this problem or how to fix
this ?
Without the regexp everything is fine:

Kontakte.Id INTEGER
Kontakte.Anrede VARCHAR
Kontakte.Name VARCHAR
Kontakte.nt1 TINYINT

With regexp:
Kontakte.Id INTEGER
..Anrede VARCHAR
..Name VARCHAR
Kontakte.nt1 TINYINT

On MYSQL 4 no errors with regexp ...
Only switching to mysql 5 this error comes ...

Jun 12 '06 #1
1 1334
diwe schrieb:
Hello

I make an regexp select statement over two tables. The Result set comes
Back without errors. But If I look into the resultSets sometimes the
ColumnName is Missing. Anyone knows about this problem or how to fix
this ?
Without the regexp everything is fine:

Kontakte.Id INTEGER
Kontakte.Anrede VARCHAR
Kontakte.Name VARCHAR
Kontakte.nt1 TINYINT

With regexp:
Kontakte.Id INTEGER
.Anrede VARCHAR
.Name VARCHAR
Kontakte.nt1 TINYINT

On MYSQL 4 no errors with regexp ...
Only switching to mysql 5 this error comes ...

For everyone who wants to know ... I think the table was damaged I
dropped and recreate the Table and it works ... but mysql check -> no
error ....

Jun 12 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: B. Pigman | last post by:
There have been many questions as to the viability of MySQL's assertion that it can dictate what constitutes a derived work in order to use the GPL against developers who don't wish their software...
2
by: news | last post by:
We currently have our mySQL server on the same box as the Apache server. For security and load balancing, we're going to be moving the mySQL server to another box. We're already using a single...
12
by: Martin_Hurst | last post by:
It would appear that MySQL is making great strides into the commercial and even the enterprise arena. I am not seeing the same news coverage being said about Postgresql. I believe Postgresql has...
1
by: Joseph S. | last post by:
Hi all, (1) The "standard method" for handling errors when executing queries to a mysql database, which is shown in most tutorials and books is: mysql($query) or die("select/insert/update/delete...
10
by: tuco357 | last post by:
This problem has been vexing me for some time and I thought I should consult the group.... Often times when writing a php script to handle some mysql DB transactions, I must write code that...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
10
by: akapsycho | last post by:
ok here goes, this is killing me. this is my attack script. function attack(){ global $targetname; $healthbefore = getValueID("health", "userdata", $_SESSION); $dmgrand=...
11
by: macca | last post by:
Hi, What should I be using for general MySQL database access? I've been using the traditional mysql extension for ages, but I'm trying to update my style to a more OOP paradigm. I've used...
221
Atli
by: Atli | last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.