Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+7
Strength to Decrease Rep
-1
94% Quality Score
Upvotes Received
20
Posts with Upvotes
20
Upvoting Members
13
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
4 Commented Posts
~63.1K People Reached
Favorite Forums
Favorite Tags
Member Avatar for veledrom

Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks

Member Avatar for thebsv
0
427
Member Avatar for feoperro

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 …

Member Avatar for sergeik.rndwork
0
570
Member Avatar for eoliva

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 …

Member Avatar for DenaEden
0
4K
Member Avatar for jeyjey88

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 …

Member Avatar for jeyjey88
0
101
Member Avatar for newbie14

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 …

Member Avatar for No woman No war
0
375
Member Avatar for Jenniferlinn

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

Member Avatar for mrcullers
0
332
Member Avatar for architact

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 …

Member Avatar for vamsy143
0
238
Member Avatar for bhuvan83

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 …

Member Avatar for Dr AKM
0
346
Member Avatar for peter_carlos

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 …

Member Avatar for peter_carlos
0
205
Member Avatar for blotind

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

Member Avatar for mwasif
0
120
Member Avatar for turt2live

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 …

Member Avatar for mwasif
0
74
Member Avatar for leakbali

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 …

Member Avatar for mwasif
0
166
Member Avatar for sunny124

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

Member Avatar for sunny124
0
208
Member Avatar for Pprog

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 …

Member Avatar for mwasif
0
134
Member Avatar for Sahilsahni

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 …

Member Avatar for smantscheff
0
150
Member Avatar for lifeworks

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 …

Member Avatar for smantscheff
0
143
Member Avatar for Mr.Ram

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

Member Avatar for mwasif
0
798
Member Avatar for joshuasanders

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 …

Member Avatar for joshuasanders
0
195
Member Avatar for MDanz

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 …

Member Avatar for urtrivedi
0
2K
Member Avatar for niche1

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());

Member Avatar for niche1
0
79
Member Avatar for heshanm

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]

Member Avatar for heshanm
0
124
Member Avatar for silvercats

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 …

Member Avatar for silvercats
0
82
Member Avatar for jaycastr

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 …

Member Avatar for mwasif
0
149
Member Avatar for dyingatmidnight

Not sure if I should out this here or in the php forum, I have a question that's probably gonna include both SQL and php... I'd like to add an image field to a table I have but I've never stored images in an SQL database before and I'm not …

Member Avatar for mwasif
0
114
Member Avatar for Frankey

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?

Member Avatar for mwasif
0
107
Member Avatar for ctkam

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

Member Avatar for htmlCoder101
0
194
Member Avatar for monta2020

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 …

Member Avatar for monta2020
0
87
Member Avatar for ryan1987

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 …

Member Avatar for tomato.pgn
0
124
Member Avatar for baziili

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' …

Member Avatar for mwasif
0
294
Member Avatar for mwasif

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 …

Member Avatar for mwasif
0
91