On a Codeigniter/PHP/MySQL webpage, I'm getting a 1064 error, but my query syntax looks valid to me. Here's my query:
UPDATE bookings SET availability = 'xx' WHERE bookings_id = 2002;
. ...
I have 3 tables. All tables have the same field labels:
tblCyclingRoute
ID, Title, Description, Contents, Featured
tblCyclingHoliday
ID, Title, Description, Contents, Featured
tblM...
I have two columns with a datatype datetime:
Pulll_Req_Time Pull_Compl_Time
2010-02-15 16:00:00.000 2010-02...
Hi all,
I have a table called fancytext and a column called location. I want to remove the first 4 letters from the data in location.
Many thanks
Can MySQL Enterprise edition handle up to 50 GB of data? Is there any limitations in terms of performance, size, etc.
I have a database that was create in msaccess then transferred to mysql using bullzip Access to mysql. I am using access as my front end. It has number of vba sequal and other codes. Is there ...
is there any way to create a datarow and return on mysql procedure for example there are for variable like
a,b,c,d
i am returning this values in concat with splitting but for a healty way i...
These are my tables which are fine:
Counties:
= Co_id , CountyName
Towns:
= Town_id , Co_id , TownNames
Master_info:
= Master_id , Name , Surname , and so on..................
...
How to append a fixed text say (product_) to all the coloumns in a table using sql ?
say the coloumn records are some thing like
1
2
3
4
5
& the new records will become
Product_1
...
Hi there;
We have one mysql server instance having one user and password and that user can reach all the databases in that server instance.
My question is that is it possible to have sep...
Think about there are n table in a databse which named
a1
a2
a3
....
an
is there any way to get aX named tables count and prepare a loop for to write a query like
select xxx from a1
...
I need start storing sets of 10 to 100 MEDINT numbers associated with records of an existing table. I expect that the data will be accessed infrequently but it needs to be preserved. All sto...
Hi experts
I have two tables in my MySQL database. My tables are called "users" and "items". In my current select statement I'm able to select data from the users table where the id matches...
I have a database with msaccess front end and mysql backend. I have create some queries through views in the mysql backend and imported them as link tables in themsaccess front end
I want t...
I need to be able to sort a field that contains both numeric and alpha characters.
Example:
10020
1633
21042
31025
604
70085
80036-B
HB-077
HB-078
HE-037
HE-004
I need them to s...
Hello,
I have 4 tables:
table1
table2
table3
table4
I want to get all the table1.col1's (usernames) sorted by table1.col2 in Ascending order. that meet this criteria
table2.col2...
I've never even touched MySQL, but from what I hear it's a fine product. I have an Access 2000/SQL Server 2005 Express application that is growing, particularly in its need to store and search...
i want to change the SQL DataBase into MySql DataBase... I Attached the Sql Database Queries.. i send me the correct Mysql Database Queries.. reply me soon...
Hi,
I'm trying to convert an MS Access 2003 database with a variety of tables and data into a MySQL database. Just need to exactly replicate it.
I CANNOT (as in am not allowed to ny my h...
Hi,
Need help how do I connect to Mysql in Unix, I tried with Mysql but return not found.
root@protong02 # ps -ef |grep mysql
snf 17447 17284 0 06:51:32 pts/10 0:00 grep mysql
...
Hi there.
I have a MySQL database where an activity is registered. The number '1' (dummy) is registered with a registrationdate. Now... I want to make a query to put into a table (asp) that w...
I've inherited some code and came across this in a sql statement:-
'If(RegisterDate<'01/01/2005',5,10) AS Total' which seems a neat way to tot everything up in a column
However, I would...
I have 2 tables table1 and table2. Both tables have rows that have lots of dupes. Table1 references with a id to proper row in table2. I want to get all the distinct car make and models. E...
Is there a way to mirror a single table in one database in another database. (replicate ?)
Both databases are on same database server.
Many thanks in advace
~Hi,
i am running replication on my server between 2 db's
when i checked the slave status of my db i got the following message:
Queueing master event to the relay log
And when i ch...