Search Results

Search found 14142 results on 566 pages for 'mysql workbench'.

Page 113/566 | < Previous Page | 109 110 111 112 113 114 115 116 117 118 119 120  | Next Page >

• can we use join inside join in mysql?

  - by I Like PHP

  i have 3 tables structure is below tbl_login login_id | login_name 1 | keshav tbl_role role_id | login_id( refer to tbl_login.login_id) 1 | 1 tbl_stuff stuff_id | role_id( refer to tbl_role.role_id) 1 | 1 i need data in follow format stuff_id | login_name 1 | keshav how to use JOIN to retrive the above data in mysql?

  Read the article

• PHP code to convert a MySQL query to CSV

  - by Reilly

  What is the most efficient way to convert a MySQL query to CSV in PHP please? It would be best to avoid temp files as this reduces portability (dir paths and setting file-system permissions required). The CSV should also include one top line of field names. Cheers.

  Read the article

• Create Chart using PHP-MySQL

  - by Ajith

  I have a mysql table - request_events with three fields; request_eventsid,datetime,type.this table will track all the activities of my website day wise and also type wise.thus,type may be 1 or 2.I need to display an open-chart for understanding the progress.So I need to retrieve the ratio of type2/type1 as input day wise.How can I get all these input for last 30 days from this table.Please give me some idea....It already kill my week end.Please help me

  Read the article

• Select get entire row corresponding to max in MySQL Group

  - by Brian

  When I use Max to find the maximum value of a field in a particular MySQL Group after using GROUP BY, is it possible to get the entire row which contains the maximum value?

  Read the article

• How can I allow NULL values in MySQL

  - by peakUC

  I was wondering how can I allow NULL values in the following code below along with keeping WHERE username = '$username'. here is the mysql code. "SELECT * FROM users WHERE username = '$username' AND user_id <> '$user_id'" I'm trying to check for usernames with the same username but I want all users to have a NULL value if they want.

  Read the article

• ADO.NET Data Services for MySQL

  - by Shalan

  Hey! I've searched high and low for this, and no luck. Is there a way that CRUD methods for a MySQL install (Linux box) be exposed via ADO.NET WCF Data Services? I would really love to leverage this in my WPF app :) Thank u!

  Read the article

• minus value in mysql table not worked

  - by Richa Media and services

  in my mysql table i want to use minus value. if i do 0 -1 = -1 but he work as 0 -1 = 2147483647 what i do for it.

  Read the article

• MySql query taking too long - django on webfaction

  - by fallhunter

  I use django on webfaction, and I've got a "MySql query taking too long" message, the sql is SELECT (1) AS `a` FROM `main_userprofile` WHERE `main_userprofile`.`id` = 98 This is a rather simple sql, why the query taken too long?

  Read the article

• MySql Join using 4 tables

  - by Ionut Flavius Pogacian

  I have 4 tables and i want to join them and extarct 4 values. I wrote the followig MySql Query, but it does not work. select `a`.`id`,`a`.`page` xpage,`a`.`action`, `b`.`header` xheader, `b`.`page_id`, `c`.`content` xcontent,`b`.`page_id`, `d`.`footer` xfooter,`d`.`page_id` join `header` b on `a`.`id`=`b`.`page_id` join `content` c on `a`.`id`=`c`.`page_id` and `a`.`id`=`d`.`page_id` join `footer` d on `a`.`id`=`d`.`page_id` where `a`.`page`='main'

  Read the article

• Simple web general localization/translation backend (using mysql)?

  - by Hendrik

  Hi is there a free avaible translation backend with database avaible which can handle multiple users(no login needed), multiple languages (UTF-8) and provides automatic google translation? I just need this tool to fill a database (preferable mysql) with simple tables like this: language | label | text english | _helloworld | Hello World! german | _helloworld | Hallo Welt! I don't care about export since this will have to be created anyways.. Thanks it would be a real timesaver if something with an usable UI exists already.

  Read the article

• Creating a MySQL view with an auto-incrementing id column

  - by hmemcpy

  I have a MySQL database from which a view is created. Is is possible to add an auto-incrementing id for each row in the view? I tried CREATE ALGORITHM=UNDEFINED DEFINER=`database_name`@`%` SQL SECURITY DEFINER VIEW `MyView` AS set @i = 0; select @i:=@i+1 as `id` ... but that doesn't work in a View. Sorry, my SQL is weak, any help is appreciated.

  Read the article

• python popen and mysql import

  - by khelll

  I'm doing the following: from subprocess import PIPE from subprocess import Popen file = 'dump.sql.gz' p1 = Popen(["gzip", "-cd" ,file], stdout=PIPE) print "Importing temporary file %s" % file p2 = Popen(["mysql","--default-character-set=utf8", "--user=root" , "--password=something", "--host=localhost", "--port=3306" , 'my_db'],stdin=p1.stdout, stdout=PIPE,stderr=PIPE) err = p1.communicate()[1] if err: print err err = p2.communicate()[1] if err: print err But the db is not being populated. No errors are shown, also I have checked p1.stdout and it has the file contents. Any ideas?

  Read the article

