|
by: Bob |
last post by:
I am making the jump from ASP/Access to PHP/MySQL.
And I really miss the ease of generating sql queries inherent in
access.
I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.
Question: Is there a tool that interfaces to mysql and generates sql
|
by: Madjid Nasiri |
last post by:
Hi,
I am basic in oracle. My Old programs write with Delphi and Databases:
Access, Paradox, MySQL, Microsoft SQL.
I write my code (SQL code) case-insensitivae, but now i need use
oracle database. The Oracle by default is case-sensitive, How can used
case-insensitive in oracle.
Thanks
Madjid Nasiri
|
by: weissborn |
last post by:
I have an application I have written in MS Access 2002. It is a very
basic inventory system for keeping track of information about our
Unix(solaris to be specific) servers. Other admins may want to use it
shortly and running MS Access over the WAN is no picnic. It was
suggested that I port to php and MySql. Having no experience with
either, I'm wondering if this is a viable solution.
The database if very "plain vanilla", i.e.,...
|
by: Geradeaus |
last post by:
I have searched but have not yet found how I can resolve the following
problem :
SELECT adId,
CASE
WHEN adId =1 THEN cityId
WHEN adId =2 THEN regionId
END AS extraField
FROM ad
WHERE extraField <> 0
|
by: jesper.lundstrom |
last post by:
Hi,
We have a mysql database for which I would like to create a
documentation. For this I am searching for some tool that can read the
database structure (either from the mysql instance or from SQL code)
and create a visual picture of table relationships. Does anyone know if
such tool is available?
regards Jesper
|
|
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 case scenario for MyISAM
backend?
Also is it possible to not to lose data but get them corrupted?
|
by: ahardon |
last post by:
I'm looking for a tool that auto generates forms based on a mysql
table.
I need an interface that will allow:
1. picking a list of columns from the table (so a form that inputs
only part of the table's columns is possible to generate).
2. picking a set of validation rules out of a predefined set of
possible validators.
An example usage of the tool will allow a webmaster to alter the
details required for users sign up in two steps:
|
by: tensi4u |
last post by:
Hi everyone.
I'm looking for the ETL tool, we are using Sunopsis 3.0 which was established on 2001 and plan to change ETL tool. Our target sources are MySQL 4.0/5.0 and destination source is DB2 (warehouse) on Linux.
Is there anyone who are using good ETL tool for MySQL -> DB2 ?
Could you recommend which ETL tool is fit for MySQL -> DB2 ?
Thanks.
|
by: MacRules |
last post by:
Found this testing tool,
http://simpletest.sourceforge.net/
I am looking for PHP scripts which can be used as create many
connections to a web server or MySQL back end for stress testing.
From a script, I can just pass 1 argument ( 100 connections) and
GET/POST with URL or execute some SQL to a MySQL back end.
I did write something way back with C/C++ on such tool.
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|