Replace data in mysql with the same primary key

by: Girish Agarwal | last post by:

Hi All, I have a database consisting of 2 tables. patient_info ( Patient Information ).Looks like lastname VARCHAR(10) fname VARCHAR(10) ssno INT(9) PRIMARY KEY ID INT(4) AUTO_INCREMENT ...

MySQL Database

Fwd: Mysql primary, foriegn and composite keys. Please advise

by: Girish Agarwal | last post by:

--0-474210375-1058976151=:31789 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Note: forwarded message attached. __________________________________

MySQL Database

MySQL tips that I have come across

by: Mike Chirico | last post by:

Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...

MySQL Database

Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13)

by: Brett B | last post by:

I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley)...

MySQL Database

import data MySql with Access from Excel file

by: dimitri | last post by:

i try to copy data from excel into my MySql database which runs on a linux. i use MS Access to access the database. i need to optain the unique id number, and this is where i have some troubles....

Microsoft Access / VBA

what is the command consolidating monthly data MySQL

by: seshu | last post by:

Hi everybody This is seshu i have designed a software for attendence purpose ofcourse it is working fine but iam not not satisfied as the code i wrote there is very messy so i...

MySQL Database

Race condition when inserting data / MySQL 4.0+, MyISAM tables

by: Markus | last post by:

Hello I use a table to cache some informations which need lots of resources to be composed. The first time the info is needed, it will be composed and written to the cache table ($db in the...

PHP

Replace data in report

by: Chris R. | last post by:

Hi, I save radio button information as number in my database 1 = blue 2 = red 3 = yellow In my report, I would like to display the colours instead of numbers. How to do this?

Microsoft Access / VBA

replace data in listbox with tht of textbox

by: angelicdevil | last post by:

ok i have a list of data that gets displayed in listbox... i want tht when i select any value in tht listbox and click on rename it should rename tht in the database with the value i provide in...

PHP

operation on files, replace data in C

by: KrisKris | last post by:

Hi, I have written a program in C to copy data from input file to output file and is works. Now I want to replace some data from input file before the data will be written to output file. see piece...

C / C++

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

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...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

Replace data in mysql with the same primary key

Similar topics