MySQL Database Forum

hello i have two tables ,pelates(firstname,lastname,id_country) and country(country_name,id_country) and a form.i want to insert into tha pelates table the id_country from the other table but i can't.also in my form the countries appear with this code:Country:<?php require_once('../mysqli_connect.php'); $q= "SELECT * FROM country";...

i m making a web-page with a registration form in java using eclipse. All the values that i write in the form are stored in the console on ecplise but i wanted to know that by writing which SQL statement i can store the registration details in MySQL database which i have made in wampserver 2.0 ??

I've got 5 tables that are related; there are other fields in each table, but these are trouble makers. tbl_1 vol_key TEXT(), fil_id INTEGER type INTEGER tbl_2 vol_key TEXT(),

hi, am using query as Select machine_id as MachineID,item_name as Name,SUM(item_quantity) as Quantity,SUM(billed_amount) as BilledAmount,SUM(received_amount) as ReceivedAmount from transaction where DATE(paid_date)='" + rdate + "'Group by machine_id,item_name here rdate , am collecting from UI, string rdate =...

Am working with Dreamweaver, WAMP server as my localhost,the issue is that i have tried on several occasions to connect and create a database with my php script but i end up having no connection nor database in my host, please help me out. Thanks

hi, i want to know the index of row( i know the primary key column value, based on that i want to know the index of that row in data table) here is my code i tried: but it's giving error as:table doesn't have a primary key. c# But my datatable in Mysql database is having primary key column.using (MySqlConnection con = new...

Hi, am developing application in .net,c#. am saving datetime value as: yyyy-MM-ss HH:mm:ss (24 hour format) after saving in database i observed in database , it's stored in specified format . and here the problem is: when i retrieve data , datetime is coming as 12 hour format.

I am a sql server DBA. I don't know anything about MySQL. The problem is that "/var/lib/MySQL" maxed out disk space and caused MySQL to crash. I was able to move all the files to /home and I was also able to restart the server. Problem: Can't find "/var/lib/MySQL" and replication is completely broken. Any help from the community will be highly...

i want to automatically update the database in mysql. i am planning to use PHP but how can PHP help me to update the mysql database automatically after collecting data from GPS. please help me as soon as possible........

I have a table created in my MYSQL Database which contains 5 columns. I need to be able to populate the fields with data by way of a webpage on the server. It has to be ServerSide because my hoster does not allow remote connections. I know that there are quite a few payware packages which allow this, but having no funding available, I need a...

i want to get the most recently added data from MySQL for example, if we have a table named test with column : id the data is inserted as follows: 2, 4, 1, 3 when i type this query : SELECT * FROM test ORDER BY id DESC LIMIT 1 , it returns 4 but i want a query that returns 3 (the last inserted data) can i do this?

i have installed another version of MySQL database, but when i try to make a new connection, this (in the attached picture) appears to me! what shall i do?

input city1 city2 Achterom Groningen Achterdijk Madurai output city Achterom Achterdijk Groningen

INSERT INTO table VALUES (bytes Is A good site); Does this line makes me get data from database with new line or does it prints the sentence concatenated? In other words Does the returned data is as follows : bytes is a good site Or as follows : bytes Is A good site ??

how to solve this error : BLOB/TEXT column 'xxx' used in key specification without a key length given that xxx is a primary key and its type is text

Is it possible to migrate products from one drupal site to another? Help me please :) Thanks

if i want to make new line in one of columns of the schema how can i make it? ex.: he is good boy if i want to insert this line in the column as : he is good boy how can i do that ?

is there any online database server that allow me to insert data like MySQL and also let me able to connect it to java NetBeans ?

i can't find the relation view tab in phpMyAdmin account any help?

when i am trying to back up the TE(Application)config file and TE database back (MySql 5.6)i got this error message C:\Program Files\Tripwire\TE\Server\bin>tetool backup --passphrase 'pass' C:\TE_Backup_20140127\TEconfig.bak C:\TE_DB_20140127\TEdb.bak Error message:mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using...

CREATE TABLE `norm`.`sphone` ( `sid` INT NOT NULL, `phone` VARCHAR(45) NOT NULL, PRIMARY KEY (`sid`, `phone`), CONSTRAINT `sid` FOREIGN KEY () REFERENCES `norm`.`staff` () ON DELETE RESTRICT ON UPDATE RESTRICT);

when i try to connect php script to MySQL for creating & inserting values in a table i get an error msg: Error creating database: Can't create database 'mi_db'; database existsAccess denied for user ''@'localhost' to database 'mi_db'. I am running the php via a wamp server...root directory - www and my database name is mi_db. Please suggest...

The following code works fine select concat( case t1.testColumn when 'value1' then t1.column1 when 'value2' then t1.column2 when 'value3' then t1.column3 else t1.column4 end

I'm trying to look for day of week (i.e. 'Mondays') in a given description of a course which resides in field 'date' and place that day ('Mondays') in a new field 'day'. In such a way we can easily check for conflicts. But I keep getting error. UPDATE wint14 SET day = 'Tuesdays' WHERE date = '%Tuesdays%' I'm a total amateur but I don't...