Originally posted by suityou01
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: MySQL Basics
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "MySQL Basics"
Collapse
-
Originally posted by chicane View PostI suspect that's the case. I imagine that you can choose from the 'Community Server' (with limited support from the community) or some kind of "corporate edition" where they charge you a squillion pounds a year for their "enterprise level" support.
Hopefully if you download and run the installer, you'll get an option to install client tools only - a bit like you do with MSSQL.
Leave a comment:
-
Originally posted by suityou01 View PostIs the 'old' MySQL now called "Community Server?"
Hopefully if you download and run the installer, you'll get an option to install client tools only - a bit like you do with MSSQL.
Leave a comment:
-
Is the 'old' MySQL now called "Community Server?"
All I can see on the downloads page is
MySQL Community Server.
MySQL Cluster
MySQL Workbench
MySQL Proxy
MySQL Connectors
So which one is it? Doesn't look like any of them to me.
Leave a comment:
-
Originally posted by chicane View PostHmm... MySQL themselves seem to think mysql.exe should be in: "C:\Program Files\MySQL\MySQL Server 5.0\bin\":
http://dev.mysql.com/doc/refman/5.0/...n-layouts.html
If not, you might be best off doing a search for "mysql.exe" on the local drive and letting Windows chug away for 15 minutes while you make a soothing cup of tea. You sound a bit stressed like!
I don't want to install MySQL. Only the client tools.
Leave a comment:
-
Originally posted by Cliphead View PostGot a spare box? Any Linux distro will give you the option to install MySQL or will install it by default along with Apache and PHP.
Cannot see it anywhere on their site though. Girly "GUI" tools yes, manly "command line tools" have been removed.
Leave a comment:
-
Originally posted by suityou01 View PostAnd what is one of those? Man alive since oracle got their mits on MySQL they've buggered around with the site. All I can find is MySQL workbench or QB. I don't want a full MySQL install just the client tools.
http://dev.mysql.com/doc/refman/5.0/...n-layouts.html
If not, you might be best off doing a search for "mysql.exe" on the local drive and letting Windows chug away for 15 minutes while you make a soothing cup of tea. You sound a bit stressed like!
Leave a comment:
-
Originally posted by suityou01 View PostAnd what is one of those? Man alive since oracle got their mits on MySQL they've buggered around with the site. All I can find is MySQL workbench or QB. I don't want a full MySQL install just the client tools.
Leave a comment:
-
Originally posted by chicane View PostThe proper command util is called 'mysql':
Code:######@########:~$ mysql -u(username) -p(password)
If you provide the "-p" parameter without specifying a password, it should prompt you for one.
Leave a comment:
-
The proper command util is called 'mysql':
Code:######@########:~$ mysql -u(username) -p(password)
If you provide the "-p" parameter without specifying a password, it should prompt you for one.
Leave a comment:
-
Originally posted by suityou01 View PostDoes help Chicane, it means I'm not going nuts.
MySQL Query browser under XP is a bad idea. Buggy heap of crap.
Do you know what the 'proper' command based util is called?
Linky
Thank you for the bug report. This is an expected behavior because by
design QB uses a new connection for each query, there is already a
feature request to change this behavior.
Leave a comment:
-
Originally posted by chicane View PostThis probably won't help you much - but it works fine from here:
Code:mysql> create database myDB; Query OK, 1 row affected (0.13 sec) mysql> DELIMITER $$ mysql> mysql> DROP PROCEDURE IF EXISTS `myDB`.`getCurrentPeriodId` $$ Query OK, 0 rows affected, 1 warning (0.40 sec) mysql> CREATE PROCEDURE `myDB`.`getCurrentPeriodId` (OUT currentPeriodId INT) -> BEGIN -> SET currentPeriodId = 500; -> END $$ Query OK, 0 rows affected (0.37 sec) mysql> mysql> DELIMITER ; mysql> CALL `myDB`.`getCurrentPeriodId`(@currentPeriodId); Query OK, 0 rows affected (0.08 sec) mysql> SELECT @currentPeriodId; +------------------+ | @currentPeriodId | +------------------+ | 500 | +------------------+ 1 row in set (0.06 sec)
Code:#####@###########:~$ mysql --version mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
MySQL Query browser under XP is a bad idea. Buggy heap of crap.
Do you know what the 'proper' command based util is called?
Leave a comment:
-
This probably won't help you much - but it works fine from here:
Code:mysql> create database myDB; Query OK, 1 row affected (0.13 sec) mysql> DELIMITER $$ mysql> mysql> DROP PROCEDURE IF EXISTS `myDB`.`getCurrentPeriodId` $$ Query OK, 0 rows affected, 1 warning (0.40 sec) mysql> CREATE PROCEDURE `myDB`.`getCurrentPeriodId` (OUT currentPeriodId INT) -> BEGIN -> SET currentPeriodId = 500; -> END $$ Query OK, 0 rows affected (0.37 sec) mysql> mysql> DELIMITER ; mysql> CALL `myDB`.`getCurrentPeriodId`(@currentPeriodId); Query OK, 0 rows affected (0.08 sec) mysql> SELECT @currentPeriodId; +------------------+ | @currentPeriodId | +------------------+ | 500 | +------------------+ 1 row in set (0.06 sec)
Code:#####@###########:~$ mysql --version mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
Leave a comment:
-
MySQL Basics
I need to get this MySQL stored proc working. I have omitted the guts and glory and gone right back to basics and even that won't frakin work
I am not by any stretch a MySQL developer so please be patient.
Code:DELIMITER $$ DROP PROCEDURE IF EXISTS `myDB`.`getCurrentPeriodId` $$ CREATE PROCEDURE `myDB`.`getCurrentPeriodId` (OUT currentPeriodId INT) BEGIN SET currentPeriodId = 500; END $$ DELIMITER ;
Code:CALL `myDB`.`getCurrentPeriodId`(@currentPeriodId); SELECT @currentPeriodId;
Why?Tags: None
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: