- Strength to Increase Rep
- +7
- Strength to Decrease Rep
- -1
- Upvotes Received
- 20
- Posts with Upvotes
- 20
- Upvoting Members
- 13
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks |
|
|
Hi, I would like to know how to export my schema WITH the table rows/content into a .sql script in MySQL (If it's possible). I tried using Forward Engineering with MySQL Workbench but when I select "GENERATE INSERT statements for Tables" it doesn't do it... I tried googling and finding … |
I need to store the values of a textarea tag using a form to submit the value and finally store to a mysql database table. Here is what I have, I am sure its something dumb, but its been a while since I have used php. [CODE] <?php if(isset($_POST['submit'])){ $con … |
|
Hello !! I need help fot the following situation: I have 2 tables: test1 and test2: each one have the same columns name: data test1: column data values (black, white) test2: column data values(white,black,orange, yellow) what sql sentence i can use to show only the values (orange, yellow) the difference … |
|
Dear All, I have a system with the web server(apache) and db(mysql) server install on separate machines. So at times when the traffic is high I can not access my system. So first I would like to know where is the error and where is the error log file will … |
|
Can anybody tell me how many storage engines are there in MySQL and which engine is the default engine in MySQL? Kindly post answer if know it |
|
Hello Guys I want to connect two databases at the same time but it looks like the php is only picking up the second database. One database is on my localhost and the other one is on server, I want to transfer the data from my localhost database to the … |
|
hi every1 i m using mysql as my back end and it runs on whole on intranet in my office. the error i m getting is Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) mESSAGE Too many connections when users r trying to access the webpage. how can i remove the error. plz … |
|
Hello, I have a problem with update in MySql database. In a university system a student apply for what is called a petition then the admin signs it and adds a note. When the admin signs for the first time and enters his note it works. But when the student … |
|
Hi I get my data posted from another form.html page i receive it just fine and decode the json just fine, and the validation works just fine, the only problem is the part where i have to insert the values into the database.. any suggestions.. [CODE] <!DOCTYPE html> <html> <head> … |
|
Hello, What I am trying to do is use the following query: [CODE] SELECT * FROM players WHERE NOT EXISTS (SELECT * FROM raidgroups WHERE players.name=raidgroups.player) AND itemlevel>=346 AND level=85 AND NOT EXISTS (SELECT * FROM verification WHERE players.name=verification.username AND verification.organizer=1) AND suspended=0 ORDER BY RAND(); [/CODE] What the above … |
|
I have more than 420,000 rows articles in my table. I just want to query a data which is has only one row, but it takes too long.. any suggestion? database : mysql, Storage engine : MyISAM mysql_query("SELECT id, title, ... ,postdate FROM table_name WHERE id = 1 the result … |
|
Hi guys, Im getting duplicate records with a select statement. Below is an assignment question that I have to write a query for: 'Write a query that lists only those computers that belong to a department where the department's city is the same as the city that supplied the computer.' … |
|
Hi I would like to know how to create a MySQL statement with Count(*) and natural join. I have a table named iphead and another table named even. iphead has a number of IP addresses and I would like to count the total number using count(*). Next, the even table … |
|
hi, since i have shifted my host these weird characters showed up on website! "ââ" i checked database, they are as it is written there. so when i call something through query they showed up too makes it worse, removing them manually is quite difficult. so please if anyone could … |
|
Hi I have a table storing time-sheet data, including a start & end time. I've set those fields as 'TIME' format, and tried doing the following calculation [code] SELECT SUM(log_end - log_start) AS timetotal FROM time_logs WHERE log_client = 'ECDC' [/code] It returned an integer, which doesn't correspond with any … |
|
Hi, how can we reduce the time of query execution time? I m using mysql. I have to execute one query which select data from lot of tables . It takes more time to execute. Please give me good suggestion for this....... |
|
I'm trying to formulate the proper SQL query to pull a roster up on this database I was asked to produce for my kids' HS band. Arrghh. Any help would be great. I have 3 tables. [CODE][U]student[/U] student_ID {PK} first_name last_name email family_ID {FK} [U]family[/U] family_ID {PK} family_phone [U]adult[/U] adult_ID … |
|
i'm not getting any results for the query. I'm sure it has something to do with the apostrophe and back slashes [code] $search = "q test'yes"; $search = mysql_real_escape_string($search); mysql_query("SELECT * FROM block WHERE name LIKE '%$search%' ORDER BY `id` DESC",$this->connect); [/code] When i echo it out i get this … |
|
What's the notation to add data from a variable to existing data in a field? mysql_query("UPDATE stk SET some_field = '????????????' WHERE id = " . $upc_key . "") or die(mysql_error()); |
|
The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE] |
|
CREATE TABLE `employee`(`employee_no` CHAR(4) NOT NULL,`emp_name` TEXT,`employee_sal` INT NOT NULL,primary key (employee_no); << I typed this and it says there is an error (see below).I can't see what is it.000webhost.com Mysql server [CODE]Error SQL query: CREATE TABLE `employee` ( `employee_no` CHAR( 4 ) NOT NULL , `emp_name` TEXT, `employee_sal` INT … |
|
this query was too hard for me write. so any help is greatly appreciated i have three table , a_device, b_devices and a_app under a_device i have the columns: hostname app_name under b_device i have the columns: hostname cpu_avg mem_avg under c_app i have the columns: app_name department_name I want … |
|
When i do a select on my db. example. a row with the column 'animal' has the value of 'Horse' select * from table where animal = 'horSe' doens't work?! How to make it work full all variations with capital or non capital? |
|
hi, I'm using xampp. By using phpMyAdmin, [CODE] select now() from dual [/CODE] it shows [B]2011-02-14 07:28:57[/B] but suppose today's date is [B] 2011-02-15 07:28:57[/B] is there anyone have rough idea where the date set? i've check the server date is correct 15 feb thankx |
|
i'm working on building my website but i'm facing stupid problem.. i don't know how to create a php file for my html's one to then connect them to the database .. i need my page to able me to insert,update and delete records from my database, and then submit … |
|
table: hometeam awayteam homepoints awaypoints leeds man u 3 0 leeds man u 3 0 man u leeds 0 3 i want to calculate how many points each team has. with the above data leeds should have 9 and man u 0. i have come up wth the following sql … |
|
I tried to import a table intro a database and MySQL give me the next error message: "[COLOR="Red"]MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table_ro2' INSERT INTO 'table_ro2' … |
|
Hello, Is there problem in displaying post submitted time? Take a look at this thread ([URL="http://www.daniweb.com/forums/thread346757.html"]strange error in MySQL query[/URL]) in [URL="http://www.daniweb.com/forums/forum126.html"]MySQL Forum[/URL], it is displaying one hour but when you look at the replies it shows posted time 1 day, 6 hrs etc. Is there any problem going on … |