• Start for mysql Query PHP

  - by Belgin Fish

  Hi, I'm currently looking to have a mysql query retrieve data and have and a start and limit. So like, select * from table where x = x START AT ID X LIMIT X thanks :)

  Read the article

• MySQL regexp on Indexes

  - by Vivek

  HI, I have query having multiple regexp in where clause. The coloumns contained in the where clause have already been indexed. But the query is not using the indexes. Does MySql regexp cause use of indexes ? If not, what could be the workaround for this ?

  Read the article

• Log all queries in mysql

  - by public static

  Hi, Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all queries for an hour, and dump the log to a file.

  Read the article

• Know if a MySQL server is overloaded with PHP

  - by Francesc

  Hi, It's possible to know if a MySQL server is overloaded (with PHP), and if it's overloaded show a static page (something like Twitter's fail whale)? How can I do it? Thanks!

  Read the article

• MySQL: What's the best to use, Unix TimeStamp Or DATETIME

  - by Axel

  Hello, Probably many coders want to ask this question. it is What's the adventages of each one of those MySQL time formats. and which one you will prefer to use it in your apps. For me i use Unix timestamp because maybe i find it easy to convert & order records with it, and also because i never tried the DATETIME thing. but anyways i'm ready to change my mind if anyone tells me i'm wrong. Thanks

  Read the article

• Best way to add a column in mysql query

  - by PHP-Prabhu

  Can any one please let me know that, I need to add a column dynamically when executing mysql query Table: Table1 -------------------------- col1 col2 col3 -------------------------- Test OK Test3 Test OK Test5 Test OK Test6 from the above example i need to introduce "col2" as new column and its value to be as "OK"

  Read the article

• mysql error #1452 appearing when trying to add a constraint

  - by user1701484

  I am trying to alter a table so That I can add a foreign key constraint in mysql database: ALTER TABLE `Question` ADD CONSTRAINT `FK_question` FOREIGN KEY (`QuestionId`) REFERENCES `Image_Question` (`QuestionId`) ON DELETE CASCADE ; Problem is that it is giving me this error: 1452 - Cannot add or update a child row: a foreign key constraint fails (mobile_app. '#sql-4517_15241', CONSTRAINT FK_question FOREIGN KEY (QuestionId) REFERENCES Image_Question (QuestionId) ON DELETE CASCADE) What does this error actually mean and what are the possible solutions I might have to undertake in order to fix this?

  Read the article

• PHP mySQL - replace some string inside string

  - by apis17

  i want to replace ALL comma , into ,<space> in all address table in my mysql table. For example, +----------------+----------------+ | Name | Address | +----------------+----------------+ | Someone name | A1,Street Name | +----------------+----------------+ Into +----------------+----------------+ | Name | Address | +----------------+----------------+ | Someone name | A1, Street Name| +----------------+----------------+ Thanks in advance.

  Read the article

• Import a Single Field Text File into MySQL

  - by Kirk

  I have a text file that looks like this: value1 value2 value3 There are 32 million lines. Each line is terminated by a \n. The fields are not enclosed or delimited with any characters. I'm trying to import it into MySQL using this code, but it is not working: LOAD DATA LOCAL INFILE 'data.txt' INTO TABLE `table` FIELDS TERMINATED BY '' ENCLOSED BY '' LINES TERMINATED BY '\n' (`column1`) Can anyone tell me what I'm doing wrong?

  Read the article

• MySQL ORDER BY offset

  - by monk.e.boy

  In a MySQL query how would I select: all rows ordered by column 'name' where name 'f' so I'd get Gs, Hs ... Xs, Ys, Zs, As, Bs, Cs ... Fs.

  Read the article

• Mysql - Get # of months and years

  - by jwzk

  Is there any way to get the # of months and years since a date, using the mysql DATE column? So if I enter 1/1/2009.. I want 1 years, 3 months.. and so on.

  Read the article

• How to only select numeric data from mysql?

  - by liuxingruo

  Does mysql have a funcion like is_num() which can allow me determine the data is numeric or not? Thanks.

  Read the article

• APE engine Mysql push data to channel on insert

  - by Fotis

  Hello, i am working with APE Engine (http://www.ape-project.org) and up until now i had no actual problem. The problem is that i would like to use the MySQL module and push data to a channel each time a row is inserted into a table. I've tried to setup a server side module, i created an SQL query but data is fetched only when the server boots. How can i make this work?

  Read the article

< Previous Page | 109 110 111 112 113 114 115 116 117 118 119 120  | Next Page >